Access invisible columns in a Datagridview (WinForms)

Question

I'm showing some data in a DataGridView using a list which I get from the Entity Framework. In this grid I set some database columns like the id to invisible.

When the user clicks on the gridview I need to know which object was clicked for further steps, the problem I cannot get the id column, neither through:

datagridview1.CurrentRow.Cells[0].Value // here I get only visible cells

nor through:

datagridview1.CurrentRow.DataBoundItem 

It seems that through setting some columns to invisible the objects attached have anonymous types

Any ideas?

Thank you

Answer 1

I just tried this:

private void dataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    var value = dataGridView.Rows[e.RowIndex].Cells[0].Value;
}

and it worked.

In my example column 0 is the hidden column, that contains the id property that you want to extract.

Answer 2

For me it works to take the columnName not the index.

so if your column has the name "id" you could use:

datagridview1.CurrentRow.Cells["id"].Value