Monday, July 1, 2013

How To Create a Data Table Programatically Using C#.Net,ASP.Net?

In this article i would like to explore the concept of creating a Data Table Using C#,Asp.Net.

                Generally we can get the data from data base we can represent in any of the databound controls like gridview,form view,list view etc..........

                  In this article i would like to pass the data to any of the controls an that data should be presented to the gridview.For this i would like to consider datatable.

                   Data Table is a collection of rows and columns

For working of Data Table we need to give an instance................
                      DataTable dt=new DataTable();
Now You need to declare columns also
                      DataColumn dc=new DataColumn("ColumName",DataType");
                      DataColumn col1=new DataColumn("ID");

We can add to DataTable
Creating a Row in the DataTable
                             DataRow dr=dt.NewRow();
Fill the Data in the DataRow
Add the Row into the DataTable


Design Page(Source Code):

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

    Data Table Page

Example On DataTable Using C#,Asp.Net



Enter Your Name


Enter Qualification


Enter Your Designation




            BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">

Design View:


using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page 
    protected void Page_Load(object sender, EventArgs e)

    protected void b1_Click(object sender, EventArgs e)
        DataTable dt = new DataTable();
        DataColumn dc = new DataColumn("Name", typeof(string));
        dt.Columns.Add("Qualification", typeof(string));
        dt.Columns.Add("Designation", typeof(string));
        //dt.Rows.Add(txtname.Text, txtQuali.Text, txtDes.Text);
        DataRow dr = dt.NewRow();
        dr[0] = txtname.Text;
        dr[1] = txtQuali.Text;
        dr[2] = txtDes.Text;
        g1.DataSource = dt;



No comments: