I am not new to VB but am new to the classes in VB.net
I have a simple project so far:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
SqlConn1.Open()
Dim sqlReader As SqlDataReader = SqlCmd1.ExecuteReader(CommandBehavior.CloseConnection)
While sqlReader.Read
cmbRegions.Items.Add(sqlReader.GetString(0))
End While
sqlReader.Close()
End Sub
To start I dropped the SqlConnection icon (from the Data toolbox) onto my form. I then used the wizard and made a connection string, test succeeded.
I then dropped a SQLCommand object onto my form, specified the Connection as the SQLConnection above. I then create a CommandText for the SQLCommand object.
When I run the above code I get an error:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
This breaks on the SqlConn1.Open() line.
Anyone know what I am missing here? I have made connections before but never using the objects, I would always create my own.
I have a simple project so far:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
SqlConn1.Open()
Dim sqlReader As SqlDataReader = SqlCmd1.ExecuteReader(CommandBehavior.CloseConnection)
While sqlReader.Read
cmbRegions.Items.Add(sqlReader.GetString(0))
End While
sqlReader.Close()
End Sub
To start I dropped the SqlConnection icon (from the Data toolbox) onto my form. I then used the wizard and made a connection string, test succeeded.
I then dropped a SQLCommand object onto my form, specified the Connection as the SQLConnection above. I then create a CommandText for the SQLCommand object.
When I run the above code I get an error:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
This breaks on the SqlConn1.Open() line.
Anyone know what I am missing here? I have made connections before but never using the objects, I would always create my own.
