C#使用OracleDataReader返回DataTable

string data = string.Empty;
DataTable OutDataTable = new DataTable();
OracleDataReader daReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OutDataTable = new DataTable();
DataRow dataRow;

//设置Table名和Column名
OutDataTable.TableName ="test";
for (int j = 0; j < daReader.FieldCount; j++)
{
//获取列名
OutDataTable.Columns.Add(daReader.GetName(j));
}

//循环取数据集合中的数据,存到DataTable中
do
{
while (daReader.Read())
{
dataRow = OutDataTable.NewRow();
for (int j = 0; j < daReader.FieldCount; j++)
{
data = daReader[j].ToString();
dataRow[j] = data;
}
OutDataTable.Rows.Add(dataRow);
}
} while (daReader.NextResult());

dtTemp = OutDataTable;

 

posted @ 2019-02-14 08:34  吴土炮Jared  阅读(9802)  评论(0编辑  收藏  举报