I have sql table, it have contract,amount,date like field.
I create a asp.net web page with gridview bind a data in that sql table.
if i select some month i can show data in gridview.
now i want to get a bought forward balance in a variable.
our financial year is a 01/April. if I select date is Mar/2012 i want to get a total amount in sql table in 01/April/2011 to 29/Feb/2012.
How i do it...
Please help me.......