Create Dataset out of SqlDataReader

[Vijay Kerji]

Hi,

Is it possible to create the DataSet object out of SqlDataReader object?

Thanks.

Vijay K Kerji

 

[Miha Markic [MVP C#]]

Not automatically.
You might create one manually though.

 

[Francois]

Yes you can,

SqlDataReader myReader = myCommand.ExecuteReader();
myDataSet.DataSource = myReader;
myDataSet.DataBind();

By the way in the DataGridItem.DataItem will return DbDataRecord object a
instead of a DataRowView object. This information may be useful to you if
you use the ItemDataBound and ItemCreated event handlers.

Hope this help,

Francois.

 

[Sahil Malik]

Alternatively you could create a bindable datareader (if that solves your
need for a dataset).

http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/11/36078.aspx

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Teemu Keiski]

Convert a Data Reader into a DataSet
http://weblogs.asp.net/rosherove/archive/2004/01/22/61541.aspx