Question Adding data to a DataGridViewComboBoxColumn defined at design time

[tim8w]

Hi,
I have a DataGridView where I have designed in the designer at design time. One of my columns is defined as a DataGridViewComboBoxColumn . At run time, I m trying to fill this ComboBox and not having much luck. Below is my latest attempt at doing so, but when I run the code, the ComboBox is still empty.

       private void frmReporting_Load(object sender, EventArgs e)
        {
            dt = Populate("SELECT DISTINCT OperatorName FROM tblOperator WHERE  Active='1' ORDER BY OperatorName");
            dgvCmbCell = (DataGridViewComboBoxCell)dgvReports[1, 0];
            FillComboBox();
        }

        private DataTable Populate(string sqlCommand)
        {
            myConnection.Open();

            SqlCommand command = new SqlCommand(sqlCommand, myConnection);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = command;

            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);

            myConnection.Close();
            return table;
        }

        private void FillComboBox()
        {
            SqlDataAdapter da = new SqlDataAdapter();
            DataSet ds = new DataSet();

            ArrayList row = new ArrayList();

            foreach (DataRow dr in dt.Rows)
            {
                row.Add(dr[0].ToString());
            }
            dgvCmbCell.Items.Clear();
            dgvCmbCell.DataSource = null;
            dgvCmbCell.Items.AddRange(row.ToArray());
        }

 

[Skydiver]

I have only added items to the column, not to the cell. See the sample code in the documentation which adds the items to the column:

DataGridViewComboBoxColumn Class (System.Windows.Forms)

Represents a column of DataGridViewComboBoxCell objects.

docs.microsoft.com

 

[tim8w]

I have only added items to the column, not to the cell. See the sample code in the documentation which adds the items to the column:

DataGridViewComboBoxColumn Class (System.Windows.Forms)

Represents a column of DataGridViewComboBoxCell objects.

docs.microsoft.com

Looked at this one already. This one creates a new column on the end and doesn't address an existing column. Maybe there is no way to do it once you have created the DataGridViewComboBox in the designer. I guess I might have to break down and create the DataGridView by hand instead of using the designer...

 

[Skydiver]

The same way you found the cell and got a reference, you can also find the column a similar way and get a reference.

I suspect that the designer also allows you to get a variable declared that already references the column, but I'm not sure since I hand code my forms.

 

[tim8w]

Skydiver,
I'm embarrased. Code was fine. I had the DataGridView set to ReadOnly. You can delete this thread. I tried, but I don't think I can.