将DataReader 转为 DataTable

最新推荐文章于 2021-01-26 21:33:55 发布

weixin_30764883

最新推荐文章于 2021-01-26 21:33:55 发布

阅读量72

点赞数

原文链接：http://www.cnblogs.com/sumh/archive/2007/09/11/889670.html

版权

    /// <summary>
    /// 将DataReader 转为 DataTable
    /// </summary>
    /// <param name="DataReader">OleDbDataReader</param>
    protected DataTable ConvertDataReaderToDataTable(OleDbDataReader reader)
    {
        DataTable objDataTable = new DataTable("TmpDataTable");
        try
        {
            int intFieldCount = reader.FieldCount;//获取当前行中的列数；
            for (int intCounter = 0; intCounter <= intFieldCount - 1; intCounter++)
            {
                objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
            }
            //populate   datatable
            objDataTable.BeginLoadData();
            //object[]   objValues   =   new   object[intFieldCount   -1];
            object[] objValues = new object[intFieldCount];
            while (reader.Read())
            {
                reader.GetValues(objValues);
                objDataTable.LoadDataRow(objValues, true);
            }
            reader.Close();
            objDataTable.EndLoadData();
            return objDataTable;
        }
        catch (Exception ex)
        {
            throw new Exception("转换出错出错!", ex);
        }