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

DaShen

Lifer
Dec 1, 2000
10,710
1
0
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.