Return Dataset after Executing Stored Proc

[MrMike]

Hi. I know how to use a SQLDataAdapter to execute a query and return a
dataset. For example...
SQLDataAdapter.Fill(DatasetInstance, "StoredProcName/TableName")

But could someone please give me an example of how to execute a query and
return a dataset using a SQLCommand? SQLCommand doesn't have a .Fill member,
so I'm not sure how to do this.

Thanks.

[Zeng]

You might want to consider posting this to
microsoft.public.dotnet.framework.adonet group instead.
"MrMike" <Mr****@discussions.microsoft.com> wrote in message
news:F9**********************************@microsof t.com...

Hi. I know how to use a SQLDataAdapter to execute a query and return a
dataset. For example...
SQLDataAdapter.Fill(DatasetInstance, "StoredProcName/TableName")

But could someone please give me an example of how to execute a query and
return a dataset using a SQLCommand? SQLCommand doesn't have a .Fill member, so I'm not sure how to do this.

Thanks.