Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sheena
Starting Member
45 Posts |
 Posted - 2007-06-06 : 14:13:25
|
| Hi to all, I have a field of amount.I want to make the summary total of that amount field. Is it better to do in asp.net with C# in Gridview footer row or sqlserver 2005 ?I have the Amount field 50 66.75 ----------- 116.75--------------------------------------------- How to take that total in the footer of gridview ?thanxss...... |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-06 : 14:16:59
|
| how many rows are you returning to the front end? Probably better in the footer of gridview...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-06-07 : 05:36:46
|
quote:
Originally posted by sheena
Hi to all, I have a field of amount.I want to make the summary total of that amount field. Is it better to do in asp.net with C# in Gridview footer row or sqlserver 2005 ?I have the Amount field 50 66.75 ----------- 116.75--------------------------------------------- How to take that total in the footer of gridview ?thanxss......
Basically it is better to do such calculations, formatting (i.e. Date, currency) etc at Front End. Use SQL only to get rough data.Mahesh |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-07 : 10:12:25
|
| Yes. You can easily show sum at the endIf you need some help post at .NET related forumsMadhivananFailing to plan is Planning to fail |
|
|
|
sheena
Starting Member
45 Posts |
Posted - 2007-06-08 : 17:19:06
|
| Thanxs...already tried in asp.net with C#But,not getting the total value...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84765 |
|
|
|
|
|
|
Amount field