OleDbCommand cmd2 = new OleDbCommand("update [Admin] set [password]=@newpwd where [admin]=@name and [password]=@pwd", conn);
cmd2.Parameters.Add("@name", OleDbType.VarChar, 20).Value = tbxUserName.Text.ToString();
cmd2.Parameters.Add("@pwd", OleDbType.VarChar, 50).Value = tbxPwd.Text.ToString();
cmd2.Parameters.Add("@newpwd", OleDbType.VarChar, 50).Value = tbxNewPwd.Text.ToString();
int k = Int32.Parse(cmd2.ExecuteNonQuery().ToString());
提示update语法错误
经过一番查验发现access 参数顺序要和update语句中的参数出现顺序一致。改成:
cmd2.Parameters.Add("@newpwd", OleDbType.VarChar, 50).Value = tbxNewPwd.Text.ToString();
cmd2.Parameters.Add("@name", OleDbType.VarChar, 20).Value = tbxUserName.Text.ToString();
cmd2.Parameters.Add("@pwd", OleDbType.VarChar, 50).Value = tbxPwd.Text.ToString();
就ok了。