Totaling data using another gridview

Posted by Jammyhunt under ASP.NET on 1/26/2014 | Points: 10 | Views : 1348 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello,

i have a gridview like this

name subject marks

ankit maths 20

rajesh maths 30

ankit science 50

ankit english 70

rajesh english 30

rajesh science 50

rahul english 70

i want to total the marks of each person and show in gridview.

like this

no. name total marks

1 ankit 140

2 rajesh 110

3 rahul 70

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajesh_Kumar on: 1/27/2014 [Member] [MVP] Silver | Points: 25

0	You can use datatable compute method. For compute method refer: http://msdn.microsoft.com/en-us/library/system.data.datatable.compute%28v=vs.110%29.aspx http://www.c-sharpcorner.com/Blogs/11423/datatable-compute-method.aspx http://www.codeproject.com/Questions/111761/DataTable-compute-with-group-by http://www.codeproject.com/Questions/402176/How-to-use-the-Compute-to-calculate-the-total Rejesh Kumar Jammyhunt, if this helps please login to Mark As Answer. \| Alert Moderator

You can use datatable compute method.

For compute method refer:
http://msdn.microsoft.com/en-us/library/system.data.datatable.compute%28v=vs.110%29.aspx
http://www.c-sharpcorner.com/Blogs/11423/datatable-compute-method.aspx
http://www.codeproject.com/Questions/111761/DataTable-compute-with-group-by
http://www.codeproject.com/Questions/402176/How-to-use-the-Compute-to-calculate-the-total

Rejesh Kumar

Jammyhunt, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Snaveen on: 2/13/2014 [Member] Starter | Points: 25

0	Hi, dont do this type of complex actions in your application you can do this on your stored procedure itself. Based on name of the person you just grouping and calculate the sum of the marks. EX: select sum(marks),name from tablename groupby name Jammyhunt, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts