Can not sum GridView column with a variable

Nitol Biswas

10y883.NET

I want to sum GridView column value with a variable and show the result in second column. I am trying to do this.But when I convert the GirdView column into an integer the following

"Input string was not in a correct format." Error is occuring.

Please help.

Here is my C# code:

for (int i = 0; i < GridView1.Rows.Count; i++)

{

long sum = openingBalace + Convert.ToInt64((GridView1.Rows[i].Cells[6].Text));

GridView1.Rows[i].Cells[8].Text = sum.ToString();

}

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Check what is the value you are getting in GridView1.Rows[i].Cells[6].Text. Mostly it doesn't contain any integer value. Debug it and check the value whether it is correct..
0
Amit Gupta10y ago
Hey Nitol
You can use an alternate option to put expression formula in your datatable's column when binding like
DataTable.Columns.Add("tax").Expression = "UnitPrice * 0.086";
// it will calculate your result based on expression, no need to loop and calculate

Refer below link
https://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(v=vs.110).aspx

Now coming to your current issue, it is just because of your data which is either blank pr null or contains some illegal characters that you might converting to long.

Hope it helps
0
Nitol Biswas10y ago
Openingbalance is a long type variable @Salman
0
Salman Beg10y ago
Openingbalance is of what type? i think you should convert openingbalance also. Thanks
0