作者shaomi (kerker)
看板C_Sharp
标题[问题] .NET 无法送出查询指令
时间Sun Jan 17 17:43:41 2010
OleDbConnection Conn = new OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
"C:\\Documents and Settings\\USER\\桌面\\WebSites\\WebSite1\\App_Data\\资料库.mdb;");
string strSQL2 = "Update Member SET Password = '" + TextBox3.Text.ToString() + "'" + " Where Account ='" + Session["Account"].ToString() + "'";
//string strSQL2 = "Update Member set password = '123'";
OleDbCommand objCmd2 = new OleDbCommand(strSQL2, Conn);
try
{
objCmd2.Connection.Open();
objCmd2.ExecuteNonQuery();
Label1.Text = "密码更新成功";
}
catch (Exception ex)
{
Response.Write(ex.ToString());
Response.Write(strSQL2);
}
objCmd2.Connection.Close();
Conn.Close();
他总是印出UPDATE陈述式不正确
可是我把strSQL2印出来语法也是对的= =
後来我用最简单的 Update Member set password = '123' 也是说我语法错误
我也放入ACCESS里面执行过了 也会跑
但是现在就是不知道为何会这样= =
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.118.41.144
1F：→ pico2k:请用ex.toString()来检查exception的原因... 01/17 17:50
他说的原因就是这个 UPDATE不正确
2F：推 kyoin:把单引号去掉试试看 Update Member set password = 123 01/17 19:03
问题是PASSWORD栏位是字串栏位@@
3F：推 liunate:难道Member是关键字？ 用[] (不确定...)包起来 01/18 00:31
试过了Orz
※ 编辑: shaomi 来自: 140.118.109.13 (01/18 15:18)
去找过後发现 PASSWORD要要加[] 才解决= = 弄了老半天
※ 编辑: shaomi 来自: 140.118.109.13 (01/18 16:03)