username和email是数据库access里的字段
txtname和email是提供修改的文本框
当我执行代码时,没有任何提示,就是修改不了,但如果我把sql语句改成delete来执行是可以的,为什么?
Dim conn As OleDbConnection
Dim provider = "provider=microsoft.jet.oledb.4.0"
Dim database = "data source=" & Server.MapPath("data/news.mdb")
conn = New OleDbConnection(provider & ";" & database)
conn.Open()
Dim sql As String
Dim cmd As OleDbCommand
sql = "update users set username='" + Txtname.Text + "',email='"+ email.text +"' where id=" & Request("id")
cmd = New OleDbCommand(sql, conn) cmd.ExecuteNonQuery()
conn.Close()
txtname和email是提供修改的文本框
当我执行代码时,没有任何提示,就是修改不了,但如果我把sql语句改成delete来执行是可以的,为什么?
Dim conn As OleDbConnection
Dim provider = "provider=microsoft.jet.oledb.4.0"
Dim database = "data source=" & Server.MapPath("data/news.mdb")
conn = New OleDbConnection(provider & ";" & database)
conn.Open()
Dim sql As String
Dim cmd As OleDbCommand
sql = "update users set username='" + Txtname.Text + "',email='"+ email.text +"' where id=" & Request("id")
cmd = New OleDbCommand(sql, conn) cmd.ExecuteNonQuery()
conn.Close()
如果这样,类型会不匹配的
请哪位高手给我指点一下,求你了!!!!