Click here to Skip to main content
Click here to Skip to main content
Go to top

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! Pinmemberrodvin27-Sep-10 2:18 
GeneralRe: Thank you for this terrific source code! PinmemberDaniel Carvalho Liedke27-Sep-10 11:53 
GeneralDon't handle base class events if you can help it. PinmemberBryan Kadzban1-Jun-05 10:12 
QuestionWhy drop-down doesn't function? PinmemberGigioTD14-Dec-04 5:55 
AnswerRe: Why drop-down doesn't function? PinmemberGigioTD14-Dec-04 6:49 
GeneralRe: Argent Help Needed PinmemberKunal Mukherjee25-Aug-04 4:11 
GeneralRe: Argent Help Needed PinmemberDaniel Carvalho Liedke25-Aug-04 11:56 
GeneralThe is exactly what I'm looking for. PinmemberVincent Ma30-Apr-04 22:39 
GeneralNeed Some Help PinsussBob Ranck26-Mar-04 5:34 
GeneralRe: Need Some Help PinmemberDaniel Carvalho Liedke26-Mar-04 5: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 | Mobile
Web01 | 2.8.140916.1 | Last Updated 19 Mar 2004
Article Copyright 2004 by Daniel Carvalho Liedke
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid