string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\客户资料管理系统\\db1.mdb";
OleDbConnection oleDbConnection1 = new OleDbConnection(ConnectionString);
oleDbConnection1.Open();
OleDbCommand oleDbCommand1 = new OleDbCommand();
oleDbCommand1.Connection = oleDbConnection1;
oleDbCommand1.CommandType = CommandType.Text;
oleDbCommand1.CommandText = "UPDATE yhuser SET boox1='" + checkBox1.Checked + "', boox2='" + checkBox2.Checked + "', boox3='" + checkBox3.Checked + "', boox4='" + checkBox4.Checked + "', boox5='" + checkBox5.Checked + "', boox6='" + checkBox6.Checked + "', boox7='" + checkBox7.Checked + "', boox8='" + checkBox8.Checked + "', boox9='" + checkBox9.Checked + "' WHERE number like '%" + textBox15.Text + "%'";
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
请问那位大侠能告诉我错在那里
oleDbCommand1.ExecuteNonQuery();
这句报错
OleDbConnection oleDbConnection1 = new OleDbConnection(ConnectionString);
oleDbConnection1.Open();
OleDbCommand oleDbCommand1 = new OleDbCommand();
oleDbCommand1.Connection = oleDbConnection1;
oleDbCommand1.CommandType = CommandType.Text;
oleDbCommand1.CommandText = "UPDATE yhuser SET boox1='" + checkBox1.Checked + "', boox2='" + checkBox2.Checked + "', boox3='" + checkBox3.Checked + "', boox4='" + checkBox4.Checked + "', boox5='" + checkBox5.Checked + "', boox6='" + checkBox6.Checked + "', boox7='" + checkBox7.Checked + "', boox8='" + checkBox8.Checked + "', boox9='" + checkBox9.Checked + "' WHERE number like '%" + textBox15.Text + "%'";
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
请问那位大侠能告诉我错在那里
oleDbCommand1.ExecuteNonQuery();
这句报错
改为*号 之后结果还是一样的
我没装sql 不可以调试这个SQL语句对不对!
这个checked的值是布尔型的!
2.检查checkbox.check有值没有。
Select字段时,没有选取要显示数据字段,或选取错误;
你是拼接字符串,而不是传递参数,那么checkBox1.Checked就会以"true"或者'false'传入,而不是0或1,除非你的boox1是varchar型的,否则肯定无法更新。其它类似。
请问下该怎么做
谢谢
第2个 checkbox.checked的值不是默认为falus 吗?
谢谢 。
也有可能是读写数据库的权限问题
也有可能是传参问题
反正LZ你要一一去调试才知的,我以前都有碰到这个问题