VB.net code to bind data in a combo box in Windows Application

Posted by Rajnilari2015 under VB.NET category on | Points: 40 | Views : 1096
Let's say we have a DataTable with the values being filled as under

Public Function GetData() As DataTable

Dim dt As New DataTable()

'Add some columns

dt.Columns.Add(New DataColumn("ImageID", GetType(Int32)))

dt.Columns.Add(New DataColumn("ImageData", GetType(String)))

'Add some rows

'First Row

Dim row1 As DataRow = dt.NewRow()

row1("ImageID") = 1

row1("ImageData") = "ImageData1"

'Second Row

Dim row2 As DataRow = dt.NewRow()

row2("ImageID") = 11

row2("ImageData") = "ImageData11"

'Third Row

Dim row3 As DataRow = dt.NewRow()

row3("ImageID") = 12

row3("ImageData") = "ImageData12"

'Fourth Row

Dim row4 As DataRow = dt.NewRow()

row4("ImageID") = 15

row4("ImageData") = "ImageData15"

'Fifth Row

Dim row5 As DataRow = dt.NewRow()

row5("ImageID") = 18

row5("ImageData") = "ImageData18"

'Sixth Row

Dim row6 As DataRow = dt.NewRow()

row6("ImageID") = 19

row6("ImageData") = "ImageData19"

'Seventh Row

Dim row7 As DataRow = dt.NewRow()

row7("ImageID") = 21

row7("ImageData") = "ImageData21"

'Add the rows to the table








'return the table

Return dt

End Function

Then fill into the combobox as under

Dim dt As DataTable = GetData()

comboBox1.Datasource = dt 'set the combobox data source
comboBox1.DisplayMember = ImageID ' Display column
comboBox1.ValueMember = ImageData ' Value member column

Comments or Responses

Login to post response