Try this. Just paste the code into a button's click event. You'll need to change the items shown bold to match your database settings.

string oConnString = "Data Source=localhost;Initial Catalog=ALocalDataBase;Integrated Security=True";

SqlConnection oConn = new SqlConnection(oConnString);

SqlCommand oCmd = new SqlCommand("Exec sp_AnSProc", oConn);

SqlDataAdapter oAdptr = new SqlDataAdapter(oCmd);

DataSet oDS = new DataSet();

oConn.Open();

oCmd.ExecuteNonQuery();

oCmd.CommandTimeout = 600;

oAdptr.Fill(oDS);

//uncomment the following line to view the xml representation of the data returned

//System.Diagnostics.Debug.WriteLine(oDS.GetXml());

oConn.Close();

Note: If your stored procedure requires that parameters be passed in, just use String Concatenation.

Good luck. I hope this helps.