修改用户密码的代码!~谁帮我改改 ,连接的是ACCESS数据库,在线啊
this.conn7 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\database1.accdb");this.conn7.Open();
this.command7 = new System.Data.OleDb.OleDbCommand("select password from admin wher username='"+this.textBox1.Text+"'", this.conn7);
this.dataadapter7 = new System.Data.OleDb.OleDbDataAdapter();
this.dataadapter7.SelectCommand = this.command7;
this.dataset = new DataSet();
this.dataadapter7.Fill(this.dataset, "stu");
if (this.textBox1.Text == "" || this.textBox2.Text == "" || this.textBox3.Text == "" )
{
MessageBox.Show("不能为空");
return;
}
DataRow datarow = this.dataset.Tables[0].NewRow(); //新建一行
datarow[0] = this.textBox2.Text;
this.dataset.Tables[0].Rows.Add(datarow); //添加到数据集的表中
OleDbCommandBuilder cb = new OleDbCommandBuilder(this.dataadapter7);
try
{
this.dataadapter7.Update(this.dataset, "stu");
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
finally
{
MessageBox.Show("修改成功!");
}
--------------------编程问答-------------------- 你就不能告诉我哪里错了? --------------------编程问答-------------------- this.dataadapter7.Fill(this.dataset, "stu"); 说这句 格式错误!@不应该啊 --------------------编程问答-------------------- 要不帮我重新写写代码? --------------------编程问答-------------------- this.dataadapter7.Fill(this.dataset, "stu");
把this.dataset的this去掉.在试试.
你的程序有顺序都不对啊,要先判断控件,然后在修改数据..
finally
{
MessageBox.Show("修改成功!");
}
你的成功提示信息在finally里面? --------------------编程问答-------------------- 具体是什么错误? --------------------编程问答-------------------- 还是不对@还是老地方 出错舞 --------------------编程问答--------------------
OleDbConnection con = new OleDbConnection("provider=microsoft.jet.OLEDB.4.0;Data source=.\\odc.db");
con.Open();
OleDbDataAdapter com = new OleDbDataAdapter("Update admin SET 密码='" + textBox4.Text.Trim() + "' where 用户名='" + textBox1.Text.Trim() + "' and 密码='" + textBox2.Text.Trim() + "'", con);
DataSet di = new DataSet();
com.Fill(di, "dataname");
MessageBox.Show("修改密码成功.", "修改密码"); --------------------编程问答-------------------- 愿意帮我的家QQ啊 感激不尽啊!~549905721
补充:.NET技术 , C#