Simple way to convert datarow array to datatable

Question

I want to convert a DataRow array into DataTable     What is the simplest way to do this

User · Answer

For  Net Framework 3 5   DataTable dt   new DataTable    DataRow   dr   dt Select  Your string    DataTable dt1   dr CopyToDataTable      But if there is no rows in the array  it can cause the errors such as The source contains no DataRows  Therefore  if you decide to use this method CopyToDataTable    you should check the array to know it has datarows or not    if  dr Length  gt  0      DataTable dt1   dr CopyToDataTable      Reference available at MSDN   DataTableExtensions CopyToDataTable Method  IEnumerable

User · Answer

You could use System Linq like this   if  dataRows    null  amp  amp  dataRows Length  gt  0       dataTable   dataRows AsEnumerable   CopyToDataTable

User · Answer

Another way is to use a DataView     Create a DataTable DataTable table   new DataTable           Filter and Sort expressions string expression     Birth Year   gt   1983    string sortOrder     Birth Year  ASC       Create a DataView using the table as its source and the filter and sort expressions DataView dv   new DataView table  expression  sortOrder  DataViewRowState CurrentRows       Convert the DataView to a DataTable DataTable new table   dv ToTable  NewTableName

User · Answer

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

User · Answer

Incase anyone needs it in VB NET   Dim dataRow as DataRow Dim yourNewDataTable as new datatable For Each dataRow In yourArray      yourNewDataTable ImportRow dataRow  Next

User · Answer

DataTable dt   new DataTable    foreach  DataRow dr in drResults         dt ImportRow dr

User · Answer

Net 3 5  added DataTableExtensions  use DataTableExtensions CopyToDataTable Method   For datarow array just use  CopyToDataTable   and it will return datatable   For single datarow use   new DataRow     myDataRow   CopyToDataTable

User · Answer

DataTable Assetdaterow                 from s in dtResourceTable AsEnumerable           where s Field lt DateTime gt   Date      Convert ToDateTime AssetDate          select s       CopyToDataTable

User · Answer

DataTable dt   new DataTable      DataRow   dr    DataTable dsData Tables 0  Select  Some Criteria     dt Rows Add dr

User · Answer

DataTable dataTable   new DataTable    dataTable   OldDataTable Tables 0  Clone    foreach DataRow dr in RowData Tables 0  Rows     DataRow AddNewRow   dataTable AddNewRow     AddNewRow ItemArray   dr ItemArray   dataTable Rows Add AddNewRow

User · Answer

Simple way is      dtData is DataTable that contain data DataTable dt   dtData Select  Condition 1   CopyToDataTable        or existing typed DataTable dt dt Merge dtData Select  Condition 1   CopyToDataTable

User · Answer

You need to clone the structure of Data table first then import rows using for loop  DataTable dataTable  dtExisting Clone    foreach  DataRow row in rowArray       dataTable ImportRow row

User · Answer

Here is the solution  It should work fine   DataTable dt   new DataTable    dt   dsData Tables 0  Clone    DataRows   drResults   dsData Tables 0  Select  ColName    criteria     foreach DataRow dr in drResults        object   row   dr ItemArray      dt Rows Add row

User · Answer

DataTable dt   myDataRowCollection CopyToDataTable lt DataRow gt

[c#] Simple way to convert datarow array to datatable

Examples related to c#

Examples related to arrays

Examples related to datatable

Examples related to datarow