Fill combobox with records from database

15 Sep

Dim conex As New SqlClient.SqlConnection(“connectionString”)

Dim da As New SqlClient.SqlDataAdapter(“Select id, name , value, ordering  From periods order by ordering”, conex)

Dim ds As New DataSet

da.Fill(ds)

combo.DataSource = ds.Tables(0)

combo.DisplayMember = “name”

combo.ValueMember = “value”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: