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();