Click here to Skip to main content
15,868,048 members
Articles / Desktop Programming / Windows Forms

Data Combobox

Rate me:
Please Sign up or sign in to vote.
4.81/5 (6 votes)
27 Jul 2010CPOL2 min read 52.4K   3.5K   26   12
A custom combobox control that uses a datatable and can show multiple columns

Introduction

This is an example using a custom control to display multiple columns in a combobox. It uses a DataTable as its data source and unlike a standard combobox, it can show multiple columns so you show more information. It is inherited from the System.Windows.Forms.Combobox class.

Background

This project is based on an idea by SeeSharp in his Multi Column Combobox article. I used the same concept which was to inherit a Combobox and override the OnDropDown event to launch my form with the DataGridView. I initially was going to just make a DLL class but I hate having an EXE that requires other DLLs. I prefer to have things compiled right in. With that in mind, I wanted to make it simple to include the control in a project. So I combined my two forms into a single class.

Using the Code

You will only need two files:

  1. DataCombobox.cs, and
  2. DataCombobox.Designer.cs

Add the class file DataCombobox.cs to your project. This should also add DataCombobox.Designer.cs automatically.

Put the line...

C#
using datacombobox;

... in your form and then rebuild your solution. This will make the custom control show up in the toolbox so you can drag it to your form.

Here is a sample piece of code on how to use it.

C#
DataTable tbl = new DataTable();
tbl.Columns.Add("code", System.Type.GetType("System.String"));
tbl.Columns.Add("desc", System.Type.GetType("System.String"));
tbl.Columns.Add("other1", System.Type.GetType("System.String"));
tbl.Rows.Add("aaa", "the a thing", "");
tbl.Rows.Add("code2", "code #2", "");
tbl.Rows.Add("code3", "code #3", "");
tbl.Rows.Add("code4", "code #4", "just a code");
tbl.Rows.Add("widget", "some sort of device", "");
tbl.Rows.Add("code5", "code #5", "");
tbl.Rows.Add("rush", "awesome rock group", "");
tbl.AcceptChanges();

//these are required
dataCombobox1.TblData = tbl;
dataCombobox1.ValueColumn = "code";
dataCombobox1.SetText("widget");

//these are optional
//by default you will see all the columns in your table
//use ColumnNameList to make it show just certain columns
//this is a pipe delimited list
dataCombobox1.ColumnNameList = "code|desc";

//use ColumnHeaderList to define the text that show in the column headers
dataCombobox1.ColumnHeaderList = "Code|Description";

//you can control the width of the columns
dataCombobox1.WidthList = "50|200";

//you can control the width and height of the grid
dataCombobox1.PopupWidth = 300;
dataCombobox1.PopupHeight = 200;

The DataCombobox looks just like a regular Combobox until you click on the dropdown button. You can also hit the down arrow key to get the dropdown list.

Another useful property is the SearchColumn property. Normally hitting the letter keys causes a search on the ValueColumn field. But you can set the SearchColumn property and the searching takes place on that column instead. An example might be that you want to search a description instead of the actual code.

Look in the source code for a simple example project.

Points of Interest

One pitfall I discovered when working on the search by key code was that you must be careful to use the correct object. Initially I was searching through the rows of the DataTable and then using that position number to select a row in the DataGridView. But the problem with that is in order of the rows in the table may not be the same as the order in DataGridView. The user can click on a column header and change the sort order on the screen at any time. So I had to search by the rows in the DataGridView itself. You have to remember that even though a DataGridView DataSource is set to a DataTable, the row number selected in the DataGridView is not going to point to that row in the DataTable. They are two different kinds of rows.

History

  • 25th July, 2010: Initial version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
United States United States
I have a degree in Electrical Engineering and a degree in Computer Science. I have been working as a professional programmer since 1994 but have been messing around with computers and programming since the mid 1980's. I've worked with many languages over the years including progress,php,c,vb6 and c#. I enjoy reading science fiction and mystery/thrillers.

Comments and Discussions

 
Questionthank you, Pin
Andi Sielicki6-Aug-18 6:16
Andi Sielicki6-Aug-18 6:16 
GeneralMy vote of 5 Pin
Kanasz Robert27-Sep-12 11:02
professionalKanasz Robert27-Sep-12 11:02 
Questionpopup screen is not right below the combox Pin
Member 935510417-Aug-12 4:20
Member 935510417-Aug-12 4:20 
AnswerRe: popup screen is not right below the combox Pin
Jon McCain17-Aug-12 11:12
Jon McCain17-Aug-12 11:12 
QuestionHow can i get the value form the second column. Pin
stony1728-Feb-12 0:28
stony1728-Feb-12 0:28 
AnswerRe: How can i get the value form the second column. Pin
Jon McCain28-Feb-12 7:35
Jon McCain28-Feb-12 7:35 
GeneralRe: How can i get the value form the second column. Pin
stony1728-Feb-12 20:12
stony1728-Feb-12 20:12 
GeneralRe: How can i get the value form the second column. Pin
Jon McCain1-Mar-12 4:35
Jon McCain1-Mar-12 4:35 
GeneralRe: How can i get the value form the second column. Pin
stony171-Mar-12 18:54
stony171-Mar-12 18:54 
GeneralThanks Pin
YZK30-Mar-11 0:10
YZK30-Mar-11 0:10 
GeneralMy vote of 4 Pin
John Brett28-Jul-10 0:59
John Brett28-Jul-10 0:59 
GeneralGood Work Pin
Khaniya27-Jul-10 19:45
professionalKhaniya27-Jul-10 19:45 

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.