Calculating a value in GridView when other values change

Question

0.00/5 (No votes)

See more:

I'm working with a GridView on a VB.NET ASP.NET page.

When the user edits a row and change the Time In or Time Out value, I need to recalculate the Total Hours value and fill it in for them.

The SQL table actually stores the Total Hours as field even though it's calculated from the Time In and Time Out.

The page needs to fill in the hours anytime the user edits and changes the Time In or Time Out.

I am struggling with doing this. I know how I'd do it with Windows forms, but in ASP.NET the Textbox in the EditTemplate doesn't seem to have the same Events and I can't figure out how to change the Textbox value from another EditTemplate than the event was fired.

Any help would be greatly appreciated.

Posted 4-May-12 6:56am

ARBebopKid

Add a Solution

Comments

Maciej Los 4-May-12 13:43pm

TextBox in Web.UI.WebControls have TextChanged event. Use it ;)

3 solutions

Solution 1

Hi,
As if I am not wrong you are trying to get the total number of hours spend based upon the login and log out time entered by the user. So calculation has to done in Row Update command of gridview.
Please follow the link below to calculate the hour value:

http://www.dotnetspider.com/resources/458-How-find-difference-between-two-Dates-C-or.aspx[^]
http://stackoverflow.com/questions/4946316/showing-difference-between-two-datetime-values-in-hours[^]

-AK

Posted 4-May-12 19:05pm

AmitKumar89

Solution 2

if you load gridview with dataset then it have one method dataset.Haschanged return you the total change done in that gridview which you can campare with old data or do any process that u need

Posted 5-May-12 3:01am

Member 4356223

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)

ARBebopKid · Accepted Answer · 2012-05-10T05:28:00

I was able to figure out how to create the totals

VB

Dim colTotals(7) As Decimal, rowTotal As Decimal, pageTotal As Decimal
Dim boxBind As TextBox, labelBind As Label
Dim boxValue As Decimal, boxString As String

For Each row As GridViewRow In GridViewTimeSheet.Rows
    rowTotal = 0
    For col As Integer = 1 To 7

        boxBind = row.FindControl("TextBoxHours" + col.ToString())
        If (Not boxBind Is Nothing) Then
            boxString = boxBind.Text
        Else
            labelBind = row.FindControl("LabelHours" + col.ToString())
            boxString = labelBind.Text
        End If

        If (Decimal.TryParse(boxString, boxValue)) Then
            colTotals(col) = colTotals(col) + boxValue
            rowTotal = rowTotal + boxValue
            pageTotal = pageTotal + boxValue
        End If
    Next
    labelBind = row.FindControl("TotalHours")
    labelBind.Text = rowTotal.ToString("0.00")
Next

For col As Integer = 1 To 7
    GridViewTimeSheet.Columns(col * 4 + 4).FooterText = colTotals(col).ToString("0.00")
Next

GridViewTimeSheet.Columns(33).FooterText = pageTotal.ToString("0.00")