how we add columm i n datagrid as we have some columm which we have not in table.
how we can add columm in datagrid for this.Please help me about this situtaion
suppose we have
table in our database
Amounttable
amount Date Schema
12000 12/12/2005 1
15000 03/04/2006 2
15000 06/05/2006 3
Ratetable
Schema Rate
1 12
2 5
3 8
create a interstclass in which write the code for this
if no of days is less than 90 days from current date interest is zero.
if no of days is greater than 90 days from current date calculate interest.
For schema 1,2 calculate Simple Interest.
For schema 3 calculate compound interset.
and show the result in webform data grid which consist of
amout date schema noofdays Rate Interest
Don't modify the table in Database
