Populate datagridview column combobox datasource

Stephen Anderson

Hello:

I would like the correct C# syntax to populate datagridview column comboboxes. Each column will look at a query (Entity Framework 6), converted to a list, and would make those values the correct ones to choose from. There should also be a blank for a default.

Currently, I have this code.

DataTable dt_Employee = timeDataSet.Tables["Employee"];
DataTable dt_TimeData = timeDataSet.Tables["TimeData"];
DataTable dt_Activity = timeDataSet.Tables["Activity"];
DataTable dt_Jobs = timeDataSet.Tables["Jobs"];
var qryProjectNumbers = from a in dt_Jobs.AsEnumerable()
orderby a.Field("ProjectNumber")
where (a.Field("ProjectNumber") != null)
select a.Field("ProjectNumber");
var lstProjectNumbers = qryProjectNumbers.Distinct().ToList();
var qryActivity = from a in dt_Jobs.AsEnumerable()
orderby a.Field("Activity")
where (a.Field("Activity") != null)
select a.Field("Activity");
var lstActivity = qryActivity.Distinct().ToList();
// How do I add combobox columns?
dgvTime.Controls.OfType().ElementAt(iProjectNo).DataSource = lstProjectNumbers;
dgvTime.Controls.OfType().ElementAt(iActivity).DataSource = lstActivity;
this.timeDataTableAdapter1.Fill(this.timeDataSet.TimeData);

Thank you.

4 Replies

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

Stephen Anderson8y ago
To reply to my own post, this does not work either:

DataGridViewComboBoxCell dgvcolcboProjectNumber = (DataGridViewComboBoxCell)dgvTime.Rows[0].Cells[6];
dgvcolcboProjectNumber.DataSource = lstProjectNumbers;
dgvcolcboProjectNumber.DisplayMember = "ProjectNumber";

So to try and specify an exact x,y grid location tells me that the field name "ProjectNumber" does not exist. I think it does!

In the other example, trying to refer to the full column also fails, the 'Columns' syntax has a red underline.

The field name is "ProjectNumber" everywhere! In the database, dataset, etc.
Stephen Anderson8y ago
So put simply, I gave a datagridview with 9 columns defined. If I look at its properties, I have columns 7 and 8 (6 and 7 if starting at 0) set to be comboboxes.

Column 6 therefore needs to have the datasource set to ProjectNumber from another table, which exists in the dataset.

The name of column 6 is projectNumberDataGridViewComboBoxColumn

Syntactically, how would I set the datasource for those comboboxes?

I currently have:
DataGridViewComboBoxColumn dgvcolcboProjectNumber = (DataGridViewComboBoxColumn)dgvTime.Columns("projectNumberDataGridViewComboBoxColumn")

The line above produces an error or Non-invocable member "DataGridView.Columns" cannot be used like a method.

dgvcolcboProjectNumber.DisplayMember = "ProjectNumber"
dgvcolcboProjectNumber,ValueMember = "ProjectNumber"
dgvcolcboProjectNumber.DataSource = lstProjectNumbers

DisplayMember and ValueMember, not sure what they do. The actual column is called "ProjectNumber" in the datagridview

Prior to implementing the code above, I have a query:

DataTable dt_Jobs = timeDataSet.Tables["Jobs"];
var qryProjectNumbers = from a in dt_Jobs.AsEnumerable
orderby a.Field("ProjectNumber")
where (a.Field("ProjectNumber") != null
select a.Field("ProjectNumber");

var lstProjectNumbers = qryProjectNumbers.Distinct().ToList();

I am just not getting a data source for the combo boxes. I am missing something from the prior question, or did not communicate well.

Insights appreciated.

Thanks!
Stephen Anderson8y ago
I am a little confused as to what to use for .DisplayMember and .ValueMember here.
Vinod Kakade8y ago
DataGridViewComboBoxColumn colUserTypeId = (DataGridViewComboBoxColumn)DataGridView1.Columns["UserTypeId"];
colUserTypeId.DisplayMember = "UserTypeName";
colUserTypeId.ValueMember = "UserTypeId";
colUserTypeId.DataSource = Dt;