/// <summary>
/// 将DataReader转为DataTable
/// </summary>
/// <returns></returns>
public static DataTable ConvertDataReaderToDataTable(SqlDataReader sqldataReader)
{
DataTable table = new DataTable();
try
{
//动态添加数据表的结构
for (int i = 0; i < sqldataReader.FieldCount; i++)
{
DataColumn column = new DataColumn();
column.DataType = sqldataReader.GetFieldType(i);
column.ColumnName = sqldataReader.GetName(i);
table.Columns.Add(column);
}
//添加表的数据
while(sqldataReader.Read())
{
DataRow datrow = table.NewRow();
for (int i = 0; i < sqldataReader.FieldCount; i++)
{
datrow[i] = sqldataReader[i].ToString();
}
table.Rows.Add(datrow);
}
//关闭数据阅读器
sqldataReader.Close();
return table;
}
catch (Exception ex)
{
throw new Exception(ex.Message,ex);
}
}
/// 将DataReader转为DataTable
/// </summary>
/// <returns></returns>
public static DataTable ConvertDataReaderToDataTable(SqlDataReader sqldataReader)
{
DataTable table = new DataTable();
try
{
//动态添加数据表的结构
for (int i = 0; i < sqldataReader.FieldCount; i++)
{
DataColumn column = new DataColumn();
column.DataType = sqldataReader.GetFieldType(i);
column.ColumnName = sqldataReader.GetName(i);
table.Columns.Add(column);
}
//添加表的数据
while(sqldataReader.Read())
{
DataRow datrow = table.NewRow();
for (int i = 0; i < sqldataReader.FieldCount; i++)
{
datrow[i] = sqldataReader[i].ToString();
}
table.Rows.Add(datrow);
}
//关闭数据阅读器
sqldataReader.Close();
return table;
}
catch (Exception ex)
{
throw new Exception(ex.Message,ex);
}
}