Records Don't Get Deleted From The Database!

I am using this code to delete records from a table in the database that has two fields (both are primary keys) I am not getting any error, but nothing gets deleted. Thanks for the help.

Code:protected void btnRemove_Click(object sender, EventArgs e)

{

 

Remove();Response.Redirect("RegisteredCompanies.aspx");

 

}protected void Remove()

{

//update database with filename

//Save Changes

connection.Open();using (SqlTransaction trans = connection.BeginTransaction())

{

try

{ SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "spRemoveCompany", new SqlParameter("@Userid", getGdUserID(Profile.UserName)),new SqlParameter("@BusinessID", getBusinessID());

}catch (Exception err)

{

// throw exception

trans.Rollback();

 lblStatus.Text = "An error has occurred in the delete process. Please try again.";

}

}

 Here is the stored procedure:ALTER PROCEDURE [dbo].[spRemoveCompany]

 

 

@Userid uniqueidentifier OUTPUT,

@BusinessID uniqueidentifier OUTPUT

 

 

 

ASDELETE FROM Associations2 WHERE Userid = @Userid AND BusinessID = @BusinessID

 

RETURN