有人问到这个,就参照DNN的实现,用C#写了一个。记录下来作为备忘。
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![](/Images/OutliningIndicators/InBlock.gif)
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
}
23![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
23
![](/Images/OutliningIndicators/None.gif)
如果需要的话,columns的详细列属性还可以设置,比如IsDbNull等等。reader还有一个GetSchemaTable的方法,可以获得详细的列属性。