CODEWITHSUNDEEP
c#asp.net
Binier
Binier

Reputation: 1107

sum values which are loaded in gridview

How can I plus all values of one selected row of a gridview in C# asp.net application? For example I have a gridview in which is only one row. Values of this row are only number. So I want to plus this numbers.

I tried this loop but it writes all gridview numbers(it isn't summing them).

for (int i = 2; i < GridView1.Columns.Count; i++)
{
       int x = 0;
       x += int.Parse(GridView1.Rows[0].Cells[i].Text);
       Response.Write(x.ToString());                    
}

Upvotes: 0

Views: 742

Answers (3)

Binier
Binier

Reputation: 1107

I created method in which I had loop and it worked !!!!!!!

public int Sum()
{
    int z = 0;
    int i;
    int x = 0;
    for (i = 0; i < GridView1.Columns.Count; i++)
    {

        x += int.Parse(GridView1.Rows[0].Cells[i].Text);

    }
return x;
}

It was @N4TKD idea. Thanks to you !!!!

Upvotes: 0

Kelsey
Kelsey

Reputation: 47726

I think you should approach this from a different perspective. The GridView is just a display control and doesn't 'hold' the data it is displaying. You are trying to use data that it really doesn't contain using a 'screen scrape' approach. You should be looking to the DataSource you bound to the grid in the first place and using the data there.

For example:

List<YourObjectWithTheNumbers> lst = something;
yourGridView.DataSource = lst;
ViewState["YourData"] = lst;  // you could use Session instead: Session["YourData"]

So at this point your data is bound and saved for later use so now just update your numbers and rebind to the GridView again:

List<YourObjectWithTheNumbers> lst =
    (List<YourObjectWithTheNumbers>)(ViewState["YourData"]);
int rowTotal = 0;
rowTotal += lst[0].Field1;
rowTotal += lst[0].Field2;
//etc...
yourLiteral.Text = rowTotal.ToString();

At this point you are using the actual data, not pulling it out of the grid that should be used for display purposes. It's also more secure in that you can keep the data source securely stored on the server if necessary (don't use ViewState if this is a concern) so that it can't be manipulated.

Upvotes: 1

Dibu
Dibu

Reputation: 891

In HTML GridView render as table , better you can use Jquery to add the values ,

var total=0;
$('#gridview1').find('tr td').each(function(i, td){ 
            var data= parseInt( $(td).val()); 
            total+=data;
 });

Upvotes: 0

Related Questions