使用单选按钮时execeutenonquery有问题吗？ [英] Problem with execeutenonquery while using radio button?
本文介绍了使用单选按钮时execeutenonquery有问题吗？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
嗨!!!
在我的程序中我需要在数据库中存储单选按钮的值，所以我使用位数据类型来存储值并写下以下代码
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
但点击保存按钮cmd.Executenonquery（）显示错误
请帮助..
but while clicking on save button cmd.Executenonquery() shows error
Please help..
推荐答案
错误是将数据类型nvarchar转换为bit时出错。
根据错误，您似乎将值传递给数据库，该数据库应该是布尔数据，而不是串。
确保按照列类型的预期为所有参数分配了正确的值。你形成的查询应该传递正确的数据。
The Error is "Error converting data type nvarchar to bit."
Based on the error, it seems you are passing a value to database that should be a boolean data and not a string.
Make sure you have assigned correct values to all the parameters as per expected by column type. You query formed should pass the right data.
大家好！
i得到我的观点...... :)
每当我们想存储一个单选按钮的文本，该时间在数据库中使用nvarchar数据类型。
我的错误是我把bit作为radiobutton的数据类型，因为我们知道bit可以存储0或1但我存储单选按钮的文本，这就是抛出错误的原因将数据类型nvarchar转换为位时出错。
感谢阅读..
hello to all!!
i got my point...:)
whenever we want to store a text of radio button that time use nvarchar datatype in database..
my mistake was i took bit as datatype of radiobutton as we know bit can store either 0 or 1 but i was storing text of radio button thats why error was thrown "Error converting data type nvarchar to bit."
Thanks for reading..
这篇关于使用单选按钮时execeutenonquery有问题吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
