Something like this:
sqlConnection Conn = new SqlConnection(
sqlCommand command = new SqlCommand(
SqlDataReader reader;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@id", id);
Conn.Open();
reader= command.ExecuteReader();
while(reader.Read())
{
}