Why Won't This Data Insert?

I am severly sleep deprived from this issue and this deliverable deadline is tomorrow, so anyone who can help me solve it will earn my deepest gratitude. 

I have a form that inserts/updates to one table (table A), then inserts a record into another table (table B) (based on the user_id generated from the insert on the first table).

All of my queries/inserts work fine, UNTIL I get to my last insert (the one for table B).  I don't get any compilation errors, and the insert/update to table A works just fine.  But table B continues to be empty.

 I have tried it by calling a stored procedure that does the update, as well as just writing the insert statement right into the code, and neither works.

 If I execute the stored procedure directly on the db server and manually pass it the parameters, the insert works.At first I thought that the problem must be in the placement of my code on the page -- that perhaps that section wasn't even executing.  But I know that it is because I can output my debugging that is contained right at the beginning of this section of code: 

// Insert the print material requests into the INFO_REQUEST table

//Response.Write("CB1: " + print_materials);

//Response.Write("CB2: " + pricing);

//Response.Write("CB3: " + newsletter);SqlCommand myCommand2;

 myCommand2 = new SqlCommand("info_request_insert", localConnection);

myCommand2.CommandType = CommandType.StoredProcedure;myCommand2.Parameters.Add(new SqlParameter("@user_id", user_id));

myCommand2.Parameters.Add(new SqlParameter("@current_customer", "N"));myCommand2.Parameters.Add(new SqlParameter("@print_product", "na"));

myCommand2.Parameters.Add(new SqlParameter("@print_materials", print_materials));myCommand2.Parameters.Add(new SqlParameter("@business_line", "na"));

myCommand2.Parameters.Add(new SqlParameter("@pricing", pricing));myCommand2.Parameters.Add(new SqlParameter("@demo", "na"));

myCommand2.Parameters.Add(new SqlParameter("@training", "na"));myCommand2.Parameters.Add(new SqlParameter("@ask_expert", "na"));

myCommand2.Parameters.Add(new SqlParameter("@recommend_friend_email", ""));myCommand2.Parameters.Add(new SqlParameter("@user_from", newsletter));

myCommand2.Parameters.Add(new SqlParameter("@cad_programs", "na"));myCommand2.Parameters.Add(new SqlParameter("@solver_programs", "na"));

myCommand2.Parameters.Add(new SqlParameter("@desktop_platform", "na"));myCommand2.Parameters.Add(new SqlParameter("@current_customer", "na"));

myCommand2.Parameters.Add(new SqlParameter("@submit_date", DateTime.Now));myCommand2.Parameters.Add(new SqlParameter("@comments", "na"));

try

{

myCommand2.Connection.Open();

myCommand2.ExecuteNonQuery();

myCommand2.Connection.Close();

}catch (Exception ex)

{Trace.Write("00-msg", ex.Message);if (myCommand2.Connection.State == ConnectionState.Open)

{

myCommand2.Connection.Close();

}

}