Click here to Skip to main content
11,438,226 members (65,948 online)
Click here to Skip to main content

Data-bound Auto Complete Combo

, 18 Mar 2004
Rate this:
Please Sign up or sign in to vote.
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

Share

About the Author

Daniel Carvalho Liedke
Software Developer (Senior)
Brazil Brazil
I started development 22 years from now, since MSX basic. Started Windows programming with VB 2.0 and Web programming with ASP 3.0. Now I build Windows Forms, Web Applications, NT services and WPF applications using Microsoft.NET. I am MCP in Visual Basic 6.0, MCAD and MCSD.NET in Framework 1.1 ,MCPD Web in Framework 2.0, MCTS in .NET 3.5 workflow, MCTS in .NET 3.5 communication foundation and windows presentation foundation. Besides programming I love surfing.

Comments and Discussions

 
GeneralThank you for this terrific source code! Pin
rodvin27-Sep-10 3:18
memberrodvin27-Sep-10 3:18 
GeneralRe: Thank you for this terrific source code! Pin
Daniel Carvalho Liedke27-Sep-10 12:53
memberDaniel Carvalho Liedke27-Sep-10 12:53 
GeneralDon't handle base class events if you can help it. Pin
Bryan Kadzban1-Jun-05 11:12
memberBryan Kadzban1-Jun-05 11:12 
QuestionWhy drop-down doesn't function? Pin
GigioTD14-Dec-04 6:55
memberGigioTD14-Dec-04 6:55 
AnswerRe: Why drop-down doesn't function? Pin
GigioTD14-Dec-04 7:49
memberGigioTD14-Dec-04 7:49 
GeneralRe: Argent Help Needed Pin
Kunal Mukherjee25-Aug-04 5:11
memberKunal Mukherjee25-Aug-04 5:11 
GeneralRe: Argent Help Needed Pin
Daniel Carvalho Liedke25-Aug-04 12:56
memberDaniel Carvalho Liedke25-Aug-04 12:56 
GeneralThe is exactly what I'm looking for. Pin
Vincent Ma30-Apr-04 23:39
memberVincent Ma30-Apr-04 23:39 
GeneralNeed Some Help Pin
Bob Ranck26-Mar-04 6:34
sussBob Ranck26-Mar-04 6:34 
GeneralRe: Need Some Help Pin
Daniel Carvalho Liedke26-Mar-04 6:52
memberDaniel Carvalho Liedke26-Mar-04 6:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150506.1 | Last Updated 19 Mar 2004
Article Copyright 2004 by Daniel Carvalho Liedke
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid