CSharp Add Datacolumn To Datatable – ADO.Net Database

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">    void Page_Load(object sender, EventArgs e)
    {
      if (!Page.IsPostBack)
        BindData();
    }
 
 
    IEnumerable ItemsInCart()
    {       DataTable dt = new DataTable();
       DataRow dr;
 
       dt.Columns.Add(new DataColumn("ProductID", typeof(int)));
       dt.Columns.Add(new DataColumn("Name", typeof(string)));
       dt.Columns.Add(new DataColumn("Price", typeof(float)));
 
       for (int i = 0; i < 10; i++)
       {
          dr = dt.NewRow();
 
          dr[0] = i+1;
          dr[1] = "Item " + i.ToString();
          dr[2] = (float) 1.2 * i;
 
          dt.Rows.Add(dr);
       }
 
       DataView dv = new DataView(dt);
       return dv;
    }
 
 
    string GetProductDescription(int ID)
    {
      return "This is the description for product " + ID.ToString() + "...";
    }
 
 
    void BindData()
    {
      dgCart.DataSource = ItemsInCart();
      dgCart.DataBind();
    }
 
 
    void dgCart_ItemCommand(object sender, DataGridCommandEventArgs e)
    {
      Response.Write("A button was clicked...");
    }</script>
<form runat="server">
  <asp:DataGrid runat="server" id="dgCart"
        AutoGenerateColumns="False"
        Font-Name="Verdana"
        Font-Size="8pt"
        OnItemCommand="dgCart_ItemCommand">
 
    <headerStyle HorizontalAlign="Center"
                 Font-Bold="True"
                 Font-Size="11pt"
                 BackColor="Navy"
                 ForeColor="White" />
 
    <columns>
      <asp:ButtonColumn Text="Remove"
                        ButtonType="PushButton"
                        HeaderText="Remove" />
      <asp:ButtonColumn Text="Details"
                        ButtonType="PushButton"
                        HeaderText="Details" />
 
      <asp:BoundColumn DataField="Name" HeaderText="Product Name" />
      <asp:BoundColumn DataField="Price"
                       HeaderText="Price"
                       ItemStyle-HorizontalAlign="right"
                       DataFormatString="{0:c}" />
    </columns>
  </asp:DataGrid>
</form>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.