Creating Data Table
DataTable dt = new DataTable();
//Define Columns
DataColumn Column1 = new DataColumn("Column 1", typeof(string));
DataColumn Column2 = new DataColumn("Column 2", typeof(string));
DataColumn Column3 = new DataColumn("Column 3", typeof(string));
DataColumn Column4 = new DataColumn("Column 4", typeof(string));
//Add columns to data table
dt.Columns.Add(Column1);
dt.Columns.Add(Column2);
dt.Columns.Add(Column3);
dt.Columns.Add(Column4);
Retrieving Data
foreach (DataRow dr in dt.Rows)
{
string col1=dr[0].tostring();
string col2=dr["Column2"].tostring();
}
Get/Set Cell Value
int row=2;
dt.Rows[row]["Column1"] = "SomeValue";
string col1 = dt.Rows[row]["Column1"].tostring();
Advertisements
