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.