UC知道vb.net与sql连接查询?
来源：百度知道 编辑：UC知道 时间：2024/05/18 02:14:21
vb.net与sql连接后想查询 a2007b02表中有无 "哈哈 "这个项目,下面代码义勇就出错,我把下面的 ' " & biaoming & " '
换成 a2007b02就可以用,请问这个问题该怎么解决呢?
dim f as boolean =false
dim biaoming= "a2007b02 "
dim xiangmu= "哈哈 "
Dim conn As New SqlConnection( "server=.;initial catalog=jiaqin;user id=sa ") '连接数据库
Dim cmd As New SqlCommand( "select * from ' " & biaoming & " ' ", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader
Do While dr.Read()
If Trim(dr.Item( "菜单 ")) = xiangmu Then
conn.Close()
f = True
换成 a2007b02就可以用,请问这个问题该怎么解决呢?
dim f as boolean =false
dim biaoming= "a2007b02 "
dim xiangmu= "哈哈 "
Dim conn As New SqlConnection( "server=.;initial catalog=jiaqin;user id=sa ") '连接数据库
Dim cmd As New SqlCommand( "select * from ' " & biaoming & " ' ", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader
Do While dr.Read()
If Trim(dr.Item( "菜单 ")) = xiangmu Then
conn.Close()
f = True
把("select * from ' " & biaoming & " ' ", conn)改成：
("select * from" & biaoming,conn)
wolfyjr的回答是对的
vb.net里面的表名不需要用单引号围起，如果是担心表名和其他SQL其他名冲突可以用（）括起而不是单引号