刚开始学~之前的insert into是因为字段name password是系统默认有的,会有错误,加上了[]就好了,但是update没有提示错误 可是一直没有更新数据。求指点啊-
private void button1_Click(object sender, EventArgs e)
{ OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "/" + "DB_student.mdb");
aConnection.Open();
string strqx,str1;
str1 = listBox1.SelectedValue.ToString();
MessageBox.Show(str1);
if (checkBox3.Checked == false)
strqx = "update Tuser set qx=0 where [name]='str1'";
else
strqx = "update Tuser set qx=1 where [name]='str1'";
MessageBox.Show(strqx);
OleDbDataAdapter myadapter = new OleDbDataAdapter(strqx, aConnection); //执行查询
DataSet ds = new DataSet(); //新建数据集
myadapter.Fill(ds);//将SQL执行结果,填入数据集ds中
MessageBox.Show("修改用户权限成功"); }
'str1' ?
字符串有问题吧
而不再是"update Tuser set qx=0 where [name]='str1'";
这就跟+TextBox.Text+一样。
strqx = string.format(strqx = "update Tuser set qx=0 where [name]='{0}'",str1);等等各种方法拼接SQL 语句字符串