Click here to Skip to main content
11,629,535 members (65,627 online)
Click here to Skip to main content

Auto Complete Multi Column ComboBox

, 6 Oct 2005 134.2K 5.4K 60
Rate this:
Please Sign up or sign in to vote.
This is my version of an auto completing mutli column ComboBox.

Sample Image

Introduction

I have seen a few other multi column combo boxes and auto complete combo boxes so I decided to submit this code that does both.

Background

A while ago I needed to move a project from MS Access to C#. In Access it was using a lot of their nifty columned combo boxes and our customers would struggle mightily if there were any changes to this functionality. Thus the ColumnComboBox was born.

Using the code

This class can be used like any other ComboBox except the Items should be set using the Data property. This is a DataTable from which the ColumnComboBox gets all the data for filling the drop down box. Simply fill a DataTable as desired and then set the Data property with it.

//set the Data of the ColumnComboBox
myColumnComboBox.Data = myDataTable;

You can then set the column that will be displayed as the text of the combo box.

//set the ViewColumn
myColumnComboBox.ViewColumn = 2;

Any columns that you don't want to display in the drop down can be hidden like this:

//Set a few columns to not be shown
myColumnComboBox.Columns[1].Display = false;
myColumnComboBox.Columns[3].Display = false;

There are a few other properties to play with such as being able to turn auto complete off (myColumnComboBox.Suggest = false;) or an indexer for getting values from columns at the current rows.

Points of Interest

The code uses a few helper classes that are included either below the ColumnComboBox class or in another included file (StringList). The source for the ColumnComboBox is commented if you want to poke around yourself. I for one will be happier when/if they get templates into C#.

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

cavoliotmail.com1@h
United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

 
QuestionSelected Value Pin
Member 1110245613-Apr-15 3:21
memberMember 1110245613-Apr-15 3:21 
QuestionGood Article Pin
demouser74310-Jul-13 9:15
memberdemouser74310-Jul-13 9:15 
Generalthank you for posting article Pin
Aarti Meswania6-Dec-12 21:30
memberAarti Meswania6-Dec-12 21:30 
QuestionAssign a value to the ValueMember property, with data loaded from a DB Pin
ronaldnin16-Jul-12 10:04
memberronaldnin16-Jul-12 10:04 
QuestionCystral report calculation Pin
kwamebounty24-Jan-12 21:45
memberkwamebounty24-Jan-12 21:45 
QuestionAdding a new header for each Columns Pin
Member 321560111-Jan-12 0:32
memberMember 321560111-Jan-12 0:32 
GeneralMy vote of 5 Pin
fariborz sadighi12-Apr-11 23:32
memberfariborz sadighi12-Apr-11 23:32 
GeneralSelectedIndex issue [Solved] Pin
impy12-Jun-10 2:05
memberimpy12-Jun-10 2:05 
GeneralRe: SelectedIndex issue [Solved] Pin
RedDude8-Mar-11 10:57
memberRedDude8-Mar-11 10:57 
QuestionHow can I show the column name Pin
Nelio Sotomayor9-Dec-09 5:39
memberNelio Sotomayor9-Dec-09 5:39 
Questionhow to use in datagridview Pin
mkhalid0079-Jul-09 11:11
membermkhalid0079-Jul-09 11:11 
Generalcolumn headers Pin
arevans19-Nov-08 6:07
memberarevans19-Nov-08 6:07 
GeneralRe: column headers Pin
ewansw30-Dec-08 4:43
memberewansw30-Dec-08 4:43 
Generalget only one value Pin
JM ® - DE CASTRO30-Apr-08 3:22
memberJM ® - DE CASTRO30-Apr-08 3:22 
GeneralRTL Pin
nETbKA19-Apr-07 4:34
membernETbKA19-Apr-07 4:34 
GeneralRe: RTL Pin
cavoli119-Apr-07 5:12
membercavoli119-Apr-07 5:12 
GeneralRe: RTL Pin
nETbKA21-Apr-07 22:37
membernETbKA21-Apr-07 22:37 
GeneralRe: RTL Pin
cavoli123-Apr-07 4:01
membercavoli123-Apr-07 4:01 
GeneralIndexed items with sorted list Pin
dave.kelly28-Feb-07 21:11
memberdave.kelly28-Feb-07 21:11 
GeneralRe: Indexed items with sorted list Pin
cavoli11-Mar-07 5:05
membercavoli11-Mar-07 5:05 
GeneralRe: Indexed items with sorted list Pin
dave.kelly1-Mar-07 20:55
memberdave.kelly1-Mar-07 20:55 
GeneralRe: Indexed items with sorted list Pin
cavoli11-Mar-07 5:14
membercavoli11-Mar-07 5:14 
GeneralSet Selected Index Pin
salah_gis21-Feb-07 23:35
membersalah_gis21-Feb-07 23:35 
GeneralRe: Set Selected Index Pin
cavoli11-Mar-07 5:13
membercavoli11-Mar-07 5:13 
QuestionMouse pointer dissapears Pin
fonk6668-Feb-07 10:01
memberfonk6668-Feb-07 10:01 

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
Web04 | 2.8.150723.1 | Last Updated 6 Oct 2005
Article Copyright 2005 by cavoliotmail.com1@h
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid