Getting sub total of nested gridview dynamic rows

i am working with nested gridview. where i am having textboxes(item,quantity,price ) and a bound field for total price(value is coming from multiplying previous columns) in nested gridview , where columns text is entered dynamically and calulated text from (item,quantity,price) is obtained in total price bound field . i need the sum of all rows(totalprice) in footer of nested gridview and grand total in label outside gridview.

What I have tried:

under nested gridiview rowdatabound event i have written this code its not working//
{
if (e.Row.RowType == DataControlRowType.DataRow)
{

int tmpTotal = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "txtTotalPrice").ToString());
qtyTotal += tmpTotal;
grQtyTotal += tmpTotal;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblTotalprice = (Label)e.Row.FindControl("lblTotalprice");
lblTotalprice.Text = grQtyTotal.ToString();
}

}

Hi Mohammed,

RowDataBound Event occurs every time when rows gets bound whether it is Header, Body or Footer so Variable you are declaring inside the bound field will every time get created..

It is supposed created outside the bound field

// Declare variables to hold total unit price and quantity sold
int totalUnitPrice = 0;
int totalQuanitySold = 0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Loop thru each data row and compute total unit price and quantity sold
if (e.Row.RowType == DataControlRowType.DataRow)
{
totalUnitPrice += Convert.ToInt32
(DataBinder.Eval(e.Row.DataItem, "UnitPrice"));
totalQuanitySold += Convert.ToInt32
(DataBinder.Eval(e.Row.DataItem, "QuantitySold"));
}
// Display totals in the gridview footer
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[1].Text = "Grand Total";
e.Row.Cells[2].Text = totalUnitPrice.ToString();
e.Row.Cells[3].Text = totalQuanitySold.ToString();
}
}

1 Reply

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

Gautam Parmar9y ago
Hi Mohammed,

RowDataBound Event occurs every time when rows gets bound whether it is Header, Body or Footer so Variable you are declaring inside the bound field will every time get created..
It is supposed created outside the bound field
// Declare variables to hold total unit price and quantity sold

int totalUnitPrice = 0;
int totalQuanitySold = 0;

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    // Loop thru each data row and compute total unit price and quantity sold
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        totalUnitPrice += Convert.ToInt32
         (DataBinder.Eval(e.Row.DataItem, "UnitPrice"));
        totalQuanitySold += Convert.ToInt32
         (DataBinder.Eval(e.Row.DataItem, "QuantitySold"));
    }
    // Display totals in the gridview footer
    else if (e.Row.RowType == DataControlRowType.Footer)
    {
        e.Row.Cells[1].Text = "Grand Total";
        e.Row.Cells[2].Text = totalUnitPrice.ToString();
        e.Row.Cells[3].Text = totalQuanitySold.ToString();
    }
}
0