我的程序使用内置数据库。当我尝试放入连接字符串时,VB无法检测到连接字符串,并且在新的SqlConnection之后的第7行显示语法错误。我确信我从属性页复制了完整的连接字符串。
我读过这篇文章,但这似乎是一个不同的问题。下面是我的连接代码。我的代码有错误吗?谢谢你的帮助!
Imports System.Data.SqlClient
Public Class Login
Dim cmd As SqlCommand
Dim dr As SqlDataReader
Dim da As SqlDataAdapter
Dim sql As String
Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename="C:UserszhenweisourcereposCafeteria Ordering System v1.0Cafeteria Ordering System v1.0Database1.mdf";Integrated Security=True")
这显然会显示一个语法错误,请查看以下行:
"C:UserszhenweisourcereposCafeteria Ordering System v1.0Cafeteria Ordering System v1.0Database1.mdf"
将双引号替换为"<abc>
",以便在执行时与"<abc>
"类似,因为您已经在New SqlConnection("...")
中使用了"<abc>
"。
而不是:
Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename="C:UserszhenweisourcereposCafeteria Ordering System v1.0Cafeteria Ordering System v1.0Database1.mdf";Integrated Security=True")
你应该有:
Dim conn As SqlConnection = New SqlConnection("Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=""C:UserszhenweisourcereposCafeteria Ordering System v1.0Cafeteria Ordering System v1.0Database1.mdf"";Integrated Security=True")