Question

ASP.NET(C#)更新ACCESS数据库，我的代码哪里错了？

protected void btnOK_Click(object sender, EventArgs e)
{

try
{
if (Session["PSW"].ToString()==txtPSW.Text)
{
string psw = txtNewPSW.Text;
string ID = Session["ID"].ToString();
string sql = "update Personal set PassWord= '"+ psw +"' where ID = '"+ID+"'";
OleDbConnection cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Inetpub\\wwwroot\\GIS\\GIS.mdb");
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sql, cnn);

cmd.Parameters.Add("@PassWord", OleDbType.Char).Value =psw;

cmd.ExecuteNonQuery();

//cmd.Dispose();
cnn.Close();

Session["PSW"] = txtNewPSW.Text;
}

}
catch (System.Exception ex)
{
lblMessage.Text = "出错! " + ex.Message+"----";
}

}
}

运行后ex.Message 说的是update语句出错，可是仔细检查了很多，没有发现那里错了，请高手指教

Answer 1

试 "update [Personal] set [PassWord]= '"+ psw +"' where [ID] = '"+ID+"'";
还有
cmd.Parameters.Add("@PassWord", OleDbType.Char).Value =psw;
这句去掉

Answer 2

"update Personal set PassWord= '"+ psw +"' where ID = '"+ID+"'";
，这句看看你的字段是什么类型，自动编号的话 where ID="+ID+"

Answer 3

把你的更新语句在查询分析器上实验一下就知道是不是更新语句出问题了