Execute the stored procedure with parameters.

SqlConnection sqlConn = new SqlConnection("...");
sqlConn.Open();

SqlCommand command= new SqlCommand("stored_procedure_name", sqlConn);
command.CommandType = CommandType.StoredProcedure;

// add parameter
command.Parameters.AddWithValue("@id", id);


int affectedRows = command.ExecuteNonQuery();