ASP.NET

try
{
   SqlCommand cmd = new SqlCommand();
   cmd.Parameters.Clear();
   cmd.CommandType = CommandType.StoredProcedure;
   cmd.CommandText = "insertdata";
   if (rbt_Male.Checked)
   {
       cmd.Parameters.AddWithValue("@Name", txtbx_Name.Text);
       cmd.Parameters.AddWithValue("@Gender_Male", rbt_Male.Text);
       cmd.Parameters.AddWithValue("@Email", txtbx_Email.Text);
       cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime(txt_Dob.Text));
   }
   else if (rbt_Female.Checked)
   {
       cmd.Parameters.AddWithValue("@Name", txtbx_Name.Text);
       cmd.Parameters.AddWithValue("@Gender_Female", rbt_Male.Text);
       cmd.Parameters.AddWithValue("@Email", txtbx_Email.Text);
       cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime(txt_Dob.Text));
   }
   if (con.State == ConnectionState.Closed)
       con.Open();
   SqlCommand dataCommand = new SqlCommand(sql, dataConnection);
   cmd.ExecuteNonQuery();
   lbl_Errormsg.Visible = true;
   lbl_Errormsg.Text = "Record Inserted Successfully";
   con.Close();
}
catch (Exception ex)
{
   lbl_Errormsg.Visible = true;
   lbl_Errormsg.Text = ex.Message;
}