Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles
(untagged)

Data-bound Auto Complete Combo

0.00/5 (No votes)
18 Mar 2004 1  
A data-bound auto complete combo that filter items as you type.

Sample Image - DBAutoCompleteCombo.jpg

Introduction

This is a .NET auto complete combo-box component that binds to a dataset and filters combo items as you type, selecting the most similar item but showing other relatives items in the drop-down list.

Using the component

Right-click the toolbar, select add/remove itens and browse for the AutoCompleteComboBox.dll. Drag the component to the form as a normal combo-box.

Setting the data source

Use AddDataSource(DataTable,DisplayMember,ValueMember) method to set the combo data source.

Dim wDataSet As New DataSet
   
wDataSet.ReadXml("data.xml")

AutoCompleteComboBox1.AddDataSource(wDataSet.Tables(0), "UserName", "UserID")

The submit event

When enter is pressed in the combo, an event "submit" is raised. The example code shows the selected text and selected value when the user press enter.

Private Sub AutoCompleteComboBox1_Submit(ByVal sender As System.Object,_
 ByVal e As System.EventArgs) Handles AutoCompleteComboBox1.Submit

        Dim wComboValue As String = "(New Item)"

        If Not IsNothing(AutoCompleteComboBox1.SelectedValue) Then
           wComboValue = AutoCompleteComboBox1.SelectedValue
        End If

        lbInfo.Text = "Combo Item Text: " & _
    AutoCompleteComboBox1.SelectedText.ToString() & vbCrLf & _
    "Combo Item Code: " & wComboValue

    End Sub

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here