We will learn here how to bind controls with data without a database and how to handle total sum of a column on controls.

Also read:

Initial Chamber

Step 1

Open your Visual Studio and create an empty website then provide a suitable name such as GridViewColumnAdd.

Step 2

In Solution Explorer you will get your empty website, then add some web forms.

GridViewColumnAdd (your empty website). Right-click and select Add New Item Web Form. Name it GridViewColumnAdd.aspx.

Design Chamber

Step 3

Open the GridViewColumnAdd.aspx file and write some code for the design of the application.

Choose the control from the toolbox and provide your design page like:
  1. <form id="form1" runat="server">
  2. <div>
  3. <asp:GridView ID="GridView1" runat="server" AlternatingRowStyle-BackColor="Wheat" ShowFooter="true">
  4. </asp:GridView>
  5. </div>
  6. </form>
Here I've enabled the "ShowFooter" property of GridView to show the total sum of a column in the footer.

Here I've designed the GridView Control and used some property as in the following.

Design Page
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewColumnAdd.aspx.cs" Inherits="GridViewColumnAdd" %>
  3. <!DOCTYPE html>
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7. <title></title>
  8. </head>
  9. <body>
  10. <form id="form1" runat="server">
  11. <div>
  12. <asp:GridView ID="GridView1" runat="server" AlternatingRowStyle-BackColor="Wheat" ShowFooter="true">
  13. </asp:GridView>
  14. </div>
  15. </form>
  16. </body>
  17. </html>
Your design looks as in the following:

design
Figure 1

Code Chamber

Step 4

In the code chamber we will write some code so that our application works.

Add the following namespaces to the namespace section of your code behind page:
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Data.SqlClient;
Now your page looks as in the following.

Code behind Page
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Data.SqlClient;
  10. public partial class GridViewColumnAdd : System.Web.UI.Page
  11. {
  12. protected void Page_Load(object sender, EventArgs e)
  13. {
  14. if (!IsPostBack) {
  15. BindGridviewFooter();
  16. }
  17. }
  18. protected void BindGridviewFooter()
  19. {
  21. //Creating a dataset
  22. DataSet ds = new DataSet();
  23. DataTable dt;
  24. DataRow dr;
  25. DataColumn pName;
  26. DataColumn pQty;
  27. DataColumn pPrice;
  28. DataColumn pCategory;
  29. //create an object of datatable
  30. dt = new DataTable();
  31. //creating column of datatable with datatype
  32. pName = new DataColumn("Product_Name", Type.GetType("System.String"));
  33. pQty = new DataColumn("Quantity", Type.GetType("System.Int32"));
  34. pPrice = new DataColumn("Price", Type.GetType("System.Int32"));
  35. pCategory = new DataColumn("Category", Type.GetType("System.String"));
  36. //bind data table columns in datatable
  37. dt.Columns.Add(pName);
  38. dt.Columns.Add(pQty);
  39. dt.Columns.Add(pPrice);
  40. dt.Columns.Add(pCategory);
  41. //creating data row and assiging the value to columns of datatable
  42. dr = dt.NewRow();
  43. dr["Product_Name"] = "Product 1";
  44. dr["Quantity"] = 2;
  45. dr["Price"] = 200;
  46. dr["Category"] = "Cat1";
  47. dt.Rows.Add(dr);
  49. dr = dt.NewRow();
  50. dr["Product_Name"] = "Product 2";
  51. dr["Quantity"] = 5;
  52. dr["Price"] = 480;
  53. dr["Category"] = "Cat2";
  54. dt.Rows.Add(dr);
  56. dr = dt.NewRow();
  57. dr["Product_Name"] = "Product 3";
  58. dr["Quantity"] = 8;
  59. dr["Price"] = 100;
  60. dr["Category"] = "Cat1";
  61. dt.Rows.Add(dr);
  63. dr = dt.NewRow();
  64. dr["Product_Name"] = "Product 4";
  65. dr["Quantity"] = 2;
  66. dr["Price"] = 500;
  67. dr["Category"] = "Cat2";
  68. dt.Rows.Add(dr);
  70. dr = dt.NewRow();
  71. dr["Product_Name"] = "Product 5";
  72. dr["Quantity"] = 8;
  73. dr["Price"] = 100;
  74. dr["Category"] = "Cat1";
  75. dt.Rows.Add(dr);
  77. dr = dt.NewRow();
  78. dr["Product_Name"] = "Product 6";
  79. dr["Quantity"] = 3;
  80. dr["Price"] = 90;
  81. dr["Category"] = "Cat1";
  82. dt.Rows.Add(dr);
  84. dr = dt.NewRow();
  85. dr["Product_Name"] = "Product 7";
  86. dr["Quantity"] = 18;
  87. dr["Price"] = 1100;
  88. dr["Category"] = "Cat2";
  89. dt.Rows.Add(dr);
  91. ds.Tables.Add(dt);
  92. GridView1.DataSource = ds.Tables[0];
  93. GridView1.DataBind();
  94. //here add code for column total sum and show in footer
  95. int total = 0; ;
  96. GridView1.FooterRow.Cells[0].Text = "Total";
  97. GridView1.FooterRow.Cells[1].Font.Bold = true;
  98. GridView1.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Left;
  99. for (int k = 1; k < dt.Columns.Count-1; k++)
  100. {
  101. total = dt.AsEnumerable().Sum(row => row.Field<Int32>(dt.Columns[k].ToString()));
  102. GridView1.FooterRow.Cells[k].Text = total.ToString();
  103. GridView1.FooterRow.Cells[k].Font.Bold = true;
  104. GridView1.FooterRow.BackColor = System.Drawing.Color.Beige;
  105. }
  106. }
  108. }
Output

output
Figure 2

I hope you liked this. Have a good day. Thank you for reading.