sql语句没错 mysql.data.dll"类型的异常,我如何解决system.data.dll附加信息中出现的'system.data.sqlclient.sqlexception'类型的第一次机...

I would like to read in a specific row from a database table. Here is the VB code I tried:Dim sqlQuery As String = String.Format("SELECT * FROM Verification.dbo.VersionValues WHERE VersionID = '{0}'", My.Settings.VersionsVersion)

Dim connStr As String = ConfigurationManager.ConnectionStrings(pConnStringName).ConnectionString

Dim dt As New DataTable

Using conn As New SqlConnection(connStr)

conn.Open()

Using dAd As New SqlDataAdapter(sqlQuery, conn)

dAd.Fill(dt)

End Using

End Using

Dim val As String = dt(0).Item("LatestUBoot").ToString

The following error message occurs when trying to execute line "dAd.Fill(dt)"

Quote:A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Invalid object name 'Verification.dbo.VersionValues'.

What I have tried:

The query works in SQL Server Management Studio.

解决方案RESOLVED: The connection string in App.config was incorrect.