ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. The DataTable object represents an in-memory database table
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    void Page_Load()
    {
        DataTable newDataTable = new DataTable();
        newDataTable.Columns.Add("Id", typeof(int));
        newDataTable.Columns.Add("ProductName", typeof(string));
        newDataTable.Columns.Add("ProductPrice", typeof(decimal));
        newDataTable.Columns["Id"].AutoIncrement = true;
        for (int i = 1; i < 11; i++)
        {
            DataRow newRow = newDataTable.NewRow();
            newRow["ProductName"] = "Product " + i.ToString();
            newRow["ProductPrice"] = 12.34m;
            newDataTable.Rows.Add(newRow);
        }
        grdProducts.DataSource = newDataTable;
        grdProducts.DataBind();
    }



    Show DataTable Programmatically


    
    

    

Products


            id="grdProducts"
        Runat="server" />