Click here to Skip to main content
12,756,933 members (38,103 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 13:37pm
Rate this: bad
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 -->
  <asp:GridView> <!-- Bind the data based on the day -->
Rate this: bad
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" 

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
Web01 | 2.8.170217.1 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2017
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