Click here to Skip to main content
15,891,033 members
Articles / Programming Languages / C#

Multi Column Combo Cell for the .NET 2.0 DataGridView Control

Rate me:
Please Sign up or sign in to vote.
3.19/5 (14 votes)
25 Dec 2008CPOL2 min read 194.9K   9.8K   70   66
This article will demonstrate an approach to solve the issue of a multi-column cell for DataGridView.

Illustration.gif

Introduction

This article will demonstrate an approach to solve the issue of multi-column combobox cells in a DataGridView in VS8.

*New in this version

*After multiple comments that I got about the old implementation, I decided to make this solution nicer. I am following the solution using designed DataSet tables and dropping some workarounds and fixing some bugs I had in my first version!

Background

Several months ago, I invested several days in order to find how to implement the multiline combobox issue. I found several solutions but they didn't fit my needs. I wanted something very simple. And I found it using the owner draw approach - just drawing a multicolumn control by myself. Here are the results.

Using the code

The code implementation and usage is extremely simple.

You do all the steps as you do if you want to embed a regular combobox into your DataGridView, but in place of the DataGridViewComboColumn, you use my class DataGridViewMultiColumnComboColumn. This class is derived from DataGridViewComboColumn. Additionally, you need to set the column CellTemplate with the DataGridViewMultiColumnComboCell class that is derived from DataGridViewMultiColumnComboCell. After creating the DataGridViewMultiColumnComboCell class, you will need to set two data members in order to allow the multiline combobox to display the relevant values.

C#
//create the multicolumncombo column
DataGridViewMultiColumnComboColumn newColumn = 
            new DataGridViewMultiColumnComboColumn();

newColumn.CellTemplate = new DataGridViewMultiColumnComboCell();
//Set the source table settings from the database for combobox values
newColumn.DataSource = ds.LogMessageTypes;
newColumn.DisplayMember = ds.LogMessageTypes.TypeNameColumn.ColumnName;
newColumn.ValueMember = ds.LogMessageTypes.TypeIdColumn.ColumnName;

//this property point on main table of this grid to bind to this column
newColumn.DataPropertyName = ds.LogTable.TypeColumn.ColumnName;
newColumn.HeaderText = ds.LogTable.TypeColumn.ColumnName;

newColumn.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;

dataGridView1.Columns.Remove(ds.LogTable.TypeColumn.ColumnName);
dataGridView1.Columns.Insert(position, newColumn);
dataGridView1.Columns[position].Width = 300;

Points of interest

First, I am very happy that after 12 years of programming experience I found a way to contribute something small to this great professional discussion.

I am originally a C++/MFC programmer and I still work mostly using these programming languages. So I am strictly used to things that implement non-standard UIs. I think Microsoft did a great job developing the .NET platform. Anyway.

BTW: I still love developing ActiveX in C++ but there is no client that wants it anymore and I can understand why :).

Disclaimer of warranty

All of the code, information, instructions, and recommendations in this article are offered on a strictly "as is" basis. This material is offered as a free public resource, without any warranty, expressed or implied.

This code is completely free. I will be happy to know if it was helpful for somebody.

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)
Israel Israel
Software Development freelancer.

Comments and Discussions

 
GeneralRe: Setting the selectedvalue for the dropdown.... Pin
IssaharNoam28-Oct-09 12:04
IssaharNoam28-Oct-09 12:04 
GeneralRe: Setting the selectedvalue for the dropdown.... Pin
Simon O'Farrell28-Oct-09 13:28
Simon O'Farrell28-Oct-09 13:28 
GeneralRe: Setting the selectedvalue for the dropdown.... Pin
IssaharNoam29-Oct-09 10:44
IssaharNoam29-Oct-09 10:44 
Questionhow to get value of Combobox columns in which event of datagridview. and display in netx cell Pin
PankajRai.Net14-Oct-09 2:56
PankajRai.Net14-Oct-09 2:56 
AnswerRe: how to get value of Combobox columns in which event of datagridview. and display in netx cell Pin
IssaharNoam14-Oct-09 11:16
IssaharNoam14-Oct-09 11:16 
Questionhow to get value of Combobox columns in which event of datagridview...??? [modified] Pin
Narendra Reddy Vajrala20-Aug-09 3:01
Narendra Reddy Vajrala20-Aug-09 3:01 
NewsImportant: My owner draw code contains GDI leaks, Please be aware to dispose all the allocate brushes and pens Pin
IssaharNoam9-Apr-09 12:56
IssaharNoam9-Apr-09 12:56 
GeneralSupporting IList as DataSource Pin
Kashif Iqbal Khan8-Apr-09 4:58
Kashif Iqbal Khan8-Apr-09 4:58 
This control is wonderful. However in my case I needed to use IList as DataSource.

Although I have found a working solution but am not very satisfied with it. WIll be working more on it. Is there anyone facing the same problem? or may be author would like to enhance the control.

Here is my implementation of in OnDrawItem of DataGridViewMultiColumnComboEditingControl

if(currentRow!=null)
{
   // Here is the original source that I have omitted 
}
else
{
        string currentText = GetItemText(Items[e.Index]);

        //first redraw the normal while background
        SolidBrush normalBack = new SolidBrush(Color.White); //TODO: fix to be system edit box background
        e.Graphics.FillRectangle(normalBack, rec);


	if (DroppedDown && !(Margin.Top == rec.Top))
	{


		Type objectType = objCurrentItem.GetType();

		PropertyInfo propertyDisplay = objectType.GetProperty(this.DisplayMember);
		PropertyInfo propertyValue = objectType.GetProperty(this.ValueMember);

		PropertyInfo[] properties = new PropertyInfo[] { propertyValue, propertyDisplay };


		int currentOffset = rec.Left;

		SolidBrush HightlightedBack = new SolidBrush(System.Drawing.SystemColors.Highlight);
		if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
		{
			//draw selected color background
			e.Graphics.FillRectangle(HightlightedBack, rec);
		}

		bool addBorder = false;


		foreach (PropertyInfo p in properties)
		{
			string value = p.GetValue(objCurrentItem, null).ToString(); //TODO: support for different types!!!

			if (addBorder)
			{
				//draw dividing line
				//currentOffset ++; 
				SolidBrush gridBrush = new SolidBrush(Color.Gray); //TODO: make the border color configurable
				long linesNum = lineWidth;
				while (linesNum > 0)
				{
					linesNum--;
					Point first = new Point(rec.Left + currentOffset, rec.Top);
					Point last = new Point(rec.Left + currentOffset, rec.Bottom);
					e.Graphics.DrawLine(new Pen(gridBrush), first, last);
					currentOffset++;
				}
			}
			else
			{
				addBorder = true;
			}

			SizeF extent = e.Graphics.MeasureString(value, e.Font);
			decimal width = (decimal)extent.Width;
			//measure the string that we are goin to draw and cut it with wrapping if too large
			Rectangle textRec = new Rectangle(currentOffset, rec.Y, (int)decimal.Ceiling(width), rec.Height);

			//now draw the relevant to this column value text
			if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
			{
				//draw selected
				SolidBrush HightlightedText = new SolidBrush(System.Drawing.SystemColors.HighlightText);
				//now redraw the backgrond it order to wrap the previous field if was too large
				e.Graphics.FillRectangle(HightlightedBack, currentOffset, rec.Y, fixedAlignColumnSize, extent.Height);
				//draw text as is 
				e.Graphics.DrawString(value, e.Font, HightlightedText, textRec);
			}
			else
			{
				//now redraw the backgrond it order to wrap the previous field if was too large
				e.Graphics.FillRectangle(normalBack, currentOffset, rec.Y, fixedAlignColumnSize, extent.Height);
				//draw text as is 
				e.Graphics.DrawString(value, e.Font, NormalText, textRec);
			}
			//advance the offset to the next position
			currentOffset += fixedAlignColumnSize;
		}
	}
	else
	{
		//if happens when the combo is closed, draw single standard item view
		e.Graphics.DrawString(currentText, e.Font, NormalText, rec);
	}


}

GeneralDropdown comobox cell in datagridview v2005 Pin
Samik_ Ray2-Apr-09 20:51
Samik_ Ray2-Apr-09 20:51 
GeneralRe: Dropdown comobox cell in datagridview v2005 Pin
IssaharNoam4-Apr-09 19:58
IssaharNoam4-Apr-09 19:58 
QuestionHow to add headers to combobox columns? Pin
mjbasecamp5-Mar-09 9:13
mjbasecamp5-Mar-09 9:13 
AnswerRe: How to add headers to combobox columns? Pin
IssaharNoam5-Mar-09 10:12
IssaharNoam5-Mar-09 10:12 
GeneralDear Issahar: Pin
arevans24-Nov-08 9:10
arevans24-Nov-08 9:10 
GeneralRe: Dear Issahar: Pin
IssaharNoam25-Dec-08 5:56
IssaharNoam25-Dec-08 5:56 
QuestionHow to display in the comboxbox all the items Pin
dsapo8-Aug-08 4:35
dsapo8-Aug-08 4:35 
AnswerRe: How to display in the comboxbox all the items Pin
IssaharNoam25-Dec-08 5:58
IssaharNoam25-Dec-08 5:58 
QuestionAnyone have some more solid code? Pin
Member 359872110-Jun-08 8:12
Member 359872110-Jun-08 8:12 
AnswerRe: Anyone have some more solid code? Pin
IssaharNoam10-Jun-08 10:20
IssaharNoam10-Jun-08 10:20 
AnswerRe: Anyone have some more solid code? Pin
IssaharNoam25-Dec-08 6:00
IssaharNoam25-Dec-08 6:00 
QuestionMultiline combobox Pin
kaandemirtas3-Feb-08 7:43
kaandemirtas3-Feb-08 7:43 
AnswerRe: Multiline combobox Pin
IssaharNoam25-Dec-08 6:00
IssaharNoam25-Dec-08 6:00 
QuestionQuestion from the article Multi Column Combo Cell C#, hoping for author to help! Pin
quakertistar1-Oct-07 3:17
quakertistar1-Oct-07 3:17 
AnswerRe: Question from the article Multi Column Combo Cell C#, hoping for author to help! Pin
IssaharNoam7-Oct-07 5:26
IssaharNoam7-Oct-07 5:26 
GeneralRe: Question from the article Multi Column Combo Cell C#, hoping for author to help! Pin
quakertistar8-Oct-07 4:49
quakertistar8-Oct-07 4:49 
GeneralDrop Down Arrow Pin
Barry T7-Sep-07 7:18
Barry T7-Sep-07 7:18 

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.