Java Script Needed to loop a DataGrid

Question

0.00/5 (No votes)

See more:

Dear all;

I have one DataGrid. In that the user can add and remove the rows in that grid. So in this case in my datagrid i have one amount column.

Now,I need to loop that amount column and i need to sum it and i have to fill the summed value in one textbox(Total Amount) which is in the same form but outside the grid.

I have used the onkeyup property for the particular ItemBound Textbox(Amount) Column like onkeyup="SumValues();".

So how can i acheive this using JAVASCRIPT ..

Please help me.. Thanks in advance :-)

If my question is not understandable kindly revert me.. Waiting for the reply..

Thanks again...

Posted 12-Dec-12 2:05am

GANESH KUMAR K

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)

Krunal Rohit · Accepted Answer · 2012-12-12T02:08:00

Solution 1

Refer this[^]

Posted 12-Dec-12 2:08am

Krunal Rohit

Comments

GANESH KUMAR K 12-Dec-12 8:13am

Dear Rohit thank you for your response. In my office i dont have the access to that particular URL Which you have given. Anyway let me check with my home and Update you my result soon.. Thanks alot for being Responsible... :-)

IpsitaMishra 12-Dec-12 8:22am

here is the code in the page

function GetTotal() {
totalDTH = 0;
totalMCF = 0;

// Get the gridview
var grid = document.getElementById("<%= grdVolumes.ClientID%>");

// Get all the input controls (can be any DOM element you would like)
var inputs = grid.getElementsByTagName("input");
// Loop through all the DOM elements we grabbed
for (var i = 0; i < inputs.length; i++) {

// In this case we are looping through all the Dek Volume and then the Mcf volume boxes in the grid and not an individual one and totalling them
if (inputs[i].name.indexOf("txtDekVolume") > 1) {
if (inputs[i].value != "") {
totalDTH = totalDTH + parseInt(inputs[i].value);
}

}
if (inputs[i].name.indexOf("txtMcfVolume") > 1) {
if (inputs[i].value != "") {
totalMCF = totalMCF + parseInt(inputs[i].value);
}

}
}
}

GANESH KUMAR K 13-Dec-12 2:37am

Thank you IpsitaMishra for your help :-) Thanks alot :-) I got Output... Thanks again..

GANESH KUMAR K 12-Dec-12 23:10pm

Very Good morning Rohit Thanks alot.. :-)

[no name] 13-Dec-12 0:09am

If you're satisfied with the given answer, Accept the Solution :)

GANESH KUMAR K 13-Dec-12 0:36am

Sure i'll... And i'm getting error.. Wait i'll explain clearly..

GANESH KUMAR K 13-Dec-12 0:38am

Thank you "IpsitaMishra" thank you for your help...

GANESH KUMAR K 13-Dec-12 0:46am

Dear Rohit;

Actually the SCRIPT LINE which from the above codings like

var inputs = grid.getElementsByTagName("input");

I'm having some doubt with this..

Here instead of "input" what i have to use...

Can you guide me..

Actually While debugging the javascript in the for loop i'm getting the value in totalAmount(Which i entered in the corresponding Itembound textbox)
and the loop is again entering into the if condition
and again changing the total amount as "NaN"

So instead of the "input" what i have to do..Can you explain pls... Thanks in advance :-)

GANESH KUMAR K 13-Dec-12 0:49am

Here I'm getting the inputs value as 14 and loop is getting excecuted 14 times ... But it entering twice into the if condition eventhough i have only one row in grid..

My changed Coding is this

Code:

function GetTotal() {
totalAmount = 0;

// Get the gridview
var grid = document.getElementById("<%= grdActivity.ClientID%>");
// Get all the input controls (can be any DOM element you would like)
var inputs = grid.getElementsByTagName("input");
// Loop through all the DOM elements we grabbed
for (var i = 0; i < inputs.length; i++) {

// In this case we are looping through all the Dek Volume and then the Mcf volume boxes in the grid and not an individual one and totalling them
if (inputs[i].name.indexOf("txtGridAmount") != "") {
if (inputs[i].value != "txtGridAmount") {
totalAmount = totalAmount + parseFloat(inputs[i].value);
}
}
}
document.getElementById("txtTotalAmount").value = totalAmount;
}

GANESH KUMAR K 13-Dec-12 1:58am

Thank you Rohit I got it.. The codings which you guided was really usefull to me. Thanks alot.... :-) Happy :-)