why data was not inserted properly in asp.net(webapp)

protected void btn_post_Click(object sender, EventArgs e)

{

getid();

if (chk_emrgncy.Checked == true)

{

lbl_emr.Text = "YES";

}

else

{

lbl_emr.Text = "NO";

}

con.Open();

if (txt_recipient.Text != "" && txt_contact1.Text != "")

{

string str_insert = "insert into tbl_reqpost(pid,reqfor,quantity,bloodgroup,purpose,lastdate,country,state,district,city,recipname,age,emergency,stdcode,postalcode,contactno1,contactno2,contactperson,email,contactaddress,poston,postby)values(@pid,@reqfor,@quantity,@bloodgroup,@purpose,@lastdate,@country,@state,@district,@city,@recipname,@emergency,@age,@stdcode,@postalcode,@contactno1,@contactno2,@contactperson,@email,@contactaddress,@poston,@postby)";

SqlCommand cmdinsert = new SqlCommand(str_insert);

cmdinsert.Parameters.Add("@pid", SqlDbType.Int).Value = lbl_pid.Text;

cmdinsert.Parameters.Add("@reqfor", SqlDbType.VarChar).Value = ddl_reqfor.SelectedItem.Text;

cmdinsert.Parameters.Add("@quantity", SqlDbType.VarChar).Value = txt_quantity.Text;

cmdinsert.Parameters.Add("@bloodgroup", SqlDbType.VarChar).Value = ddl_bllodgroup.SelectedItem.Text;

cmdinsert.Parameters.Add("@purpose", SqlDbType.VarChar).Value = txt_purpose.Text;

cmdinsert.Parameters.Add("@lastdate", SqlDbType.VarChar).Value = txt_ldate.Text;

cmdinsert.Parameters.Add("@country", SqlDbType.VarChar).Value = ddl_country.SelectedItem.Text;

cmdinsert.Parameters.Add("@state", SqlDbType.VarChar).Value = ddl_state.SelectedItem.Text;

cmdinsert.Parameters.Add("@district", SqlDbType.VarChar).Value =ddl_dist.SelectedItem.Text;

cmdinsert.Parameters.Add("@city", SqlDbType.VarChar).Value = ddl_city.SelectedItem.Text;

cmdinsert.Parameters.Add("@recipname", SqlDbType.VarChar).Value = txt_recipient.Text;

cmdinsert.Parameters.Add("@age", SqlDbType.Int).Value = Convert.ToInt32(txt_reqage.Text);

cmdinsert.Parameters.Add("@emergency", SqlDbType.VarChar).Value = lbl_emr.Text;

cmdinsert.Parameters.Add("@stdcode", SqlDbType.VarChar).Value = txt_std.Text;

cmdinsert.Parameters.Add("@postalcode", SqlDbType.VarChar).Value = txt_postal.Text;

cmdinsert.Parameters.Add("@contactno1", SqlDbType.VarChar).Value = txt_contact1.Text;

cmdinsert.Parameters.Add("@contactno2", SqlDbType.VarChar).Value = txt_contact2.Text;

cmdinsert.Parameters.Add("@contactperson", SqlDbType.VarChar).Value = txt_contperson.Text;

cmdinsert.Parameters.Add("@email", SqlDbType.VarChar).Value = txt_email.Text;

cmdinsert.Parameters.Add("@contactaddress", SqlDbType.VarChar).Value = txt_faddress.Text;

cmdinsert.Parameters.Add("@poston", SqlDbType.DateTime).Value = System.DateTime.Now;

cmdinsert.Parameters.Add("@postby", SqlDbType.VarChar).Value = Session["id"].ToString();

InsertUpdateData2(cmdinsert);

Response.Write("");

}

else

{

lbl_pid.ForeColor = System.Drawing.Color.Red;

lbl_pid.Text = "Please fill required data";

}

con.Close();

}

private Boolean InsertUpdateData2(SqlCommand cmdinsert)

{

String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;

SqlConnection con = new SqlConnection(strConnString);

cmdinsert.CommandType = CommandType.Text;

cmdinsert.Connection = con;

try

{

con.Open();

cmdinsert.ExecuteNonQuery();

Response.Write("");

return true;

}

catch (Exception ex)

{

//lblMessage.Visible = true;

//lblMessage.Text = ex.Message;

Response.Write(ex.Message);

return false;

}

{

con.Close();

con.Dispose();

}

}