110,572
社区成员
发帖
与我相关
我的任务
分享
public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader)
{
DataTable datatable = new DataTable();
try
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
DataColumn mydataColumn = new DataColumn();
mydataColumn.DataType = dataReader.GetFieldType(i);
mydataColumn.ColumnName = dataReader.GetName(i);
datatable.Columns.Add(mydataColumn);
}
while (dataReader.Read())
{
DataRow myDataRow = datatable.NewRow();
for (int i = 0; i < dataReader.FieldCount; i++)
{
myDataRow[i] = dataReader[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null;
}
dataReader.Close();
return datatable;
}
catch (Exception ex)
{
Console.WriteLine("error:" + ex.ToString());
return;//这里返回
}
}
public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader)
{
DataTable datatable = new DataTable();
try
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
DataColumn mydataColumn = new DataColumn();
mydataColumn.DataType = dataReader.GetFieldType(i);
mydataColumn.ColumnName = dataReader.GetName(i);
datatable.Columns.Add(mydataColumn);
}
while (dataReader.Read())
{
DataRow myDataRow = datatable.NewRow();
for (int i = 0; i < dataReader.FieldCount; i++)
{
myDataRow[i] = dataReader[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null;
}
dataReader.Close();
}
catch (Exception ex)
{
Console.WriteLine("error:" + ex.ToString());
}
return datatable; //放在函数外面.
}
catch (Exception ex)
{
Console.WriteLine("error:" + ex.ToString());
return datatable;
}