Convert a DataReader to a DataTable

When working with Datareaders one of the problems i sometimes come across is binding these to 3rd party controls. A lot of controls will not bind to a DataReader but nearly all of the alwaays bind to a DataTable. All of the functionlity already exists in the Framework you just need to know where to look.

So here is the simple way to convert a DataReader to a DataTable.

Create a class Inheriting from DataAdapter

   class DataReaderAdapter : System.Data.Common.DataAdapter
    {
        public int FillFromReader(DataTable dataTable, IDataReader dataReader)
        {
            return this.Fill(dataTable, dataReader);
        }
    }

Then to use it :

DataReaderAdapter dar = new DataReaderAdapter();
dar.FillFromReader(dataTable, dataReader);

Attached is a sample project showing the use of this.