Retrieve result from SqlCommand

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wong CS - 08 Mar 2005 18:15 GMT

Dear developer,

I'm developing a web service with VS .NET and using C#. And part of the
webservice is to get data from database (by using SELECT), however, the
result from the sql query i cannot parse it to string, how can i get the
result from the SqlCommand..? dataset or datareader..?.

pls advice & thanks a lot.

cheers,
Wong CS

Reply to this Message

DotNetJerome - 09 Mar 2005 09:11 GMT

Hi,

Both can be used to retrieve result from the SqlCommand. But it depends on
huv you are going to use. If you want to bind the datas to controls like data
grid or data list etc you go for dataset. Otherwise you can go with data
reader, the easyway.

Cheers,

Jerome. M

> Dear developer,
>
[quoted text clipped - 7 lines]
> cheers,
> Wong CS

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...