Monday, October 11, 2004

Sample code to create and load data to a dataset manually

********Sample code to create a Dataset, Datatable and adding data to the Dataset*********


DataSet dummyDataSet=new DataSet("dummyDataSet");
DataTable dummyTable=new DataTable("dummyTable");
ArrayList dmcol=new ArrayList();
dmcol.Add("myval1");
dmcol.Add("myval2");
dmcol.Add("myval3");
dmcol.Add("myval4");
int i;
dummyDataSet.Namespace= "Your NameSpace";
DataColumn c2 = new DataColumn("User");
DataColumn c1 = new DataColumn("Action");
DataColumn c3 = new DataColumn("Time");
dummyTable.Columns.Add(c1);
dummyTable.Columns.Add(c2);
dummyTable.Columns.Add(c3);
dummyDataSet.Tables.Add(dummyTable);

// Add rows.
DataRow newRow;
for(i=0; i "lessthan" dmcol.Count; i++)
{
newRow = dummyTable.NewRow();
newRow["User"]= dmcol[i].ToString();
newRow["Time"]= dmcol[i].ToString();
newRow["Action"]= dmcol[i].ToString();
dummyTable.Rows.Add(newRow);
}//ends for loop

dummyDataSet.AcceptChanges();


No comments: