How to get columns from datarow?

Question

I have row collection. (DataRow[] rows) And i want to import all rows to another DataTable (DataTable dt)

BUT HOW !?

        DataTable dt;
        if (drs.Length>0)
        {
            dt = new DataTable();

            foreach (DataRow row in drs)
            {
                dt.Columns.Add(row???????)
            }

            // if it possible, something like that => dt.Columns.AddRange(????????)

            for(int i = 0; i < drs.Length; i++)
            {
                dt.ImportRow(drs[i]);
            }
         }

Do you have any idea ?

Answer 1

Assuming the rows all have the same structure, the easiest option is to clone the old table, omitting the data:

DataTable dt = drs[0].Table.Clone();

Alternatively, something like:

foreach(DataColumn col in drs[0].Table.Columns)
{
    dt.Columns.Add(col.ColumnName, col.DataType, col.Expression);
}

Answer 2

How about

DataTable dt = new DataTable;
foreach(DataRow dr in drs)
{
    dt.ImportRow(dr);
}

Note this only works if drs is a DataRowCollection. Detached rows (not in a DataRowCollection are ignored).

Don't forget to call AcceptChanges.

Answer 3

If your DataRows is from a Data Table with Columns defined in it,

DataRow[] rows;

DataTable table = new DataTable();
var columns = rows[0].Table.Columns;

table.Columns.AddRange(columns.Cast<DataColumn>().ToArray());

foreach (var row in rows)
{
    table.Rows.Add(row.ItemArray);  
}