数据库连接实例
一、验证密码
- OleDbConnection mdbcnn1 = new OleDbConnection(@" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DSellManager.mdb;Persist Security Info=True");
- string sSQL = "Update [password] Set [Password]='" + dbnewpw + "' where ID=1";
- mdbcmd = new OleDbCommand("select * from [password] where ID=1", mdbcnn1);
- mdbcnn1.Open();
- OleDbCommand myCommand = new OleDbCommand(sSQL, mdbcnn1);
- if (myCommand.ExecuteNonQuery() > 0)
- {
- MessageBox.Show("修改密碼成功 ,請記好你的新密碼 ");
- this.Close();
- }
- else
- {
- MessageBox.Show("修改密碼失敗!");
- }
- mdbcnn1.Close();