Displaying Total in Footer of GridView and also Add Sum of columns row vise in last Column

Question

In my Asp net App  i have a GridView and i generate the data of column 6  by myself using code behind   by looking at the code below  i have a footer for my gridview  and the problem is my text for column 6  won t appear if i use footer   If i delete the footertext code  then my text for column 6  is appear  what is the problem  both of the code cant use togather  i already set  ShowFooter  True   protected void Page Load object sender  EventArgs e        for  int i   0  i  lt   this GridView1 Rows Count   i                 this GridView1 Rows i  Cells 6  Text    testing            GridView1 Columns 1  FooterText   footer 1              aspx   lt asp GridView ID  GridView1  runat  server  DataSourceID  SqlDataSource1               AutoGenerateColumns  False  DataKeyNames  ID  CellPadding  4               ForeColor   333333  GridLines  None  ShowFooter  True                       onrowdatabound  GridView1 RowDataBound  gt               lt RowStyle BackColor   EFF3FB    gt               lt Columns gt                   lt asp BoundField DataField  reportDate  HeaderText  Report Date  dataformatstring   0 dd MMMM yyyy   SortExpression  reportDate    gt                   lt asp BoundField DataField  sponsorBonus  HeaderText  Sponsor Bonus   dataformatstring   0 0 00   SortExpression  sponsorBonus  HtmlEncode  False    gt                   lt asp BoundField DataField  pairingBonus  HeaderText  Pairing Bonus  HtmlEncode  False  SortExpression  pairingBonus  dataformatstring   0 c     gt                                                          lt asp BoundField DataField  staticBonus  HeaderText  Static Bonus   SortExpression  staticBonus    gt                   lt asp BoundField DataField  leftBonus  HeaderText  Left Bonus   SortExpression  leftBonus    gt                   lt asp BoundField DataField  rightBonus  HeaderText  Right Bonus   SortExpression  rightBonus    gt                   lt asp BoundField HeaderText  Total  SortExpression  total   gt                   lt ItemStyle Width  100px    gt                   lt  asp BoundField gt               lt  Columns gt               lt FooterStyle BackColor   507CD1  Font-Bold  True  ForeColor  White    gt               lt PagerStyle BackColor   2461BF  ForeColor  White  HorizontalAlign  Center    gt               lt SelectedRowStyle BackColor   D1DDF1  Font-Bold  True  ForeColor   333333    gt               lt HeaderStyle BackColor   507CD1  Font-Bold  True  ForeColor  White    gt               lt EditRowStyle BackColor   2461BF    gt               lt AlternatingRowStyle BackColor  White    gt                       lt  asp GridView gt

User · Answer

This code will use gridview sum inside data list   SumOFdata grd DataDetail      private void SumOFEPFWages GridView grd                Label lbl TotAmt    Label grd FooterRow FindControl  quot lblTotGrossW quot              Sum of the total Amount of the day           foreach  GridViewRow gvr in grd Rows                        Label lbl Amount    Label gvr FindControl  quot lblGrossS quot                lbl TotAmt Text    Convert ToDouble lbl Amount Text    Convert ToDouble lbl TotAmt Text   ToString

User · Answer

int total   0  protected void gvEmp RowDataBound object sender  GridViewRowEventArgs e    if e Row RowType  DataControlRowType DataRow    total    Convert ToInt32 DataBinder Eval e Row DataItem   quot Amount quot       if e Row RowType  DataControlRowType Footer    Label lblamount    Label e Row FindControl  quot lblTotal quot    lblamount Text   total ToString

User · Answer

protected void gvBill RowDataBound object sender  GridViewRowEventArgs e                 if  e Row RowType    DataControlRowType DataRow               Total    Convert ToDecimal DataBinder Eval e Row DataItem   InvMstAmount             else if  e Row RowType    DataControlRowType Footer               e Row Cells 7  Text   String Format   0 0      lt b gt     Total     lt  b gt

User · Answer

Sample Code  To set Footer text programatically      protected void GridView1 RowDataBound object sender  GridViewRowEventArgs e              if  e Row RowType    DataControlRowType Footer                   Label lbl    Label e Row FindControl  lblTotal             lbl Text   grdTotal ToString  c                   UPDATED CODE     decimal sumFooterValue   0    protected void GridView1 RowDataBound object sender  GridViewRowEventArgs e                 if  e Row RowType    DataControlRowType DataRow                     string sponsorBonus     Label e Row FindControl  Label2    Text           string pairingBonus     Label e Row FindControl  Label3    Text           string staticBonus     Label e Row FindControl  Label4    Text           string leftBonus     Label e Row FindControl  Label5    Text           string rightBonus     Label e Row FindControl  Label6    Text           decimal totalvalue   Convert ToDecimal sponsorBonus    Convert ToDecimal pairingBonus    Convert ToDecimal staticBonus    Convert ToDecimal leftBonus    Convert ToDecimal rightBonus            e Row Cells 6  Text   totalvalue ToString             sumFooterValue    totalvalue                  if  e Row RowType    DataControlRowType Footer                       Label lbl    Label e Row FindControl  lblTotal               lbl Text   sumFooterValue ToString                      In  aspx Page    lt asp GridView ID  GridView1  runat  server  DataSourceID  SqlDataSource1           AutoGenerateColumns  False  DataKeyNames  ID  CellPadding  4           ForeColor   333333  GridLines  None  ShowFooter  True                   onrowdatabound  GridView1 RowDataBound  gt           lt RowStyle BackColor   EFF3FB    gt           lt Columns gt               lt asp TemplateField HeaderText  Report Date  SortExpression  reportDate  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox1  runat  server  Text   lt    Bind  reportDate     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label1  runat  server                           Text   lt    Bind  reportDate     0 dd MMMM yyyy      gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Sponsor Bonus  SortExpression  sponsorBonus  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox2  runat  server  Text   lt    Bind  sponsorBonus     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label2  runat  server                           Text   lt    Bind  sponsorBonus     0 0 00      gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Pairing Bonus  SortExpression  pairingBonus  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox3  runat  server  Text   lt    Bind  pairingBonus     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label3  runat  server                           Text   lt    Bind  pairingBonus     0 c      gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Static Bonus  SortExpression  staticBonus  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox4  runat  server  Text   lt    Bind  staticBonus     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label4  runat  server  Text   lt    Bind  staticBonus     gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Left Bonus  SortExpression  leftBonus  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox5  runat  server  Text   lt    Bind  leftBonus     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label5  runat  server  Text   lt    Bind  leftBonus     gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Right Bonus  SortExpression  rightBonus  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox6  runat  server  Text   lt    Bind  rightBonus     gt   gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label6  runat  server  Text   lt    Bind  rightBonus     gt   gt  lt  asp Label gt                   lt  ItemTemplate gt               lt  asp TemplateField gt               lt asp TemplateField HeaderText  Total  SortExpression  total  gt                   lt EditItemTemplate gt                       lt asp TextBox ID  TextBox7  runat  server  gt  lt  asp TextBox gt                   lt  EditItemTemplate gt                   lt FooterTemplate gt                       lt asp Label ID  lbltotal  runat  server  Text  Label  gt  lt  asp Label gt                   lt  FooterTemplate gt                   lt ItemTemplate gt                       lt asp Label ID  Label7  runat  server  gt  lt  asp Label gt                   lt  ItemTemplate gt                   lt ItemStyle Width  100px    gt                lt  asp TemplateField gt           lt  Columns gt           lt FooterStyle BackColor   507CD1  Font-Bold  True  ForeColor  White    gt           lt PagerStyle BackColor   2461BF  ForeColor  White  HorizontalAlign  Center    gt           lt SelectedRowStyle BackColor   D1DDF1  Font-Bold  True  ForeColor   333333    gt           lt HeaderStyle BackColor   507CD1  Font-Bold  True  ForeColor  White    gt           lt EditRowStyle BackColor   2461BF    gt           lt AlternatingRowStyle BackColor  White    gt                   lt  asp GridView gt    My Blog - Asp net Gridview Article

User · Answer

lt asp TemplateField HeaderText  quot ExEmp quot  HeaderStyle-HorizontalAlign  quot Center quot  ItemStyle-HorizontalAlign  quot Center quot                                                                      FooterStyle-BackColor  quot BurlyWood quot  FooterStyle-HorizontalAlign  quot Center quot  gt                                                                       lt ItemTemplate gt                                                                           lt asp TextBox ID  quot txtNoOfExEmp quot  runat  quot server quot  CssClass  quot form-control input-sm m-bot15 quot                                                                              Font-Bold  quot true quot  onkeypress  quot return isNumberKey event  quot  Text   lt   Bind  quot ExEmp quot     gt   gt  lt  asp TextBox gt                                                                       lt  ItemTemplate gt                                                                       lt HeaderStyle HorizontalAlign  quot Center quot  gt  lt  HeaderStyle gt                                                                       lt ItemStyle HorizontalAlign  quot Center quot  Width  quot 50px quot    gt                                                                       lt FooterTemplate gt                                                                           lt asp Label ID  quot lblTotNoOfExEmp quot  Font-Bold  quot true quot  runat  quot server quot  Text  quot 0 quot  CssClass  quot form-label quot  gt  lt  asp Label gt                                                                       lt  FooterTemplate gt                                                                   lt  asp TemplateField gt     private void TotalExEmpOFMonth                 Label lbl TotNoOfExEmp    Label GrdPFRecord FooterRow FindControl  quot lblTotNoOfExEmp quot              Sum of the  Total Amount Of month           foreach  GridViewRow gvr in GrdPFRecord Rows                        TextBox txt NoOfExEmp    TextBox gvr FindControl  quot txtNoOfExEmp quot                lbl TotNoOfExEmp Text    Convert ToDouble txt NoOfExEmp Text    Convert ToDouble lbl TotNoOfExEmp Text   ToString                lbl TotNoOfExEmp Text   string Format  quot  0 F0  quot   Decimal Parse lbl TotNoOfExEmp Text

User · Answer

This can be achieved through LINQ with grouping  here a list of items pointed as a data source to the actual grid view   Sample pseudo code which could help coding the actual   var tabelDetails   from li in dc My table     join m in dc Table One on li ID equals m ID     join c in dc Table two on li OtherID equals c ID     where   Condition group new   m  li  c   by new       m ID      m Name   into g select new       g Key ID      Name   g Key FullName      sponsorBonus  g Where s   gt  s c Name     sponsorBonus   Count        pairingBonus   g Where s   gt  s c Name     pairingBonus   Count        staticBonus   g Where s   gt  s c Name     staticBonus   Count           leftBonus   g Where s   gt  s c Name     leftBonus   Count          rightBonus   g Where s   gt  s c Name     rightBonus   Count          Total   g Count      Row wise Total    OrderBy t   gt  t Name  ToList     tabelDetails Insert tabelDetails Count    new    This data will be the last row of the grid       Name    Total      Column wise total     sponsorBonus   tabelDetails Sum s   gt  s sponsorBonus       pairingBonus   tabelDetails Sum s   gt  s pairingBonus       staticBonus   tabelDetails Sum s   gt  s staticBonus       leftBonus   tabelDetails Sum s   gt  s leftBonus       rightBonus   tabelDetails Sum s   gt  s rightBonus        Total   tabelDetails Sum s   gt  s Total

[c#] Displaying Total in Footer of GridView and also Add Sum of columns(row vise) in last Column

Examples related to c#

Examples related to asp.net

Examples related to gridview

Examples related to footer