Dataset to sqldatareader conversion

Question

I've a dataset with a table and I want to copy these values to sqldatareader. Is there any way to do this in C#?

I tried with ds.CreateDataReader(); but it is returning DataTableReader and not SQLDataReader.

Can someone tell me how to get it done?

Why do you need a SQLDataReader? Can you use the DbDataReader class that both inherit from? — D Stanley
– D Stanley, Commented Mar 5, 2014 at 14:55

Guffa · Accepted Answer · 2014-03-05 14:57:01Z

2

You can't copy data to a data reader, because the data reader doesn't contain any data in itself, it reads from a data source.

Each data reader reads from a specific data source, so for an SqlDataReader the data source would be an SQL Server database, not a DataSet object.

So, what you are specifically asking for is not possible. If you can use the DbDataReader base class instead of specifically the SqDataReader class, then you can use any data reader.

answered Mar 5, 2014 at 14:57

Guffa

703k112 gold badges760 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jestges Over a year ago

Thank you, I'll try this. I think this will solve my problem.

D Stanley · Accepted Answer · 2014-03-05 14:54:23Z

0

A SQLDataReader is for reading data from SQL Server, not from a DataSet - you'd have to get the original SQL query that was used to populate the dataset and re-query the server.

answered Mar 5, 2014 at 14:54

D Stanley

153k12 gold badges190 silver badges257 bronze badges

Collectives™ on Stack Overflow

Dataset to sqldatareader conversion

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related