DataReader转DataSet方法

来源：互联网发布：java snmp4j get超时编辑：程序博客网时间：2024/06/05 12:41
public DataSet ConvertDataReaderToDataSet(SqlDataReader reader)        {            DataSet dataSet = new DataSet();            do            {                // Create new data table                DataTable schemaTable = reader.GetSchemaTable();                DataTable dataTable = new DataTable();                if (schemaTable != null)                {                    // A query returning records was executed                     for (int i = 0; i < schemaTable.Rows.Count; i++)                    {                        DataRow dataRow = schemaTable.Rows[i];                        // Create a column name that is unique in the data table                         string columnName = (string)dataRow["ColumnName"]; //+ " // Add the column definition to the data table                         DataColumn column = new DataColumn(columnName, (Type)dataRow["DataType"]);                        dataTable.Columns.Add(column);                    }                    dataSet.Tables.Add(dataTable);                    // Fill the data table we just created                    while (reader.Read())                    {                        DataRow dataRow = dataTable.NewRow();                        for (int i = 0; i < reader.FieldCount; i++)                        {                            dataRow[i] = reader.GetValue(i);                        }                        dataTable.Rows.Add(dataRow);                    }                }                else                {                    // No records were returned                    DataColumn column = new DataColumn("RowsAffected");                    dataTable.Columns.Add(column);                    dataSet.Tables.Add(dataTable);                    DataRow dataRow = dataTable.NewRow();                    dataRow[0] = reader.RecordsAffected;                    dataTable.Rows.Add(dataRow);                }            }            while (reader.NextResult());            return dataSet;        }
原文地址：http://blog.csdn.net/windok2004/article/details/2248874
0 0