Grid Calculated column.......................

Question

0.00/5 (No votes)

See more:

Hi,
In my Grid, i have 4 textboxes in item template.
Now i want apply one calculation formula on these textboxes.
I need to auto calculate txt4 value, when values in txt1, txt2, txt3 changed.
My formula is:
txt4 = txt1 + txt2 - txt3
How can i do this, on which event of grid, or on each textbox ontextchanged event.
Any sample code is helpful.
Thanks in advance.

Posted 27-Feb-11 13:34pm

Rohit.Net100

Add a Solution

1 solution

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)

Dave Kreskowiak · Answer 1 · 2011-02-27T14:40:00

Solution 1

OK, so you convert the string values in the TextBoxs to the value types you need, such as Integer or Double, or Single, ..., validate the values, do the calculation and convert the resulting value to a string and put it in the TextBox you need. You'd probably handle the TextChanged event of your source TextBoxs to kick off a method that performs the validation and calculation.

Posted 27-Feb-11 14:40pm

Dave Kreskowiak

Comments

Sergey Alexandrovich Kryukov 27-Feb-11 21:50pm

Enough said, 5.
--SA

Rohit.Net100 27-Feb-11 23:42pm

Any sample example ?

Dave Kreskowiak 28-Feb-11 16:08pm

Nope. I hardly ever do ASP.NET and/or Java work, but the overall procedure is still the same.

Rohit.Net100 28-Feb-11 10:54am

Hi,

I am using below code for calculation column values in grid.
But i am getting Jscript error:
Microsoft JScript runtime error: 'ContentPlaceHolder1_GD_Prod_ctl00_ctl04_TxtPPort' is undefined.

Private Sub GD_Prod_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles GD_Prod.ItemCreated

If TypeOf e.Item Is GridDataItem Then
Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)
Dim T1 As TextBox = TryCast(item.FindControl("TxtPPort"), TextBox)
Dim T2 As TextBox = TryCast(item.FindControl("TxtBFPort"), TextBox)
Dim T3 As TextBox = TryCast(item.FindControl("TxtLOPort"), TextBox)
Dim T4 As TextBox = TryCast(item.FindControl("TxtTSPort"), TextBox)
T1.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
T2.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
T3.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
End If

End Sub

Client side code:
function Total(TxtPPort, TxtBFPort, TxtLOPort, TxtTSPort) {
TxtTSPort.value = parseInt(TxtPPort.value) + parseInt(TxtBFPort.value) - parseInt(TxtLOPort.value);
}