數(shù)據(jù)集處理技術 DataReader DataTable DataSet 之間的轉換

青格兒 2009-03-19

展開全文

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

綁定Gridview里往往數(shù)據(jù)源是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緩存數(shù)據(jù)操作:

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#中連接數(shù)據(jù)庫SqlDataAdapter的用法

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

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