Probably not that much help Dim connect As New SqlConnection("CONNECT STRING HERE")Dim sqlTest As New SqlCommand()Dim query1 As [string] = "SELECT * FROM test WHERE user = 'testUser'"sqlTest.Connection = connectsqlTest.CommandType = System.Data.CommandType.TextsqlTest.CommandText = query1Dim sqlTestReader As SqlDataReadersqlTestReader = sqlTest.ExecuteReader()While sqlTestReader.Read() Dim result As [string] = sqlTestReader.GetString(0)End While Have you tried it without using the web config? Above I made a short query, I also defined the commandType, although I doubt this really matters. I am usually on an Oracle database but the namespace objects are really similar. Also, the code above is translated from C# to VB. Using http://converter.telerik.com/
Return database data as JSON
in .NET
Posted
Probably not that much help Dim connect As New SqlConnection("CONNECT STRING HERE")Dim sqlTest As New SqlCommand()Dim query1 As [string] = "SELECT * FROM test WHERE user = 'testUser'"sqlTest.Connection = connectsqlTest.CommandType = System.Data.CommandType.TextsqlTest.CommandText = query1Dim sqlTestReader As SqlDataReadersqlTestReader = sqlTest.ExecuteReader()While sqlTestReader.Read() Dim result As [string] = sqlTestReader.GetString(0)End While Have you tried it without using the web config? Above I made a short query, I also defined the commandType, although I doubt this really matters. I am usually on an Oracle database but the namespace objects are really similar. Also, the code above is translated from C# to VB. Using http://converter.telerik.com/