Simple way to convert datarow array to datatable

c# arrays datatable datarow
Developer404 picture Developer404 · Jan 23, 2010 · Viewed 335.5k times · Source

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

Answer

joe picture joe · Dec 10, 2010

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 > 0)
    DataTable dt1 = dr.CopyToDataTable();

Reference available at MSDN: DataTableExtensions.CopyToDataTable Method (IEnumerable)

Related questions

Convert a List<string> to DataRow in c#

I have a list of strings and am in need of converting it to a Datarow. I tried toReturn.Add("UserID"); toReturn.Add("UserName"); DataRow row = null; row.ItemArray=toreturn.ToArray(); This is throwing me an exception Object reference not …

Read More
Adding values to a C# array

Probably a really simple one this - I'm starting out with C# and need to add values to an array, for example: int[] terms; for(int runs = 0; runs < 400; runs++) { terms[] = runs; } For those who have used PHP, here's what …

Read More
How to convert byte array to string

I created a byte array with two strings. How do I convert a byte array to string? var binWriter = new BinaryWriter(new MemoryStream()); binWriter.Write("value1"); binWriter.Write("value2"); binWriter.Seek(0, SeekOrigin.Begin); byte[] result = reader.ReadBytes((int)binWriter.BaseStream.…

Read More