How to return a DataSet from a SQL Server Stored Procedure in C#.Net

[Gunslinger08]

I need to pass a parameter to the stored procedure as well.

 

[Stuxnet]

Download the application block "SqlHelper" and use "ExecuteDataSet(...)".

 

[Spydermag68]

Chapter 19 from this website has the code.

Pro C# 2005

 

[DaShen]

Establish a (SQL, ADO, OLEDB) connection, Set a (SQL, ADO, OLEDB) Command using the stored procedure, Set & Instantiate a DataAdapter, Use the Command to set the Data Adapter, Fill the DataSet using the DataAdapter and whatever table or field you want, Use the DataSet in C#.

I think that is it. You may want to look it up though.