Tuesday, July 5, 2011

How to Create Data table using c# .Net

Following is the code snippet for creating Datatable using c#



//Creating datatable object.
DataTable dtEmp = new DataTable();


//Creating datacolumns.
DataColumn colID = new DataColumn("ID");
DataColumn colName = new DataColumn("Name");
DataColumn colGender = new DataColumn("Gender");
DataColumn colManager = new DataColumn("Manager");


//Assign datatype for the columns.
colID.DataType = System.Type.GetType("System.Int");
colName.DataType = System.Type.GetType("System.String");
colGender.DataType = System.Type.GetType("System.Boolean");
colManager.DataType = System.Type.GetType("System.String");


//Add the columns to the table.
dtEmp.Columns.Add(colID);
dtEmp.Columns.Add(colName);
dtEmp.Columns.Add(colGender);
dtEmp.Columns.Add(colManager);


//Create a newrow in datatable.
DataRow row = dtEmp.NewRow();


//Assign values to the columns.
row[colID] = 1100;
row[colName] = "John";
row[colGender] = true;
row[colManager] = "Michel";


//Add row to the dtEmp datatable.
dtEmp.Rows.Add(row);



Thats it!... now you have datatable, play around with it.
Happy coding.