Click here to Skip to main content
14,424,458 members

Auto Complete Multi Column ComboBox

Rate this:
3.88 (20 votes)
Please Sign up or sign in to vote.
3.88 (20 votes)
6 Oct 2005
This is my version of an auto completing mutli column ComboBox.

Sample Image


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.


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#.


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


About the Author

United States United States
No Biography provided

Comments and Discussions

Questionhow to get other columns values when using DataTable from DB Pin
babakvb9-Nov-18 22:17
Memberbabakvb9-Nov-18 22:17 
AnswerSolution: ComboBox is cleared on enter key Pin
Member 1103358213-Oct-16 23:12
MemberMember 1103358213-Oct-16 23:12 
QuestionSelected Value Pin
Member 1110245613-Apr-15 4:21
MemberMember 1110245613-Apr-15 4:21 
AnswerRe: Selected Value Pin
srfox23-Apr-16 1:12
professionalsrfox23-Apr-16 1:12 
QuestionGood Article Pin
demouser74310-Jul-13 10:15
Memberdemouser74310-Jul-13 10:15 
Generalthank you for posting article Pin
Aarti Meswania6-Dec-12 22:30
MemberAarti Meswania6-Dec-12 22:30 
QuestionAssign a value to the ValueMember property, with data loaded from a DB Pin
ronaldnin16-Jul-12 11:04
Memberronaldnin16-Jul-12 11:04 
QuestionCystral report calculation Pin
kwamebounty24-Jan-12 22:45
Memberkwamebounty24-Jan-12 22:45 
QuestionAdding a new header for each Columns Pin
Member 321560111-Jan-12 1:32
MemberMember 321560111-Jan-12 1:32 
GeneralMy vote of 5 Pin
fariborz sadighi13-Apr-11 0:32
Memberfariborz sadighi13-Apr-11 0:32 
GeneralSelectedIndex issue [Solved] Pin
impy12-Jun-10 3:05
Memberimpy12-Jun-10 3:05 
GeneralRe: SelectedIndex issue [Solved] Pin
RedDude8-Mar-11 11:57
MemberRedDude8-Mar-11 11:57 
QuestionHow can I show the column name Pin
nm19709-Dec-09 6:39
Membernm19709-Dec-09 6:39 
Questionhow to use in datagridview Pin
mkhalid0079-Jul-09 12:11
Membermkhalid0079-Jul-09 12:11 
Generalcolumn headers Pin
arevans19-Nov-08 7:07
Memberarevans19-Nov-08 7:07 
GeneralRe: column headers Pin
ewansw30-Dec-08 5:43
Memberewansw30-Dec-08 5:43 
Generalget only one value Pin
JM ® - DE CASTRO30-Apr-08 4:22
MemberJM ® - DE CASTRO30-Apr-08 4:22 
GeneralRTL Pin
nETbKA19-Apr-07 5:34
MembernETbKA19-Apr-07 5:34 
GeneralRe: RTL Pin
cavoli119-Apr-07 6:12
Membercavoli119-Apr-07 6:12 
GeneralRe: RTL Pin
nETbKA21-Apr-07 23:37
MembernETbKA21-Apr-07 23:37 
GeneralRe: RTL Pin
cavoli123-Apr-07 5:01
Membercavoli123-Apr-07 5:01 
GeneralIndexed items with sorted list Pin
dave.kelly28-Feb-07 22:11
professionaldave.kelly28-Feb-07 22:11 
GeneralRe: Indexed items with sorted list Pin
cavoli11-Mar-07 6:05
Membercavoli11-Mar-07 6:05 
GeneralRe: Indexed items with sorted list Pin
dave.kelly1-Mar-07 21:55
professionaldave.kelly1-Mar-07 21:55 
GeneralRe: Indexed items with sorted list Pin
cavoli11-Mar-07 6:14
Membercavoli11-Mar-07 6:14 

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

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

Posted 6 Oct 2005


65 bookmarked