[I'm not an expert, but:]
The sqlDataAdaptor constructor accepts an sqlCommand object. Point the
sqlCommand to your sproc. Use the sqlDataAdaptor to place the resultset in
the DataSet.

There is a ADO.Net list where you can ask these questions. It's under the
ASP category at p2p.wrox.com and it's called adox_net

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Vittal_setty" <Vittal_setty@i...>
Subject: [sql_language] Stored Proc Returning a dataset???


Hi All,

I am currently with ADO.NET and SQL server2000.

Is it possible for a stored proc to return a dataset.
A dataset is basically an XML and a stored proc can return data as XML
RAW or XML Explicit.  So I guess this should be possible.

Can anyone throw some more light on this?
Would highly appreciate if any sample code/ links are available.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~