How to pass DataTable.Select() result to a new DataTable?

Question

I have a DataTable named dt2 with data. I am calling its Select method to get some specific rows.

DataRow[] foundRows;  expression = "parent_id=1";  foundRows = dt2.Select(expression); 

How can I pass the Select-method result to a new DataTable – say FilteredData?

Answer 1

You can use CopyToDataTable, available on IEnumerable<DataRow> types.

var filteredData = dt2.Select(expression).CopyToDataTable(); 

Answer 2

Just for clarity, the Select method returns an array of type DataRow. That's why we need to use CopyToDataTable(). Alex's answer is good. However, if the Select didn't return any rows, CopyToDataTable() will throw an InvalidOperationException.

So test that there is at least one DataRow before using the CopyToDataTable().

var filteredDataRows = dt2.Select(expression);  var filteredDataTable = new DataTable();  if(filteredDataRows.Length != 0)     filteredDataTable = filteredDataRows.CopyToDataTable();