How to get dynamic Gridview textbox template column value sum

Question

0.00/5 (No votes)

See more:

Hi
I need to find the sum for total amount column in dynamic gridview textbox

<asp:TemplateField HeaderText="Total Amount">
  <ItemTemplate>
  <asp:TextBox ID="totaltb" runat="server"></asp:TextBox>                                
</ItemTemplate>                            
</asp:TemplateField>

TextBox box5 = (TextBox)ItemGv.Rows[rowIndex].Cells[4].FindControl("totaltb");

Please help

Thanks

Posted 8-Dec-11 15:10pm

Lancy.net

Add a Solution

2 solutions

Solution 2

Hey
you can add footer Template in the your GridView (ItemGv).

C#

<FooterTemplate>
     <asp:Label ID="lblsum" runat="server"></asp:Label>
 </FooterTemplate>

Also handle the RowDataBound() event for it.

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
 if (e.Row.RowType == DataControlRowType.DataRow)
 {
  decimal rTotal = Convert.ToDecimal
              (DataBinder.Eval(e.Row.DataItem, "totaltb"));
  grsum = grdTotal + rTotal ;
 }
 if (e.Row.RowType == DataControlRowType.Footer)
 {
  Label lblsum= (Label)e.Row.FindControl("lblsum");
  lblsum.Text = grsum.ToString("c");
 }
}

Posted 8-Dec-11 18:24pm

nilesh ubhe

Updated 8-Dec-11 18:50pm

v2

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Eduard Lu · Accepted Answer · 2011-12-08T15:33:00

Solution 1

Try this:

C#

int sum = 0;
TextBox txt;
foreach(GridViewRow row in ItemGv.Rows)
{
   txt = (TextBox)row.Cells[4].FindControl("totaltb");
   sum += Convert.ToInt32(txt.Text);
}

Regards,
Eduard

Posted 8-Dec-11 15:33pm

Eduard Lu

Comments

Lancy.net 9-Dec-11 0:14am

Thanks Friend

[no name] 9-Dec-11 0:21am

you are welcome :)

How to get dynamic Gridview textbox template column value sum

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

How to get dynamic Gridview textbox template column value sum

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us