You can check out the different DataSources that can be used for binding data to the RadComboBox in the Data Binding Overview | RadComboBox article.
Note that the RadComboBox uses a DataSource and has no direct relation to the SQL database itself.
Here is a sample of binding a single column DataTable to the RadComboBox
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim connstring As String = WebConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString
Dim conn As SqlConnection = New SqlConnection(connstring)
Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT DISTINCT [Country] FROM [Customers]", conn)
Dim dt As DataTable = New DataTable()
RadComboBox1.DataSource = dt
RadComboBox1.DataTextField = "Country"
RadComboBox1.DataValueField = "Country"
I hope this will prove helpful!
Progress is here for your business, like always. Read more
about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.