DataReader转化为DataSet

在VS2003中，DataGrid的DataSource是不支持DataReader的，到了VS2005的时候，GridView已经可以支持DataReader了，但是，有时候我们还是需要DataSet进行操作，以下Source是将DataReader转化为DataSet。          ///     <summary>        ///     Converts a SqlDataReader to a DataSet        ///     <param name='reader'>        /// SqlDataReader to convert.</param>        ///     <returns>        /// DataSet filled with the contents of the reader.</returns>        ///     </summary>public static DataSet convertDataReaderToDataSet(SqlDataReader reader)        {            DataSet dataSet = new DataSet();            do            {                // Create new data table                DataTable schemaTable = reader.GetSchemaTable();                DataTable dataTable = new DataTable();                if ( schemaTable != null )                {                    // A query returning records was executed                    for ( int i = 0; i < schemaTable.Rows.Count; i++ )                    {                        DataRow dataRow = schemaTable.Rows[ i ];                        // Create a column name that is unique in the data table  string columnName = ( string )dataRow[ "ColumnName" ];                        // Add the column definition to the data table                        DataColumn column = new DataColumn( columnName, ( Type )dataRow[ "DataType" ] );                        dataTable.Columns.Add( column );                    }                    dataSet.Tables.Add( dataTable );                    // Fill the data table we just created                    while ( reader.Read() )                    {                        DataRow dataRow = dataTable.NewRow();                        for ( int i = 0; i < reader.FieldCount; i++ )                            dataRow[ i ] = reader.GetValue( i );                        dataTable.Rows.Add( dataRow );                    }                }                else{                    // No records were returned                    DataColumn column = new DataColumn("RowsAffected");                    dataTable.Columns.Add(column);                    dataSet.Tables.Add( dataTable );                    DataRow dataRow = dataTable.NewRow();                    dataRow[0] = reader.RecordsAffected;                    dataTable.Rows.Add( dataRow );                }            }            while ( reader.NextResult() );            return dataSet;        } 文章引用自： http://blog.sina.com.cn/s/blog_4abba72d01000b1x.html