Question

ASP.NET中的更新语句哪里错了?就是更新不了数据库的内容

sub dl(sender as Object,e as EventArgs)
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../db/data.mdb"))
conn.open()
dim sqlstr,a as string
sqlstr="UPDATE admin SET admin_name ='" & admin_name.text & "' and admin_pass='" & admin_pass.text & "'"
Dim cmd As New OleDbCommand(sqlstr, conn)
cmd.executenonquery()----这句话有错吗?
conn.close()
end sub

Answer 1

sql语句应该有问题吧
C#的偶只会写
sqlstr="UPDATE admin SET admin_name ='" + admin_name.text + "'"+ "and admin_pass='"+ admin_pass.text + "'"

可以断点调试

看看这句运行后
这里设置断点sqlstr="UPDATE admin SET admin_name ='" & admin_name.text & "' and admin_pass='" & admin_pass.text & "'"
触发断点后看看sqlstr里面的字符串是什么
是不是你所需要的SQL语句

Answer 2

报什么错?
这句话有错原因很多的