How can I convert DataSet a to a DataReader?

c# ado.net dataset datareader
anjum picture anjum · Aug 20, 2010 · Viewed 17.3k times · Source

How can I convert a DataSet to a DataReader?

Answer

Raghavendra Devraj picture Raghavendra Devraj · Feb 21, 2013

You can use the following code to change dataset to DataReader:

DataTableReader rd = ds.Tables[0].CreateDataReader();

Related questions

How to fill Dataset with multiple tables?

I'm trying to fill DataSet which contains 2 tables with one to many relationship. I'm using DataReader to achieve this : public DataSet SelectOne(int id) { DataSet result = new DataSet(); using (DbCommand command = Connection.CreateCommand()) { command.CommandText = "select * from table1"; var param = …

Read More
Reading DataSet

How do I read data from a DataSet in WPF? I have a train schedule table with just 2 columns and I want to be able to read the departure times and calculate when the next train is leaving. For example, …

Read More
How to test if a DataSet is empty?

I'm modifying someone else's code where a query is performed using the following: DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sqlString, sqlConn); da.Fill(ds); How can I tell if the DataSet is empty (i.e. no results were …

Read More