How to bind ComboBox to a datagridview in a windows form application

Question

0.00/5 (No votes)

See more:

I Have to bind a comboBox to a datagridview in a windows form application. i have used the below code.

C#

DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();

cmb.HeaderText = "Installation";
cmb.Name = "cmb";
cmb.MaxDropDownItems = 3;
cmb.Items.Add("--SELECT--");
cmb.Items.Add("Pre-Installation");
cmb.Items.Add("Installation");
cmb.Items.Add("Post-Installation");

By using the this code comboBox is binded in gridview, But it is displaying on the topside of the column, I need to display the comboBox to the center of the column and
--Select-- should display by default.

For displaying comboBox to center i have used this

C#

cmb.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

Still its not working

Please Help.

Thanks in advance

Posted 1-Feb-15 20:25pm

Renjith_R

Updated 1-Feb-15 23:30pm

v6

Add a Solution

Comments

Sinisa Hajnal 2-Feb-15 5:56am

Easy, this is not online real-time service.

Lets clarify the question: what is displayed when the grid is filled? You say --Select-- should be, if it is not, what is? Second, what do you mean it is displayed topside of the column? Is it row height greater then the combobox?

Try setting properties on cmb.ComboBox (this accesses internal control of the cell).

CHill60 2-Feb-15 7:32am

Do you want this centred within the DGV but aligned with one column OR do you want the comboBox to be associated with a single cell (dynamically).
To get "--Select--" to display by default use cmb.SelectedIndex=0

Renjith_R 2-Feb-15 7:47am

Thanks for reply,
in DGV DataGridViewComboBoxColumn does not contain a definition cmb.SelectedIndex=0

CHill60 2-Feb-15 8:09am

Apologies - that only works with an actual combobox - however - are you actually trying to programmatically put a comboBox into a cell of the DGV?

Renjith_R 2-Feb-15 8:14am

Yes,I am programmatically put comboBox in DGV,

DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();

cmb.HeaderText = "Installation";
cmb.Name = "cmb";
cmb.MaxDropDownItems = 3;
cmb.Items.Add("Pre-Installation");
cmb.Items.Add("Installation");
cmb.Items.Add("Post-Installation");
I need to display --Select-- as the default value .

Thanks in advance

CHill60 2-Feb-15 8:23am

You've already said all of that. At the moment you have created a DataGridViewComboBoxColumn - once you have added it to the DGV you can access and set the Cell Value (i.e. set it to "--Select--") for all/any of the rows OR bind the column to a datatable and that should take care of it for you

Renjith_R 2-Feb-15 10:32am

i have tried this

DataTable dt = new DataTable();

dt.Columns.Add("Installation", System.Type.GetType("System.String"));
dt.Columns.Add("InstallationValue", System.Type.GetType("System.Int32"));

dt.Rows.Add("--Select--","0");
dt.Rows.Add("Pre-Installation","1");
dt.Rows.Add("Installation","2");
dt.Rows.Add("Post-Installation","3");
cmb.DataSource = dt;
cmb.DisplayMember = "Installation";
cmb.ValueMember = "InstallationValue";

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells[4].Value = "0";

}

Its showing error like Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

CHill60 2-Feb-15 11:34am

So your dataGridView1 has at least 5 columns?

Renjith_R 3-Feb-15 2:23am

Yes,DGV has 5 columns

CHill60 3-Feb-15 5:06am

I've just spotted the quotes around the 0 - you need to change that line to dataGridView1.Rows[i].Cells[4].Value = "--Select--" I believe

Renjith_R 3-Feb-15 5:57am

I have tried this as well, getting the same error "Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"

CHill60 3-Feb-15 5:59am

And the error occurs on that line? It would imply that there are less than 5 columns on your DGV at that point in time - what happens if you change that [4] to [3]?

Renjith_R 3-Feb-15 6:05am

Thanks for the quick reply, I have tried that aswell, 3 is a checkbox column. comboBox is in 4 only.

CHill60 3-Feb-15 6:10am

The fourth column has an index of [3] - Columns is a zero-based collection i.e.
Columns[0] -> first column,
Columns[1] -> second column,
etc

Renjith_R 3-Feb-15 6:11am

Sorry, ComboBox is 4 th only.

CHill60 3-Feb-15 6:20am

4th column is Columns[3] so you will need to use Cells[3] in the code above, not [4]

Renjith_R 3-Feb-15 6:23am

dataGridView1.Rows[i].Cells[4].Value
is the comboBox column.

CHill60 3-Feb-15 6:50am

That is the 5th column - you said it was in the 4th

Renjith_R 9-Feb-15 3:19am

dataGridView1.Rows[i].Cells[4].Value
This is the cell value, but its not working :(
i have tried with different methods. but nothing helps me

CHill60 9-Feb-15 4:36am

So your combo box is in the FIFTH column not the fourth as you said earlier?

Renjith_R 9-Feb-15 4:46am

Yes,its in the fifth column.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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