how to calculate avarage marks

Question

0.00/5 (No votes)

See more:

Hi all

In my application i am inserting below values in database and displaying in grid.

name
subject
marks

now i have another grid where i have to display below information

name
average

average will be calculated as total_marks/300

total_marks is sum of all subject marks.

Please tell me how to display this..

Posted 7-Jan-14 6:44am

Snehasish999

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Jan-14 12:59pm

Please show your progress and indicate the problem.

Snehasish999 7-Jan-14 13:01pm

so far did like this

SqlCommand cmd1 = new SqlCommand("Select name from student", con);
con.Open();
String value = cmd1.ExecuteScalar() as String;
if (TextBox1.Text.Equals(value))
{
SqlCommand str = new SqlCommand("")
}
now i want to do like sum of marks column/ 300 and display in grid.

Snehasish999 7-Jan-14 13:23pm

i have this query

select AVG(marks) from student
where name='snehasish'

It's giving me the average but i want the student name also.
if i include name it's giving error

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Jan-14 13:41pm

Use like...

SELECT name, AVG(marks) FROM student
WHERE name='snehasish'
GROUP BY name

Snehasish999 7-Jan-14 13:48pm

name i am taking from textbox..how to pass the textbox value to the sqldatasource query

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Jan-14 23:30pm

What have you tried to do for passing name?

bowlturner 7-Jan-14 13:44pm

By the way, that will only give you the average if and only if the total possible points is always 300.

1 solution

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)

OriginalGriff · Accepted Answer · 2014-01-07T07:34:00

Solution 1

Try:

SQL

SELECT [name], SUM(marks)/300 AS Average
FROM student
GROUP BY [name]

[edit]AVG changed to SUM to match OP - OriginalGriff[/edit]

Posted 7-Jan-14 7:34am

OriginalGriff

Updated 7-Jan-14 7:36am

v2