How to show databound drop down list in a column of DGV?

Mayank Jani

Hello,

Greetings of the day...

I am working on a windows application in C#.

I have a ComboBox (CB) and a DataGridView (DGV). When I select any value from the CB, it adds in the DGV. the row addition in the DGV is done programatically. the DGV contains some more columns and I want to add something like a drop down list or combobox with some data that comes from a data table and I choose the value from it for the cell or column.

e.g. the DGV contains columns like Product, Colour, Size etc. When I select a product from the CB, like Shoes, it added into the DGV. Now, there are two more columns i.e. Colour and Size. so, when I click or press enter on the cell, a drop down list or combobox should be open with options like, Red, Black, Green for Colour and 7, 8, 9 for Size. the colour and size comes from a data table.

How to achieve these two goals?

Thanks a lot.

Mayank Jani.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayank Jani8y ago
Hii Munish,
Thanks for reply...
No , it's not working. but I have attached an application with database. please run the same and and make necessary changes to it and send back.
as you will see that there are three data tables i.e. MainProduct , ProductColors and ProductSize. the values from the first table will be seen in the ComboBox, when you select any product from the ComboBox and press enter, It'll appear in the first column of the DataGridView and other two columns will remain blank. Now, I want write code that when I click on any cell of 2nd column, a drop down/combo box should appear with list of colors from ProductColors table. I can select any color with click or enter and the selected color should be set in the cell. after that I want to save the entire row.
Please check it at your end and suggest me what to do...

Thanks for your patience. :)
0
Munish Kumar8y ago
Hi Mayank,

what i have understand from the screen shot you have attached is you want a column which behaves like a textbox initially and if want to edit its value then it should behave like dropdown. Is it correct? If yes, then you can change the display style of your DGV's combobox to "Nothing".
DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn();
cb.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
cb.DataSource = dt;
cb.DisplayMember = "Name";
cb.DataPropertyName = "Name";
0
Mayank Jani8y ago
Hii Munish,
Thanks for your reply.
Please note that in my gridview, there is already a column for the combobox (e.g. colour here) and I want a list that should come from data table.

Hii Suraj,
Thanks for your reply too.
the first link will not work for me as I want the data from data table in db
the second link I have been visited before I posted my problem here, the code is out of my understanding ability.

Please see the screen shot attached, It's an example. I have described my points in it.
Kindly let me know If you want any screen shot or some code.

Thanks

Mayank Jani
0
Munish Kumar8y ago
Hi Mayank, hope this would help..
DataTable dt = new DataTable();
dt.Columns.Add("Name");

dt.Rows.Add(new Object[] { "A" });
dt.Rows.Add(new Object[] { "B" });
dt.Rows.Add(new Object[] { "C" });
dt.Rows.Add(new Object[] { "D" });
dt.Rows.Add(new Object[] { "E" });

dataGridView1.AutoGenerateColumns = false;

DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn();
cb.DataSource = dt;
cb.DisplayMember = "Name";
cb.DataPropertyName = "Name";

dataGridView1.Columns.Add(cb);
0
Suraj Kumar8y ago
Hello Mayank,
Check with these url
https://www.c-sharpcorner.com/blogs/steps-to-add-combobox-inside-datagridview-window-form

https://www.encodedna.com/2013/02/show-combobox-datagridview.htm
0