SqlDataReader读取数据动态创建DataTable

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

public DataTable ConvertToDataTable(SqlDataReader dataReader)         {             DataTable dt = new DataTable();             DataTable schemaTable = dataReader.GetSchemaTable();             try             {                 //动态构建表，添加列                 foreach (DataRow dr in schemaTable.Rows)                 {                     DataColumn dc = new DataColumn();                    //设置列的数据类型                     dc.DataType = dr[0].GetType();                     //设置列的名称                     dc.ColumnName = dr[0].ToString();                     //将该列添加进构造的表中                     dt.Columns.Add(dc);                 }                 //读取数据添加进表中                 while (dataReader.Read())                 {                      DataRow row = dt.NewRow();                     //填充一行数据                     for (int i = 0; i <schemaTable.Rows.Count; i++)                     {                                            row[i] = dataReader[i].ToString();                       }                     dt.Rows.Add(row );                     row = null;                 }                 dataReader.Close();                 schemaTable = null;                 return dt;             }             catch(Exception ex)             {                                 //抛出异常                 throw new Exception(ex.Message );             }                      }