In this article, I am going to show how we can add a column value in a DataGrid. To add a column value in this program I am using a function. In the function, I am passing the value of that particular column. Let us see how to do this through the below code.
The default.aspx code is:
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">
  5. <head runat="server">
  6. <title>Count a column Value</title>
  7. </head>
  9. <body>
  10. <form id="form1" runat="server">
  11. <div>
  12. <asp:DataGrid id="MyGrid" runat="server" AutoGenerateColumns="False" CellPadding="2" CellSpacing="0" BorderStyle="Solid" BorderWidth="4" Gridlines="Both" BorderColor="ActiveCaption" ItemStyle-Font-Name="Verdana" ItemStyle-Font-Size="10pt" HeaderStyle-Font-Name="Verdana" HeaderStyle-Font-Size="14pt" HeaderStyle-Font-Bold="True" HeaderStyle-BackColor="#ccffcc" FooterStyle-Font-Name="Verdana" FooterStyle-Font-Size="10pt" FooterStyle-Font-Bold="True" FooterStyle-ForeColor="White" FooterStyle-BackColor="Blue" OnItemDataBound="MyDataGrid_ItemDataBound" ShowFooter="True">
  13. <Columns>
  14. <asp:BoundColumn HeaderText="Product ID" DataField="ProductID" />
  15. <asp:BoundColumn HeaderText="Product Name" DataField="ProductName" />
  16. <asp:BoundColumn HeaderText="Unit In Price" DataField="UnitPrice" ItemStyle-HorizontalAlign="center"> </asp:BoundColumn>
  17. <asp:BoundColumn HeaderText="Units In Stock" DataField="UnitsInStock" ItemStyle-HorizontalAlign="center" HeaderStyle-HorizontalAlign="Center">
  18. </asp:BoundColumn>
  19. </Columns>
  20. </asp:DataGrid>
  21. </div>
  22. </form>
  23. </body>
  25. </html>
The Default.aspx.cs
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Web;
  5. using System.Web.Security;
  6. using System.Web.UI;
  7. using System.Web.UI.WebControls;
  8. using System.Web.UI.WebControls.WebParts;
  9. using System.Web.UI.HtmlControls;
  10. using System.Data.SqlClient;
  12. public partial class _Default: System.Web.UI.Page {
  13. private double TotalUnit = 0;
  15. protected void Page_Load(object sender, EventArgs e) {
  16. SqlConnection con = new SqlConnection("server=Localhost; database=Northwind; uid=sa;pwd=;");
  17. SqlCommand cmd = new SqlCommand("SELECT ProductID, ProductName,UnitPrice, UnitsInStock FROM Products WHERE UnitPrice > 30", con);
  18. try {
  19. con.Open();
  20. MyGrid.DataSource = cmd.ExecuteReader();
  21. MyGrid.DataBind();
  22. con.Close();
  23. } catch (Exception ex) {
  24. //An error occured
  25. HttpContext.Current.Response.Write(ex.ToString());
  26. }
  27. }
  29. //This Method will calculate the column value
  30. private void MyTotalUnit(string Unit) {
  31. try {
  32. TotalUnit += Double.Parse(Unit);
  33. } catch {
  34. //A value was null
  35. }
  36. }
  38. //Here we are bionding the data to the datagrid
  39. public void MyDataGrid_ItemDataBound(object sender, DataGridItemEventArgs e) {
  40. if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) {
  42. //Here we are passing the value of a column in the MyTotalUnit function to total
  43. MyTotalUnit(e.Item.Cells[3].Text);
  44. e.Item.Cells[3].Text = string.Format("{0:0}", Convert.ToDouble(e.Item.Cells[3].Text));
  45. } else if (e.Item.ItemType == ListItemType.Footer) {
  46. e.Item.Cells[0].Text = "Total";
  47. e.Item.Cells[3].Text = string.Format("{0:0}", TotalUnit);
  48. }
  49. }
  50. }
When the user runs the application then the window will look like this:
Figure 1: Showing the total of Units in stock.