How to convert DataReader to dataset in C#
| Author | Topic |
|---|---|
| tech expert Member Joined: 17 Jul 2008 Country: Posts: 2 |  Posted: 17 Jul 2008 13:33:10  This is an example of how to convert DataReader into Dataset in C#. This is an example of how to convert DataReader into Dataset in C#.public DataSet ConvertDataReaderToDataSet(System.Data.SqlClient.SqlDataReader reader) { DataSet dataSet = new DataSet(); DataTable schemaTable = reader.GetSchemaTable(); DataTable dataTable = new DataTable(); for (int i = 0; i <= schemaTable.Rows.Count - 1; i++) { DataRow dataRow = schemaTable.Rows[i]; string columnName = dataRow["ColumnName"].ToString(); DataColumn column = new DataColumn(columnName, dataRow["DataType"].GetType()); dataTable.Columns.Add(column); } // www.infysolutions.com dataSet.Tables.Add(dataTable); while (reader.Read()) { DataRow dataRow = dataTable.NewRow(); for (int i = 0; i <= reader.FieldCount - 1; i++) { dataRow[i] = reader.GetValue(i); } dataTable.Rows.Add(dataRow); } return dataSet; } --------------------------------------- |
