Converting Data reader to dataset

[nmsreddi]

Hello friends

I am using datareader to retrive data from my sqlserver database ,

but after retriving data my method should return dataset as the source ,

for that i have to convert datareader obj to dataset ,can any suggest the procedure

or any sample code for that ,

Thanks

[aspxkid]

see if this helps u:
http://authors.aspalli ance.com/stevesmith/articles/convertReaderto Set.asp

[ankurpatel]

[QUOTE=nmsreddi]Hello friends

i shall give Answer after 1 days . I done it and i got it.

[nateraaaa]

Hello friends

I am using datareader to retrive data from my sqlserver database ,

but after retriving data my method should return dataset as the source ,

for that i have to convert datareader obj to dataset ,can any suggest the procedure

or any sample code for that ,

Thanks

Why not just change your code to use a stored procedure to get the results then use a sqldataadapter to fill your dataset. Now return your dataset.

Nathan

[Plater]

You can use in-line SQL statement with a dataadapter too

[nmsreddi]

You can use in-line SQL statement with a dataadapter too

Inline Sql statement ? no idea

any way i will try for that

Thanks