Click here to Skip to main content
13,343,221 members (58,839 online)
Click here to Skip to main content
Add your own
alternative version

Stats

390.3K views
1.8K downloads
75 bookmarked
Posted 25 Dec 2002

A ComboBox in a DataGrid

, 25 Dec 2002
Rate this:
Please Sign up or sign in to vote.
Descendant from DataGridColumnStyle.

Introduction

This is a descendant from DataGridColumnStyle and is used to have a ComboBox in a DataGrid column. It is based on an article by Sudhakar Jalli but I found the code not working. I repaired the code and cleaned it up a little.

The DataGridComboBoxColumn class makes it possible to have a ComboBox instead of the default text or checkbox. It took me quite a while to figure it out (even with the help of the article by Sudhakar Jalli). Using it is straightforward.

Using the code

First create a new DataGridTableStyle and make sure the mapping is set to the name of the table in the DataSource where the columns will belong to.

DataGridTableStyle ts=new DataGridTableStyle();
ts.MappingName="Columns";

Then, create the DataTable with the lookup values. This could of course come from the database (And it should BTW)

DataTable AccessDataTypes = new DataTable();
AccessDataTypes.Columns.Add(new DataColumn("Number", typeof(int)));
AccessDataTypes.Columns.Add(new DataColumn("Name", typeof(string)));
AccessDataTypes.Rows.Add(new object[] {3, "Numeric"});
AccessDataTypes.Rows.Add(new object[] {130, "Text"});

Create the DataGridComboBoxColumn and add it to the GridColumnStyles. The first argument (Type) is used for the column caption and the mapping. (Could be changed after creating). The second argument (AccessDataTypes) is the DataTable to use for translation. Name and Number are the column names to use from the table and theGrid is the DataGrid where this column will belong to. Be sure to provide the NullText ; if you don't it will throw an exception if you try to add a row to the DataGrid.

DataGridComboBoxColumn c1=new DataGridComboBoxColumn("Type", 
         AccessDataTypes, "Name", "Number", theGrid);
c1.NullText="3";
ts.GridColumnStyles.Add(c1);

Finally add the newly created TableStyle to the TableStyles array of the DataGrid.

theGrid.TableStyles.Add(ts);

Enjoy the improved DataGrid and be sure to send in your own DataGrid columns!

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

Jan Wiggers
Web Developer
Netherlands Netherlands
No Biography provided

You may also be interested in...

Comments and Discussions

 
QuestionDataGridComboBox offsets when inserting a new record? Pin
bcox24-Nov-03 8:02
memberbcox24-Nov-03 8:02 
QuestionReadOnly property? Pin
B the ComboBoxColumn5-Nov-03 10:06
sussB the ComboBoxColumn5-Nov-03 10:06 
GeneralFormatException raised... Pin
leplayb5-Sep-03 1:21
memberleplayb5-Sep-03 1:21 
GeneralRe: FormatException raised... Pin
JoeGunchy11-Sep-03 13:05
memberJoeGunchy11-Sep-03 13:05 
GeneralRe: FormatException raised... Pin
Andrew Bolonniy12-Sep-03 8:53
memberAndrew Bolonniy12-Sep-03 8:53 
GeneralRe: FormatException raised... Pin
JoeGunchy16-Sep-03 15:27
memberJoeGunchy16-Sep-03 15:27 
GeneralRe: FormatException raised... Pin
bart_dv7-Jul-04 1:42
memberbart_dv7-Jul-04 1:42 
GeneralEditable ComboBox Pin
JoeGunchy26-Aug-03 11:32
memberJoeGunchy26-Aug-03 11:32 
GeneralRe: Editable ComboBox Pin
JoeGunchy11-Sep-03 13:23
memberJoeGunchy11-Sep-03 13:23 
GeneralRe: Editable ComboBox Pin
robgale2-May-04 19:17
memberrobgale2-May-04 19:17 
GeneralDatagrid Cell Formatting Pin
meatcp6-Aug-03 21:25
membermeatcp6-Aug-03 21:25 
GeneralNullText property Pin
DancnDude9-Jul-03 7:40
memberDancnDude9-Jul-03 7:40 
GeneralRe: NullText property Pin
Chris Wuestefeld23-Nov-03 14:52
sussChris Wuestefeld23-Nov-03 14:52 
Generalkeybord access Pin
wengerp27-May-03 11:04
memberwengerp27-May-03 11:04 
GeneralRe: keybord access Pin
Roger Willcocks16-Sep-03 16:11
memberRoger Willcocks16-Sep-03 16:11 
Generalsetting the alternating background coloe Pin
merojo8-May-03 13:15
sussmerojo8-May-03 13:15 
GeneralTo the author!!! Pin
chrischan31-Mar-03 18:57
memberchrischan31-Mar-03 18:57 
GeneralRe: To the author!!! Pin
torok9-Apr-03 14:36
membertorok9-Apr-03 14:36 
GeneralRe: To the author!!! Pin
bill_cs3-Aug-07 5:37
memberbill_cs3-Aug-07 5:37 
GeneralRestricted to list Pin
torok20-Mar-03 9:55
membertorok20-Mar-03 9:55 
GeneralConverting to Visual Basic.Net Pin
John Thayer17-Mar-03 7:13
memberJohn Thayer17-Mar-03 7:13 
GeneralRe: Converting to Visual Basic.Net Pin
Jan Wiggers17-Mar-03 20:15
memberJan Wiggers17-Mar-03 20:15 
GeneralRe: Converting to Visual Basic.Net Pin
John Thayer18-Mar-03 5:40
memberJohn Thayer18-Mar-03 5:40 
GeneralRe: Converting to Visual Basic.Net Pin
sracer620-Jan-06 14:14
membersracer620-Jan-06 14:14 
GeneralDataGridColumnStyle is abstract Pin
JBs10-Jan-03 3:29
sussJBs10-Jan-03 3:29 

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.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.180111.1 | Last Updated 26 Dec 2002
Article Copyright 2002 by Jan Wiggers
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid