hi....after i add all the records in textbox ,i click post and pay....but it does not add any record into the table ,does not show any error and does not show message that i add the record into the table.....what is the error....can anybody correct for me?

this is the code
protectedvoid Button3_Click(object sender, EventArgs e)
{
SqlConnection con;
SqlConnection connect;
SqlCommand cmdInsert;
SqlDataReader dtrJob;
SqlDataReader dtrCredit;
SqlCommand cmdRead;
SqlCommand cmdCredit;
SqlCommand cmdUpdate;
string newJbId = "J" + newJobID().ToString("D6");
string strEmp = Session["Employer"].ToString();
string message="";
string strUpdate = "";
double creditEmp = 0.00;
SqlCommand cmdInsertProfit;
SqlConnection connection;

con = newSqlConnection(ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString);
connection = newSqlConnection(ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString);
connect = newSqlConnection(ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString);

con.Open();
connect.Open();
string check = "Select * from JobPost Where Job_ID = @id";
string credit = "Select * from Employer Where Employer_Id=@employer";
cmdRead = newSqlCommand(check, con);
cmdCredit = newSqlCommand(credit, connect);

cmdRead.Parameters.AddWithValue("@id", newJbId);
cmdCredit.Parameters.AddWithValue("@employer", Session["Employer"].ToString());
dtrJob = cmdRead.ExecuteReader();
dtrCredit = cmdCredit.ExecuteReader();
if (dtrJob.HasRows)
{
lblMsg.Text = "JobPost already Exist!";
}
else
{
if (dtrCredit.Read())
{
creditEmp= Convert.ToDouble(dtrCredit["Employer_Credit"]);
if (creditEmp >= 10.00)
{

con.Close();
con.Open();
string insertJob = "Insert Into JobPost(Job_Id,Job_Desc,Job_Specialization,Job_Min Qualification,Job_PositionLevel,Job_Title,Job_CmpN ame,Job_Location,Job_Employment,YrsOfExperience,Jo b_CmpIntroduction,Employer_Id,job_Month)Values(@id ,@desc,@Special,@min_Qua,@position,@title,@cmpName ,@location,@job_Employ,@yrsExpe,@job_intro,@empid, @month)";
cmdInsert = newSqlCommand(insertJob, con);

cmdInsert.Parameters.AddWithValue("@id", newJbId);
cmdInsert.Parameters.AddWithValue("@desc", TextBox9.Text);
cmdInsert.Parameters.AddWithValue("@Special", DropDownList6.SelectedItem.Text);//DropDownList6.SelectedItem.Text
cmdInsert.Parameters.AddWithValue("@min_Qua", DropDownList10.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@position", DropDownList5.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@title", txtPosition.Text);
cmdInsert.Parameters.AddWithValue("@cmpName", TextBox10.Text);
cmdInsert.Parameters.AddWithValue("@location", DropDownList8.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@job_Employ", RadioButtonList1.SelectedItem.Text);//CheckBoxList1.SelectedItem.Text
cmdInsert.Parameters.AddWithValue("@yrsExpe", TextBox7.Text);
cmdInsert.Parameters.AddWithValue("@job_intro", TextBox11.Text);
cmdInsert.Parameters.AddWithValue("@empid", strEmp);
cmdInsert.Parameters.AddWithValue("@month", DateTime.Now.Month.ToString());
cmdInsert.ExecuteNonQuery();
con.Close();
message = "Record Added ! </br>";
creditEmp -= 10;
strUpdate = "Update Employer set Employer_Credit=@cre Where Employer_Id=@eID";
cmdUpdate = newSqlCommand(strUpdate, connect);
connect.Close();

connect.Open();
cmdUpdate.Parameters.AddWithValue("@eID", strEmp);
cmdUpdate.Parameters.AddWithValue("@cre", Convert.ToString(creditEmp));
cmdUpdate.ExecuteNonQuery();
message += "Your balance : ";
message += Convert.ToString(creditEmp);
connect.Close();
connection.Open();
string insertProfit = "Insert Into Profit(Related_Id,Profit_Type,Profit_Get,Profit_Mo nth)Values(@rel_id,@type,@gain,@ProMonth)";
cmdInsertProfit = newSqlCommand(insertProfit, connection);
cmdInsertProfit.Parameters.AddWithValue("@rel_id", newJbId);
cmdInsertProfit.Parameters.AddWithValue("@type", "Job");
cmdInsertProfit.Parameters.AddWithValue("@gain", 10.00);
cmdInsertProfit.Parameters.AddWithValue("@ProMonth", DateTime.Now.Month.ToString());
cmdInsertProfit.ExecuteNonQuery();
connection.Close();
}
else
{
message = dtrCredit["Employer_Credit"].ToString () + "Not Enough Credit . Please reload your Credit!";

}
}
else
{
lblMsg.Text = "Cannot found ";
}

}
lblMsg.Text = message ;
}