C # Access prompts update syntax error

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 ());

Prompt for UPDATE syntax error

After some examination found that the order of the access parameters is in the same order as the parameters in the UPDATE statement. Change into:

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 ();
It's OK.