Gaurav Kumar
Hi All,
I want to show total in gridview's footer. If I had template field or bounded field in my gridview I could have done it before but in my scenario it's different.
I need to show total for all columns except the first column because it doesn't have integer it's a string.
Below is my gridview.
<asp:GridView ID="GVReport" runat="server" Width="1200px" CellPadding="4" EnableModelValidation="True" AllowPaging="True" onpageindexchanging="GVEmployee_PageIndexChanging" ForeColor="#333333" GridLines="None" ondatabound="GVReport_DataBound" onrowdatabound="GVReport_RowDataBound" ShowFooter="True"> <AlternatingRowStyle BackColor="White" /> <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" /> <HeaderStyle BackColor="#006666" ForeColor="White" Font-Bold="True" /> <PagerStyle BackColor="#006666" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#ffcc00" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> </asp:GridView>
and here I am binding the gridview
protected void Bind_Grid() { DateTime Date; DateTime.TryParseExact(lblDate.Text, "dd/MM/yyyy", new CultureInfo("en-US"), DateTimeStyles.None, out Date); Business_Logic bal = new Business_Logic(); DataTable dt = new DataTable(); dt = bal.TMS_Report(Date.Date, lblEmpCode.Text); if (dt.Rows.Count > 0) { GVReport.DataSource = dt; GVReport.DataBind(); GVReport.Visible = true; } }
Gridview is binding perfectly. Hpw can I show the total in footer?
see my bounded gridview in below image