Grouping result into asp.net gridview

Question

0.00/5 (No votes)

See more:

I have a StudentResult Table..

where field id :
StudentID SubjectCode Marks.
1001 BB101 80
1001 BB102 90
1001 BB103 70
1002 BB101 70
1002 BB102 70
1002 BB103 60

I want to display Total Grouping result into asp.net gridview :

StudentID Total Marks
1001 240
1002 200

Posted 10-Jun-13 19:48pm

Soumen Sekhar Midya

Add a Solution

Comments

kumar2413 11-Jun-13 1:55am

What you have tried so far?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kumar2413 · Answer 1 · 2013-06-10T19:57:00

Solution 1

SQL

SELECT StudentId,SUM(Marks) As TotalMarks 
FROM Tablename
Group By StudentId

Try this and see.

Posted 10-Jun-13 19:57pm

kumar2413

ErBhati · Answer 2 · 2013-06-10T20:00:00

Solution 2

select StudentID,sum (Marks) as Total Marks from tablename group by StudentID

use this Query and Bind the result to the Grid View like this

gridview.datasource=ds.tables[0];(datatable or dataset which u used)
gridview.databind();

please select as answer if it helps....

Posted 10-Jun-13 20:00pm

ErBhati

Updated 10-Jun-13 20:19pm

v2

Abhinav S · Answer 3 · 2013-06-10T20:09:00

Solution 3

This link[^] should help you out.

Posted 10-Jun-13 20:09pm

Abhinav S