DataGridView from 2 tables; One combobox column

Hi,

I'm having a situation like this.

I am using a datagridview which fills up Item details from a table, say Items.

I am also adding a Datagridcomboboxcolumn to this datagrid whose datasource is table 'Category' from where it should show various category names in combo box for user to select one.

I can see the datagridview being filled up with data from Items table.I can also see the combo box column being generated for each row.However, the combobox doesnot work and show any values from its datasource.

How can I show rows from one table and combo box in each row from other table in a datagridviw ?

here is the pseudocode :

DataTable dt = objItems.GetItems(); // gives Item details in a table.

DataTable dtCat = objCat.GetCategory(); // returns category details in form of a table.

dgItems.DataSource = dt; // dgItems is a datagridview created with the help of toolbox on a winform.

DataGridViewComboBoxColumn comboColumn = new DataGridViewComboBoxColumn();

comboColumn.DataPropertyName = "CategoryDesc";

comboColumn.HeaderText = "Select Category";

comboColumn.MaxDropDownItems = 5;

comboColumn.DataSource = dtCat;

comboColumn.ValueMember = "CategoryId";

comboColumn.DisplayMember = "CategoryDesc";

dgItems.Columns.Insert(dt.Coulmns.Count + 1, comboColumn);

Thanks in advance.

Nikita

1 Reply

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

li yufeng20y ago

hi!
I have a try about your code,but at "dgItems.Columns.Insert(dt.Coulmns.Count + 1, comboColumn);" ,an exception occured,Array index overflow,because array index is form one,so i think "dgItems.Columns.Insert(dt.Coulmns.Count , comboColumn);" is right,and on my computer ,the combobox also shows values from its datasource.
0