string str1 = "provider=Microsoft.Jet.OLEDB.4.0;Data source=student1.mdb;User Id=admin;Jet OLEDB:Database Password=admin";
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=" + textBox1.Text.Trim() + "where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
MessageBox.Show("密码修改成功!");为什么数据库中的数据修改后没反应?
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=" + textBox1.Text.Trim() + "where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
MessageBox.Show("密码修改成功!");为什么数据库中的数据修改后没反应?
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=" + textBox1.Text.Trim() + "where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.ExecuteNonQuery();
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password='" + textBox1.Text.Trim() + "' where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
cmd.ExecuteNonQuery();