Datagridview with Comboboxcolumn using Entity Framework 4 C# in Windows Forms

Question

I'm trying to populate a datagridview with Combobox column using the Northwind EF classes Orders and Customers. I used the following code to fill the unbound DataGridViewcomboColumn with customers names, to make possible the quick change of customer name while orders are displayed in the datagridview.

NorthwindEntities nw;
private void Form1_Load(object sender, EventArgs e)
{
nw = new NorthwindEntities();
ordersBindingSource.DataSource = nw.Orders;

DataGridViewComboBoxColumn CustomerName = new DataGridViewComboBoxColumn()
{
HeaderText="Name",
DataPropertyName = "CustomerID",
DataSource = nw.Customers.Execute(MergeOption.AppendOnly),
ValueMember = "CustomerID",
DisplayMember = "CompanyName"
};
}

With the above code the combocolumn stay empty when orders are displayed in the datagrid. Have I made any mistake, please help …

Vulpes · Answer

I think Ehtesham is asking whether you've remembered to add the ComboBox column to the DataGridView? Something like: dataGridView1.Columns.Add(CustomerName);

Vulpes · Answer

Regarding the first question instead of Add use the Insert method. For example to insert at the second column position you can use: datagridview1.Columns.Insert(1 CustomerName); Regarding the second question you'd have to add a text column to start with and then when the column was clicked remove it from the Columns collection (using the Remove or RemoveAt methods) and insert the ComboBox column in its place.

Ehtesham · Answer

Its strange! were your adding that DataGridViewComboBoxColumn instance to datagridview to populate the result which is intended?

Samio · Answer

Thanks so much Vulpes and Ehtesham ... you saved me Guys.

Samio · Answer

Ehtesham and you Vulpes are right Now after having added: datagridview1.Columns.Add(CustomerName); it's working. Also I wonder how to insert the added ComboColumn at a given position between the other columns of the datagridview and if is there a way to display the combo column as a text column until we click on it ?

Samio · Answer

Ehtesham sorry could not understand your question

Datagridview with Comboboxcolumn using Entity Framework 4, C# in Windows Forms