将DataReader转换为DataTable的一个函数

 1        public static DataTable ConvertDataReaderToDataTable(IDataReader reader)
 2        {
 3            DataTable objDataTable = new DataTable();
 4            int intFieldCount = reader.FieldCount;
 5            for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)
 6            {
 7                objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
 8            }

 9
10            objDataTable.BeginLoadData();
11
12            object[] objValues = new object[intFieldCount];
13            while (reader.Read())
14            {
15                reader.GetValues(objValues);
16                objDataTable.LoadDataRow(objValues, true);
17            }

18            reader.Close();
19            objDataTable.EndLoadData() ;
20
21            return objDataTable;
22        }

From:http://didasoft.cnblogs.com/archive/2006/01/04/310846.html