DataGridViewComboBoxColumn With Dynamic DataSource

Question

0.00/5 (No votes)

See more:

Hi,

I have editable DataGridView to fill ordered Products, so i have a DataGridViewComboBoxColumn with DataTable datasource that contain all products codes, i change the rowFilter of the dataview depending on values of the column. for exmple:

datagridview is empty
Combo product codes are :
11
1212
1555

the user added row and choosed from the combobox code "1212" .
when the user added anther row i filter the combo dataView to exclude the code "1212" so the combo will have :
Combo product codes are :
11
1555

I do this filtering In EditingControlShowing event of the datagridview.

My problem is that the dataGridView uses the same comboBox Instace for the whole column so after i filter its source the cell text of the first row change to empty string cause the combo in the second row doesn't have the value that was choosen in the first row.

Is there any work around?

Thanks a lot!

Posted 11-Mar-14 18:24pm

Zan Zan Koe

Updated 12-Mar-14 17:46pm

v2

Add a Solution

Comments

george4986 13-Mar-14 0:46am

why dont u use an auto text instead of combo box?

1 solution

Add a Solution

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

jacobjohn196 · Answer 1 · 2014-03-13T19:42:00

In Dropdown selection index changed event, remove the selected item from the dropdown.
It would be something like this,

Copy Code

GridViewRow grdrow = ((DropDownList)sender).Parent.Parent as GridViewRow;
               DropDownList ddlProducts = (DropDownList)grd.Rows[grdrow.RowIndex].FindControl("YourDrpDown");
               ddlProducts.Items.Remove(ddlProducts.SelectedItem);

DataGridViewComboBoxColumn With Dynamic DataSource

1 solution

Solution 1

Add your solution here

Preview 0

DataGridViewComboBoxColumn With Dynamic DataSource

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us