DataGridView's Column name not found

Question

Why do I get the exception that Column Name is not found for MyEntity as well as FullName Columns? Although I see the column names being displayed in UI.

InitializeComponent();

dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
    int rowIndex = dataGridView1.Rows.IndexOf(row);
    myObject = dataGridView1.Rows[rowIndex].Cells["MyEntity"].Value as IEntityObject;
    fileName = dataGridView1.Rows[rowIndex].Cells["FullName"].Value.ToString();       
}

Do you see the column name or the column header displayed in the UI — Steven Wood, Feb 20 '14 at 16:24
yes, I do see MyEntity string displayed in the column header — user1298925, Feb 20 '14 at 16:32
See @h4xpace's answer - I believe you are using the header text and not the column name to refer to the column — Steven Wood, Feb 20 '14 at 16:34

score 15 · Accepted Answer · answered Feb 20 '14 at 16:31

15

Because, infuriatingly enough, that datagridview column is not actually named the same as your DataTable column name. If you look at the column collection in the designer Properties window, you will see that is probably named something like "DataGridViewColumn4" or similar.

If you know the index, you should use that, or rename the columns to the DT column names.

answered Feb 20 '14 at 16:31

Serialize

491
5
13

Thank you so much. You saved the day. Great answer. – user1298925 Feb 20 '14 at 16:38
Incase it is not completely obvious, programmatically adding a checkbox with the name set should look like below: `code`DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn(); col.Width = 90; col.HeaderText = "Sync To Vend?"; col.Name = "Sync To Vend?"; ProductGrid.Columns.Insert(2, col); `code` – Pearce Dec 14 '16 at 13:56

score 1 · Answer 2 · answered Dec 14 '16 at 14:00

Incase it is not completely obvious, programmatically adding a checkbox to your datagridview with the name set should look like below:

        DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn();
        col.Width = 90;
        col.HeaderText = "Sync To Vend?"; //Header cell text
        col.Name = "SyncVendBox"; //This is the important part
        ProductGrid.Columns.Insert(2, col);

And if you want the checkbox ticked:

        for (int i = 0; i < ProductGrid.Rows.Count; i++)
        {
            ProductGrid.Rows[i].Cells["SyncVendBox"].Value = true;
        }

DataGridView's Column name not found

2 Answers2