DataGridViewComboBox: populate with different data for each row in detail grid based on another column's value in the same row

Question

0.00/5 (No votes)

See more:

Hi. I have a pair of Master-Detail DataGridViews in my WinForms App.
One of the columns in my DETAIL grid is a ComboBox (part_name).

ComboBox values are not the same for all rows. They differ based on the value of another column (equipment_name) in the same row of the DETAIL grid.
example:

row1: equipment_name: PC part_name: RAM , Hard disc , CPU
row2: equipment_name: printer part_name: paper tray , Inkwell

How can i populate each ComboBox with correct values in each DETAIL row when detail rows are either filled from database or added by user? maybe using a database query? how to pass(equipment_name) as a parameter? and where to do that? in what event handler?

P.S. :
1- master and detail grids are used for displaying, adding , editing and deleting rows.
2- in this page you can find my code of creating grids. it doesn't include code for ComboBox column yet. the correct code is marked as an ANSWER.

www.codeproject.com/Questions/817587/Master-detail-datagridview-how-to-insert-master-re?arn=0&loginkey=false[^]

thanks in advance

Posted 13-Oct-14 0:09am

nina4ever

Updated 13-Oct-14 1:02am

v6

Add a Solution

1 solution

Add a Solution

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)

Sinisa Hajnal · Answer 1 · 2014-10-13T00:53:00

Solution 1

Use CellFormatting event to check for equipment name and based on that set datasource for the combobox column.

You can also use DataBindingComplete, but you have to then iterate through whole grid and re-bind your combobox values which is less than ideal.

In CellFormatting, check cell index or cellcolumn name, if it is your equipment name, bind your datasource to combobox column

Posted 13-Oct-14 0:53am

Sinisa Hajnal

Updated 13-Oct-14 1:20am

v2

Comments

nina4ever 13-Oct-14 7:01am

thanks, but it's a Windows Forms Application. there is no such event

Sinisa Hajnal 13-Oct-14 7:18am

Stupid of me. Sorry. Solution updated.

nina4ever 13-Oct-14 7:33am

thank you again. i will try your solution and feedback.

nina4ever 13-Oct-14 7:47am

"CellFormatting event occurs every time each cell is painted". is it practical to query database for combo values each time this handler executed !!!?

Sinisa Hajnal 13-Oct-14 7:57am

It's not. It is up to you to limit it to specific cell (that is, use cell index or cell column to check that it is equipment part cell and THEN and ONLY THEN query the database :)

You can also improve performance by getting both combobox datasources on form load and then only assigning them to comboboxes...just take care to copy the source instead of assigning directly (datatable.Copy is enough assuming you have DataTable as combo source)