I'm finally leaving the VB6 world...have Visual Studio 2010 installed. I've created a project and dropped some controls on it...just as an exercise, I want to populate my combo box from a command button click event. Of course I'm getting a runtime error, "ArgumentException was unhandled" on the ComboBox1.DataSource = objReader line. Do I have to reference something like I would in VB6? How does it know which field I want to choose for the combo box? I don't even know if I'm connected to the db. Will some kind Expert help me take this first step?
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strSQL As String
strSQL = ""
strSQL = "SELECT * FROM myDB.myOwner.myTable ORDER BY MyField"
'Establish connection and open database connection
Dim objConnection As New SqlClient.SqlConnection("server=mySQLServer;database=myDB;user=myUser;pwd=MyPWD")
'Establish command object
Dim objCommand As New SqlClient.SqlCommand(strSQL, objConnection)
Dim objReader As SqlClient.SqlDataReader
objReader = objCommand.ExecuteReader
ComboBox1.DataSource = objReader