将DataReader转换为DataTable

来源：互联网发布：机床主轴结构优化设计编辑：程序博客网时间：2024/05/23 19:15

        public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader)        {            ///定义DataTable            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)            {                ///抛出类型转换错误                //SystemError.CreateErrorLog(ex.Message);                throw new Exception(ex.Message, ex);            }        }

http://blog.sina.com.cn/s/blog_670658840100sprb.html