Sum score from database table

Question

Hi Experts I am a beginner in c#. I am doing a scoring system in c# and there is column name score. How do i sum up my values from my score column in gridview and get the total score(text)? Hope you can help me urgent. Thanks. Regards Angel

Micke Blomquist · Answer

Hi Angel Just use the property Count of the datatable to devide the total sum with the rows in the table that will give you the average: this .lblYourLableDisplayingTheAverageValue.Text = (sum_of_score / dt.Rows.Count).ToString()

Micke Blomquist · Answer

Hi again Angel Could this short example be useful? Your aspx page: asp : GridView ID =gvScores runat =server AutoGenerateColumns =true ondatabound =gvScores_DataBound ShowFooter =true> asp : GridView > In your aspx.cs file: protected void gvScores_DataBound( object sender EventArgs e) { try { DataTable dt = ( DataTable )gvScores.DataSource; i nt sum_of_score = 0; foreach ( DataRow dr in dt.Rows) { sum_of_score += Int32 .Parse(dr[ score ].ToString()); } gvScores.FooterRow.Cells[1].Text = sum_of_score.ToString(); } catch ( Exception rror) { Response.Write(rror.Message); } } This assumes your column holding the scores is named score. Just make sure that the ShowFooter is set to true and that you have the correct column name in the sum function and that you select which cell in the footer you want to hold the result. ( gvScores.FooterRow.Cells[ !!!!! ].Text ) Okay?

Angel Park · Answer

Hi Micke. Yes i have marked as answer for two of your entries thanks really great help kudos to u :)

Micke Blomquist · Answer

Please mark as answered so others can use our answers as well. Thank you!

Angel Park · Answer

Hi Sorry. Any experts know how if i want to do average of total score?

Angel Park · Answer

Hi Micke it works! THANKS FOR YOUR METHODS!!! REALLY APPRECIATED!!

Angel Park · Answer

Hi Micke. Really appreciate your help and reply i will try it out now :) Thanks for solving my agony over generate sum! :D

Micke Blomquist · Answer

Hi Angel There should not any problem the DataBound event is happening in the aspx page and you can use the data there no matter where your data comes from or how you have choosen to design your application.

Angel Park · Answer

Hi Micke. Appreciate your great help i will try this out :) but i am not sure if i can use it for 3-tier? Because i asm using 3-tier to stored my data in different places there are stored procedure aspx.cs and database.cs

Micke Blomquist · Answer

Hi again Angel Glad to assist you. To display the total sum value in some other place than in the footer just use the variable sum_of_score to assign the value to a Label or a TextBox Text property like this: this .txtSumOfTotalScores.Text = sum_of_score.ToString(); or this .lblSumOfTotalScores.Text = sum_of_score.ToString(); Where the txtSumOfTotalScores or lblOfTotalScores should be replaced with the name of your control.

Angel Park · Answer

Hi Micke thanks for your wonderful help. Thanks for your code too by the way how do i display it in textbook/label ? I want to show the overall score out as well. :)

Angel Park · Answer

Hi suthish I can insert new records in the Gridview i want it to response and redirect to the total with the mutiple records of the score from the same user and the latest one i have just created and total up. I am using 3 tier too. :)

Suthish Nair · Answer

Hi Angel You need to provide more information about your thread. 1. How you populating the GridView? If from DB table then why create an sql statement for sum values. 2. Or  you entring values in GridView and to show the data in another column?

Angel Park · Answer

Hi. This was really helpful to me! Thanks. Do you have a full examples for the aspx.cs? Like from  protected void gridview(object sender GridViewRowEventArgs e).... to the declaring of text like how can i declare my variable sum of score to make it my total sum? Thanks. Sorry I am not so familiar with c#.

Micke Blomquist · Answer

Hi Angel You can loop thru the the rows in the datatable to sum it up: int sum_of_score = 0; foreach ( DataRow dr in dtScores_table.Rows) { sum_of_score += Int32 .Parse(dr[ scores ].ToString()); } Now holds the variable sum_of_score the total score.