Populating DataView from DataReader

This article will illustrate how to populate DataView from DataReader in C#. In many scenarios we may have the data in DataReader which is required to be bind to GridView or some other control. In this scenario we can populate a DataView from DataReader and then provide the populated DataView to our Control.

Following Method will populate DataView from a DataReader

private DataView PopulateDataView(IDataReader dataReader, string tableName)

    {

        DataTable dataReaderTable = new DataTable(tableName);

        try

        {

            for (int count = 0; count < dataReader.FieldCount; count++)

            {

                DataColumn tempCol = new DataColumn(dataReader.GetName(count), dataReader.GetFieldType(count));

                dataReaderTable.Columns.Add(tempCol);

            }

            while (dataReader.Read())

            {

                DataRow dr = dataReaderTable.NewRow();

                for (int i = 0; i < dataReader.FieldCount; i++)

                {

                    dr[i] = dataReader.GetValue(dataReader.GetOrdinal(dataReader.GetName(i)));

                }

                dataReaderTable.Rows.Add(dr);

            }

            return dataReaderTable.DefaultView;

        }

        catch

        {

            return null;

        }

    }