Use the below code:
SqlConnection cn = new SqlConnection("your connection string");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText="storedprocedure name";
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("value in sp","datatype of that value","size").value="your value to be passed".
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"tbl");
then you will get the table into the dataset "ds".
you can retrieve them as:
ds.Tables[0].Rows[0]["cellname"].ToString();