How can i do runtime calculation in gridview

kiran kamble

9y818.NET

int R,Q,T=0;

protected void Gridview1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

TextBox txtRate = (TextBox)e.Rows.FindControl("txtRate");

TextBox txtQuantity = (TextBox)e.Rows.FindControl("txtQuantity");

TextBox txtTotal = (TextBox)e.Rows.FindControl("txtTotal");

int R = int.Parse(txtRate.Text);

int Q = int.Parse(txtQuantity.Text);

T += Convert.ToInt32(R * Q);

txtTotal.Text = T.ToString();

}

its showing FormatException was unhandled by user code and input string was not in coorect format and sir this calculation is not working on runtime, because database table is empty and i want to enter the number in runtime, if i enter Quantity "1" and Rate "200" then im pressing the tab i want result in next column

2 Replies

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

kiran kamble9y ago
above code is not working
0
John9y ago
This is what i did on rowdatabound and worked for me
- Take R as decimal (as u have declared it money in database) and while finding control use Row instead of Rows

protected void Gridview1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
TextBox txtRate = (TextBox)e.Row.FindControl("txtRate");
TextBox txtQuantity = (TextBox)e.Row.FindControl("txtQuantity");
TextBox txtTotal = (TextBox)e.Row.FindControl("txtTotal");
string rate = txtRate.Text;
decimal R = Convert.ToDecimal(txtRate.Text);
int Q = int.Parse(txtQuantity.Text);
T += Convert.ToInt32(R * Q);
txtTotal.Text = T.ToString();
}
}
0

How can i do runtime calculation in gridview

This is what i did on rowdatabound and worked for me

- Take R as decimal (as u have declared it money in database) and while finding control use Row instead of Rows