hi !!!
in my program i need to store radio button's value in database so i used bit datatype for storing value and write bellow code
#region Insert
if (con.State == ConnectionState.Closed)
{
con.Open();
}
else
con.Close();
if (button2.Text == "Add")
{
CustomUnLock();
textBox1.ReadOnly = false;
button2.Text = "Save";
}
else
{
if (radioButton1.Checked == true)
{
cmd = new SqlCommand("PPrimaryInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@grnum", textBox1.Text));
cmd.Parameters.Add(new SqlParameter("@std", int.Parse(txtstd.Text)));
cmd.Parameters.Add(new SqlParameter("@PStname", textBoxAlphabetic1.Text));
cmd.Parameters.Add(new SqlParameter("@PRollno", int.Parse(txtrolnum.Text)));
cmd.Parameters.Add(new SqlParameter("@PConcesion", radioButton1.Text));
cmd.Parameters.Add(new SqlParameter("@PAdmissionfee", int.Parse(txtadmission.Text)));
cmd.Parameters.Add(new SqlParameter("@PSchoolfee", int.Parse(txtschool.Text)));
cmd.Parameters.Add(new SqlParameter("@PTermfee", int.Parse(txtterm.Text)));
cmd.Parameters.Add(new SqlParameter("@PMisalliancefee", int.Parse(txtmisalliance.Text)));
cmd.Parameters.Add(new SqlParameter("@PUniformfee", int.Parse(txtuniform.Text)));
if (radioButton3.Checked == true)
cmd.Parameters.Add(new SqlParameter("@Pbus", radioButton3.Text));
else
cmd.Parameters.Add(new SqlParameter("@Pnonbus", radioButton4.Text));
cmd.Parameters.Add(new SqlParameter("@PSchoobusfee", int.Parse(txtbus.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlAdmissionfee", int.Parse(txtadmissionamt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlSchoolfee", int.Parse(txtschoolamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlTermfee", int.Parse(txttermamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlMisalliancefee", int.Parse(txtmisallianceamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlSchoobusfee", int.Parse(txtbusamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlUniformfee", int.Parse(txtuniformamnt.Text)));
int i = cmd.ExecuteNonQuery();
label16.Text = i + "Record Added Successfully...";
CustomClear();
}
else
{
cmd = new SqlCommand("PPrimaryInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@grnum", textBox1.Text));
cmd.Parameters.Add(new SqlParameter("@std", int.Parse(txtstd.Text)));
cmd.Parameters.Add(new SqlParameter("@PStname", textBoxAlphabetic1.Text));
cmd.Parameters.Add(new SqlParameter("@PRollno", int.Parse(txtrolnum.Text)));
cmd.Parameters.Add(new SqlParameter("@PNonconcesion", radioButton2.Text));
cmd.Parameters.Add(new SqlParameter("@PAdmissionfee", int.Parse(txtadmission.Text)));
cmd.Parameters.Add(new SqlParameter("@PSchoolfee", int.Parse(txtschool.Text)));
cmd.Parameters.Add(new SqlParameter("@PTermfee", int.Parse(txtterm.Text)));
cmd.Parameters.Add(new SqlParameter("@PMisalliancefee", int.Parse(txtmisalliance.Text)));
cmd.Parameters.Add(new SqlParameter("@PUniformfee", int.Parse(txtuniform.Text)));
if (radioButton3.Checked == true)
cmd.Parameters.Add(new SqlParameter("@Pbus", radioButton3.Text));
else
cmd.Parameters.Add(new SqlParameter("@Pnonbus", radioButton4.Text));
cmd.Parameters.Add(new SqlParameter("@PSchoobusfee", int.Parse(txtbus.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlAdmissionfee", int.Parse(txtadmissionamt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlSchoolfee", int.Parse(txtschoolamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlTermfee", int.Parse(txttermamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlMisalliancefee", int.Parse(txtmisallianceamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlSchoobusfee", int.Parse(txtbusamnt.Text)));
cmd.Parameters.Add(new SqlParameter("@PActlUniformfee", int.Parse(txtuniformamnt.Text)));
int i = cmd.ExecuteNonQuery();
label16.Text = i + "Record Added Successfully...";
CustomClear();
}
}
#endregion
but while clicking on save button cmd.Executenonquery() shows error
Please help..