Populate datagridview column combobox datasource

Question

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.

Stephen Anderson · Answer

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 Anderson · Answer

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 Anderson · Answer

I am a little confused as to what to use for .DisplayMember and .ValueMember here.

Vinod Kakade · Answer

DataGridViewComboBoxColumn colUserTypeId = (DataGridViewComboBoxColumn)DataGridView1.Columns["UserTypeId"]; colUserTypeId.DisplayMember = "UserTypeName"; colUserTypeId.ValueMember = "UserTypeId"; colUserTypeId.DataSource = Dt;