Avatar of arichexe
arichexe

asked on 

VB.NET SQL problem

I'm attempting to retrieve an integer from a table using the below VB.NET snippet, but I'm getting an "Input string was not in a correct format" error.  MyInt is not null, so that's not the problem.  What am I doing wrong?

Dim MyInt As Integer
Dim conn = CreateObject("ADODB.Connection")
conn.Open("driver={SQL Server};server=(local);uid=MyUid;pwd=MyPwd;database=MyDatabase")

Dim rs = conn.Execute("SELECT MyInt FROM MyTable")
If Not rs.EOF Then
  MyInt = CInt(rs("MyInt").ToString)
End If
rs.close()
conn.Close()
Visual Basic.NET

Avatar of undefined
Last Comment
arichexe
ASKER CERTIFIED SOLUTION
Avatar of gangwisch
gangwisch

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of arichexe
arichexe

ASKER

I'm getting ASP.NET compile errors on SqlConnection, SqlCommand, and SqlDataReader.  Am I missing a referrence.  I have System.Data.  Isn't that enough?
Avatar of arichexe
arichexe

ASKER

Add "Imports System.Data.SqlClient" and it works fine.  Thanks!
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo