数据集处理技术 DataReader DataTable DataSet 之间的转换

青格儿 2009-03-19

展开全文

http://www.cnblogs.com/binarytree/archive/2008/10/09/1306843.html

绑定Gridview里往往数据源是DataSet 或是DataTable 嗯，一些类库（SQLHelper等）里面的方法返回的是DataReader嗯，怎么把它们转成DataSet呢？

(1)

DataReader转为DataSet的类:

private DataSet DataReaderToDataSet(IDataReader reader)

{

DataTable table = new DataTable();

int fieldCount = reader.FieldCount;

for (int i = 0; i < fieldCount; i++)

{

table.Columns.Add(reader.GetName(i), reader.GetFieldType(i));

}

table.BeginLoadData();

object[] values = new object[fieldCount];

while (reader.Read())

{

reader.GetValues(values);

table.LoadDataRow(values, true);

}

table.EndLoadData();

DataSet ds = new DataSet();

ds.Tables.Add(table);

return ds;

}

(2)

注:DataAdapter与DataReader是不同的哦

DataAdapter可以这样做:

DataAdapter.Fill(ds)

(3)

#region DataReader转换为DataTable

        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        public static DataTable ConvertDataReaderToDataTable(SqlDataReader reader)
        {
            try
            {
                DataTable objDataTable = new DataTable();
                int intFieldCount = reader.FieldCount;
                for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)
                {
                    objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
                }

objDataTable.BeginLoadData();

                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);
            }
        }
        #endregion

http://space./14466241/viewspace-545525

http://didasoft./blog/274670

http://www.cnblogs.com/phoenix-rock/archive/2006/10/31/interoperability-recordset-dataset.html

DataTable缓存数据操作:

http://space./12639172/viewspace-526838

如何将SqlDataReader绑定到DataGrid

http://smilecong.blog.51cto.com/121860/21972

C#中提供的精准测试程序运行时间的类Stopwatch

http://blog.csdn.net/genghuilove/archive/2008/11/21/3345638.aspx

c#中连接数据库SqlDataAdapter的用法

http://bbs./showtxt.asp?id=106678

http://www.cnblogs.com/lvhaitao/archive/2006/12/25/602912.html