datareader转换成datatable

 public static DataTable ConvertDataReaderToDataTable(SqlDataReader reader)     {              try         {             DataTable objDataTable = new DataTable();             int intFieldCount = reader.FieldCount;             for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)             {                 objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));             }

            objDataTable.BeginLoadData();

            object[] objValues = new object[intFieldCount];             while (reader.Read())             {                 reader.GetValues(objValues);                 objDataTable.LoadDataRow(objValues, true);             }             reader.Close();             objDataTable.EndLoadData();

            return objDataTable;

        }         catch (Exception ex)         {                    throw new Exception("转换出错!", ex);         }

    }

转载于:https://www.cnblogs.com/innovate-asp/archive/2007/11/09/954660.html