{"id":600,"date":"2014-08-08T13:45:32","date_gmt":"2014-08-08T13:45:32","guid":{"rendered":"http:\/\/a1webdesignteam.com\/blog\/?p=600"},"modified":"2014-08-08T13:45:32","modified_gmt":"2014-08-08T13:45:32","slug":"show-summery-in-the-gridviews-footer-in-asp-net-c","status":"publish","type":"post","link":"https:\/\/a1webdesignteam.com\/blog\/show-summery-in-the-gridviews-footer-in-asp-net-c\/","title":{"rendered":"Show Summery in the GridView\u2019s Footer in ASP.Net ( C# )"},"content":{"rendered":"

Information is displayed at the bottom of the GridView. Gridview has property to show footer at the bottom. And you can show some information or summary in it. If you are going to generate some financial or any analytical \u00a0report that contains numeric values and you may want to show the sum at the bottom of the GridView, You\u00a0obviously\u00a0will enable Footer in the GridView, but how to calculate sum and show in the footer? \u00a0Its very easy.<\/p>\n

Lets Start!,
\nFor the Purpose of tutorial I\u2019ve created a Database and a table in it. I have named the table as tbl_shops_detail (shopid, shopname, purchase, sale, profit)\u00a0<\/strong>and bind the table with GridView<\/strong>.
\nFirst of All go to the properties of GridView and Set ShowFooter property to true.<\/p>\n

\n
\"showfooter<\/a><\/div>\n

Here is The Designer Code
\n
\n<asp:gridview ID=\"GridView1\" runat=\"server\" AutoGenerateColumns=\"False\" BorderStyle=\"Dotted\"
\nBorderWidth=\"1px\" CellPadding=\"4\" ForeColor=\"#333333\" ShowFooter=\"True\" onrowdatabound=\"GridView1_RowDataBound\">
\n<AlternatingRowStyle BackColor=\"White\" \/>
\n<EditRowStyle BackColor=\"#2461BF\" \/>
\n<FooterStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" \/>
\n<HeaderStyle BackColor=\"#507CD1\" Font-Bold=\"True\" ForeColor=\"White\" \/>
\n<PagerStyle BackColor=\"#2461BF\" ForeColor=\"White\" HorizontalAlign=\"Center\" \/>
\n<RowStyle BackColor=\"#EFF3FB\" \/>
\n<SelectedRowStyle BackColor=\"#D1DDF1\" Font-Bold=\"True\" ForeColor=\"#333333\" \/>
\n<sortedascendingcellstyle backcolor=\"#F5F7FB\" \/>
\n<sortedascendingheaderstyle backcolor=\"#6D95E1\" \/>
\n<sorteddescendingcellstyle backcolor=\"#E9EBEF\" \/>
\n<sorteddescendingheaderstyle backcolor=\"#4870BE\" \/>
\n<Columns>
\n<asp:TemplateField HeaderText=\"Shop ID\">
\n<ItemTemplate>
\n<asp:Label ID=\"lblsid\" runat=\"server\" Text='<%# Eval(\"ShopId\")%>' \/>
\n<\/ItemTemplate>
\n<FooterTemplate>
\n<asp:Label ID=\"lblTotal\" runat=\"server\" \/>
\n<\/FooterTemplate>
\n<\/asp:TemplateField>
\n<asp:TemplateField HeaderText=\"Shop Name\">
\n<ItemTemplate>
\n<asp:Label ID=\"lblShopName\" runat=\"server\" Text='<%# Eval(\"ShopName\") %>' \/>
\n<\/ItemTemplate>
\n<FooterTemplate>
\n<asp:Label ID=\"lblTSN\" runat=\"server\" \/>
\n<\/FooterTemplate>
\n<\/asp:TemplateField>
\n<asp:TemplateField HeaderText=\"Purchase\">
\n<ItemTemplate>
\n<asp:Label ID=\"lblpurchase\" runat=\"server\" Text='<%# Eval(\"purchase\") %>' \/>
\n<\/ItemTemplate>
\n<FooterTemplate>
\n<asp:Label ID=\"lbltotalpurchase\" runat=\"server\" \/>
\n<\/FooterTemplate>
\n<\/asp:TemplateField>
\n<asp:TemplateField HeaderText=\"Sale\">
\n<ItemTemplate>
\n<asp:Label ID=\"lblsale\" runat=\"server\" Text='<%# Eval(\"sale\") %>' \/>
\n<\/ItemTemplate>
\n<FooterTemplate>
\n<asp:Label ID=\"lbltotalsale\" runat=\"server\" \/>
\n<\/FooterTemplate>
\n<\/asp:TemplateField>
\n<asp:TemplateField HeaderText=\"Profit\">
\n<ItemTemplate>
\n<asp:Label ID=\"lblprofit\" runat=\"server\" Text='<%# Eval(\"profit\") %>' \/>
\n<\/ItemTemplate>
\n<FooterTemplate>
\n<asp:Label ID=\"lbltotalprofit\" runat=\"server\" \/>
\n<\/FooterTemplate>
\n<\/asp:TemplateField>
\n<\/Columns>
\n<\/asp:gridview>
\n<\/code><\/p>\n<\/div>\n

In the above example I\u2019m using TemplateField inside the Gridview. And within the TemplateField there are two templates one is ItemTemplate and other is FooterTemplate.
\nThe Label inside the ItemTemplate are bounded. And Labels Inside FooterTemplate are left blank.The Page_Load function of page binds data to \u00a0the Grid
\nprotected void Page_Load(object sender, EventArgs e)
\n{
\nif(!isPostBack()){
\nDataBind();
\n}
\n}
\nprivate void DataBind()
\n{
\nSqlConnection conn = new SqlConnection(@\"Server=.\\SQLEXPRESS;Database=sharpcoders;uid=sa;pwd=sa;\");
\nSqlDataAdapter da = new SqlDataAdapter();
\nDataTable dt = new DataTable();
\nda.SelectCommand = new SqlCommand(\"select * from tbl_Shops_detail\", conn);
\nda.Fill(dt);
\nGridView1.DataSource = dt;
\nGridView1.DataBind();
\n}<\/span><\/code>
\nTo calculate Total we need variable that will store the sum. The variables should be declared outside the RowDataBound event.
\ndecimal<\/span> totalsale = 0, totalpurchase = 0, totalprofit = 0;<\/span><\/code>
\nRowDataBound event raised for every Row including Header and Footer. So I applied Condition for Calculation only on DataRow. And Display the Sum only in the FooterRow.
\nprotected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
\n{
\nif (e.Row.RowType == DataControlRowType.DataRow)
\n{
\ntry
\n{
\nLabel lblpurchase = (Label)e.Row.FindControl(\"lblpurchase\");
\nLabel lblsale = (Label)e.Row.FindControl(\"lblsale\");
\nLabel lblprofit = (Label)e.Row.FindControl(\"lblprofit\");
\nif (lblpurchase.Text != string.Empty)
\n{
\ntotalpurchase += decimal.Parse(lblpurchase.Text);
\n}
\nif (lblsale.Text != string.Empty)
\n{
\ntotalsale += decimal.Parse(lblsale.Text.Replace(\",\", \"\"));
\n}
\nif (lblprofit.Text != string.Empty)
\n{
\ntotalprofit += decimal.Parse(lblprofit.Text.Replace(\",\", \"\"));
\n}
\n}
\ncatch
\n{ }
\n}
\nif (e.Row.RowType == DataControlRowType.Footer)
\n{
\ntry
\n{
\nLabel lbltotalpurchase = (Label)e.Row.FindControl(\"lbltotalpurchase\");
\nLabel lbltotalsale = (Label)e.Row.FindControl(\"lbltotalsale\");
\nLabel lbltotalprofit = (Label)e.Row.FindControl(\"lbltotalprofit\");
\nlbltotalpurchase.Text = Convert.ToString(totalpurchase);
\nlbltotalsale.Text = Convert.ToString(totalsale);
\nlbltotalprofit.Text = Convert.ToString(totalprofit);<\/span>
\n}
\ncatch
\n{ }
\n}
\n}
\n<\/code>
\nThats It\u2026:-)<\/p>\n","protected":false},"excerpt":{"rendered":"

Information is displayed at the bottom of the GridView. Gridview has property to show footer at the bottom. And you can show some information or summary in it. If you are going to generate some financial or any analytical \u00a0report that contains numeric values and you may want to show the sum at the bottom […]<\/p>\n","protected":false},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[32,9],"tags":[],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/600"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=600"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media\/601"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}