[問題] .NET 無法送出查詢指令

看板C_Sharp作者shaomi (kerker)時間16年前 (2010/01/17 17:43)推噓2(2推 0噓 1→)

留言3則, 3人參與討論串1/1

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

→

pico2k

01/17 17:50, , 1^F

01/17 17:50, 1^F

他說的原因就是這個 UPDATE不正確

推

kyoin

01/17 19:03, , 2^F

01/17 19:03, 2^F

問題是PASSWORD欄位是字串欄位@@

推

liunate