Nalin Kumar Balaji Shanmugam
asked on
To Create DataTable From DataRow Collection
Hi All,
Can anybody clear my doubt ,
" How Can i create datatable from a collection of datarows."
Advance Thanx
Balaji.
Can anybody clear my doubt ,
" How Can i create datatable from a collection of datarows."
Advance Thanx
Balaji.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hello Balaji,
In following example, I am creating DataTable from DataRow.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------
DataTable dt = new DataTable();
DataView dv;
DataRow dr;
dt.Columns.Add( new DataColumn("Column0",Type. GetType("S ystem.Stri ng") ) );
dt.Columns.Add( new DataColumn("Column1",Type. GetType("S ystem.Stri ng") ) );
dr = dt.NewRow(); //Create 1st Row
dr[0] = "row1:Column0";
dr[1] = "row1:Column1";
dt.Rows.Add(dr); // Add 1st row to table
dr = dt.NewRow(); //Create 2nd Row
dr[0] = "row2:Column0";
dr[1] = "row2:Column1";
dt.Rows.Add(dr); // Add 2nd row to table
dv = new DataView( dt );
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------
-tushar
In following example, I am creating DataTable from DataRow.
--------------------------
DataTable dt = new DataTable();
DataView dv;
DataRow dr;
dt.Columns.Add( new DataColumn("Column0",Type.
dt.Columns.Add( new DataColumn("Column1",Type.
dr = dt.NewRow(); //Create 1st Row
dr[0] = "row1:Column0";
dr[1] = "row1:Column1";
dt.Rows.Add(dr); // Add 1st row to table
dr = dt.NewRow(); //Create 2nd Row
dr[0] = "row2:Column0";
dr[1] = "row2:Column1";
dt.Rows.Add(dr); // Add 2nd row to table
dv = new DataView( dt );
--------------------------
-tushar
If the rows already belong to a datatable, if you're getting them from a DataTable.Select for example, you need to use
myDataTable.ImportRow(myDa taRow)
myDataTable.ImportRow(myDa
Mine and AerosSaga's code does exactly what user is asking for. But the points should go to AerosSaga as he showed 2 correct alternative method before me.
-tushar
-tushar
thank you tushar...I happily agree....Aeros
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dim dt As New DataTable
dt.Columns.Add(New DataColumn("mHostCode", GetType(String)))
dt.Columns.Add(New DataColumn("mTotalFreq", GetType(Integer)))
...do your sql connection and command decleration...
dr = SqlCommand1.ExecuteReader(
Dim datar As DataRow
While dr.Read
datar = dt.NewRow
datar(0) = dr(0)
datar(1) = dr(1)
dt.Rows.Add(datar)
End While
dr.Close