Click here to Skip to main content
12,290,522 members (33,192 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
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
Posted 3-Oct-12 12:37pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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.


<asp:Repeater> <!-- Get unique days -->
 <ItemTemplate>
  <asp:GridView> <!-- Bind the data based on the day -->
 </ItemTemplate>
</asp:Repeater>
  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

put a textbox in the footer control then find the textbox control using
 
textbox txtSum= gridview1.FooterRow.FindControl("txtTotal") as TextBox
 
Then bind the total value to txtSum like how you will bind data to grid
 
txtSum= "select sum(income) from incometable" 
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160518.1 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100