I want to bring/display the sql data from one column to combobox as a drop downdown list in
vb.net. Hoe do i do that?
Dim strSQL As String = "SELECT * FROM RegionSiteCampus"
Dim SqlComm As New System.Data.SqlClient.SqlCommand(strSQL, conn)
Dim DR As System.Data.SqlClient.SqlDataReader
conn.Open()
DR = SqlComm.ExecuteReader
Do While DR.Read()
Combo_Region.Items.Add(DR.Item("Region"))
Combo_Site.Items.Add(DR.Item("Site"))
Any suggestions for better way to do it? I want the items in each column not to be repeated.
Thank you