combobox that's datadriven

[jvcoach23]

I'm trying to bind an sp to a combobox with the dropdown style. I've created a connection and a sqlDataAdapter.. but my code doesn't seem to work...

 

Imports System.Data

Imports System.Data.SqlClient

 

 

Public Class Form3

Inherits System.Windows.Forms.Form

 

Dim myConnection As SqlConnection = New SqlConnection("server=(local);database=dts;uid=sa;password=notwhatImshowing")

Dim myAdapter As SqlDataAdapter = New SqlDataAdapter("spPackageName", myConnection)

Dim myDS As DataSet

Dim WithEvents myDV As DataView

 

 

 

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged

Me.ComboBox1.DropDownStyle = ComboBoxStyle.DropDown

With Me

.myDS = New DataSet

.myAdapter.Fill(myDS)

.myDV = New DataView(myDS.Tables("spPackageName"))

.ComboBox1.DataSource = myDS

.myConnection.Open()

.myConnection.Close()

 

 

End With

 

End Sub

 

 

End Class

 

 

Sql I know.. vb.net I'm just trying to learn. Any help would be great.

[PlausiblyDamp]

you will also need to set the ComboBox1.DisplayMember and possibly the .ValueMember