total of columns
-
i want to sum columns as customer sales1 sales2 sales3 sales4 total john 100 150 100 200 550 Maya 200 100 100 300 700 i want to display the column "total" in the gridview how can i do it with code
-
i want to sum columns as customer sales1 sales2 sales3 sales4 total john 100 150 100 200 550 Maya 200 100 100 300 700 i want to display the column "total" in the gridview how can i do it with code
there are a number of ways you can do this. Here is very good http://www.asp.net/learn/data-access/tutorial-11-cs.aspx[^] that shows you different cases
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
-
i want to sum columns as customer sales1 sales2 sales3 sales4 total john 100 150 100 200 550 Maya 200 100 100 300 700 i want to display the column "total" in the gridview how can i do it with code
You can just use this sql: select sales1,sales2,sales3,sales4,sales1+sales2+sales3+sales4 as total from customer