Click here to Skip to main content
15,879,095 members
Articles / Programming Languages / C#

How to add up value of a particular column in datagridview

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
3 Oct 2012CPOL 0  
I am not sure if this is the right answer, tho you can use two controls to achieve what you want.Use a Repeater which gets the unique days and then put the GridView inside that repeater.Use the footer of the GridView to show the Sum of Income column. <!-- Get unique...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
3 Oct 2012Ese ochuko 2 alternatives  
Hi friends i have a datagridview that retreive information from a db. My db has a table that has a column called income, now what i want is a way to sum up the value of the income column at the end of everyday to get the total income for that day. Please i need help on this thanks in advance
Please Sign up or sign in to vote.
3 Oct 2012Samsani.v.s.Durga Prasad
put a textbox in the footer control then find the textbox control usingtextbox txtSum= gridview1.FooterRow.FindControl("txtTotal") as TextBoxThen bind the total value to txtSum like how you will bind data to gridtxtSum= "select sum(income) from incometable"

License

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


Written By
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions