ADO.NET: convert a DataTable to an array of DataRows

Question

I'm using ADO.NET and C#, and I want to convert a DataTable object into an array of DataRows. What is an elegant way of doing this?

Answer 1

My first question would be why? The request makes no sense.

The answer is:

DataRow[] rows = myDataTable.Select();

Answer 2

Actually the DataTable has a property called Rows, witch provides the methods to do this.

You can accomplish this doing:

List<System.Data.DataRow> r = d.Rows.AsQueryable().OfType<System.Data.DataRow>().ToList();

Answer 3

DataTable.Select() gives you an array of DataRows. You can use this as an array

Dim dt As New DataTable
Dim dr() As DataRow = dt.Select() 

In case you want an ArrayList, you can

public ArrayList ConvertDT(ref DataTable dt)
{
        ArrayList converted = new ArrayList(dt.Rows.Count);
        foreach (DataRow row in dt.Rows)
        {
                converted.Add(row);
        }
        return converted;
}

I have not used the dt.rows.CopyTo function. maybe that works also.