Hi..
I want to convert an datarow array into datatable.. Wat is the simple way to do this?
Thanks in advance!!
+1
A:
DataTable dt = new DataTable();
DataRow[] dr = (DataTable)dsData.Tables[0].Select("Some Criteria");
dt.Rows.Add(dr);
Mitch Wheat
2010-01-23 08:02:04
I already tried like that.. Error occurs something like "Input array is longer than the number of columns in this table."
Nila
2010-01-23 08:55:35
AS Jay pointed out, Make sure your dataTable has the same schema as the DataRows in your DataRow array
Mitch Wheat
2010-01-23 09:06:31
Yes.. I tried. I used Datatable1=datatable2.Clone(); Now it is working... Thank you :-)
Nila
2010-01-23 09:17:47
I tried this with a row array and it didn't work. For each row in the row array, I created a new row, copied the ItemArray property from the original row and then the add worked.
Steve
2010-02-02 14:08:10
+2
A:
Why not iterate through your DataRow array and add (using DataRow.ImportRow, if necessary, to get a copy of the DataRow), something like:
foreach (DataRow row in rowArray) {
dataTable.ImportRow(row);
}
Make sure your dataTable has the same schema as the DataRows in your DataRow array.
Jay Riggs
2010-01-23 08:40:59