updating another table's column with presnt gridview's total

Greets everybody

i have a salary table like this

table1(gridview)

sl.no name salary

1 raj 1000

2 aman 1200

3 khan 900

4 jammy 1100

total 4200

and i have another table like this

table2
sl.no name total salary

1 total 0

how to update table2′s column total salary with total of table 1

Try this

update Table2 set
Table2
.Totalsalary=T1.totalsalary
f
rom Tabel1 T1 where
Table2
.SLNo=T1.SLNO

total of the first table is footer, it doesnt getting stored in database

I didnt get u. what do u want to say.?

total amount which is equal to 4200 is just get show on the footer of table1.. it is not getting stored in database

Leave a Reply