SiteMap  | About    

How to Dyanamic Dataset in C#

The DataSet Object represents a complete set of data, including related tables, constraints, and relationships among the tables . The DataSet contains DataTableCollection and their DataRelationCollection . The DataTableCollection contains zero or more DataTable objects.

ADO.NET enables you to create DataTable objects and add them to an existing DataSet. A DataTable is defined in the System.Data namespace and represents a single table of memory-resident data. You can set constraint information for a DataTable by using the PrimaryKey and Unique properties. The following C# Source Code shows how to fill a DataTable without using a DataSource .

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsApplication1
    public partial class Form1 : Form
        public Form1()

        private void button1_Click(object sender, EventArgs e)
            DataSet ds = new DataSet();
            DataTable dt ;
            DataRow dr ;
            DataColumn idCoulumn ;
            DataColumn nameCoulumn ;
            int i = 0;

            dt = new DataTable();
            idCoulumn = new DataColumn("ID", Type.GetType("System.Int32"));
            nameCoulumn = new DataColumn("Name", Type.GetType("System.String"));


            dr = dt.NewRow();
            dr["ID"] = 1;
            dr["Name"] = "Name1";

            dr = dt.NewRow();
            dr["ID"] = 2;
            dr["Name"] = "Name2";


            for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1]);

} (C) 2016    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.