Not able to hide first column in datagridview?

Question

I have a datagridview in a windows form which contains some columns. And I want to hide the Ist column(CompanyID) through the code behind.

But Ist column is not hiding.

Have tried below 2 things :

dgvVendorDetails.Columns["CompanyID"].Visible = false;

And:

dgvVendorDetails.Columns[0].Visible = false;

I don't know the reason behind this. I have searched a lot but got no solution.

This might help http://stackoverflow.com/questions/3819247/gridview-hide-column-by-code — Nithin Nayagam, Sep 13 '13 at 16:31
The post code obviously works. You will have to supply more details in order to get to the root of the problem. — LarsTech, Sep 13 '13 at 16:32
Try changing your column dgvVendorDetails from the first column to the last column. — Rahul Tripathi, Sep 13 '13 at 16:34
In what method have you added the statements to set it to false? — dotNetE, Sep 13 '13 at 16:37
Where is the code placed? Are you sure the code is executed? Or there is 1 column other than the first one being hidden? — King King, Sep 13 '13 at 16:46

score 5 · Accepted Answer · edited May 23 '17 at 11:50

Both of these syntax are corrects and should work:

dgvVendorDetails.Columns["CompanyID"].Visible = false;
dgvVendorDetails.Columns[0].Visible = false;

My guess is that you are using the DataGridView.AutoGenerateColumns functionnality and even if you set the DataSource property, the DatagridView won't create columns until the grid is displayed.

So it's possible that:

you try to access columns that do not exist yet (but the code should raise an exception)
or you access valid columns, but they are replaced when the grid is bound again and so your code has no effect (probably your case since you do not mention an exception).

If so, the solution is to use the DataBindingComplete Event.

See also these related issues:

EDIT

As @brikovich pointed out, another solution is not not use the AutoGenerated columns but create them and configure them at design time or at runtime.

This thread How to select visible columns in Datagridview bound to DataTable can help you to achieve this and/or make a choice between these two options.

score 0 · Answer 2 · answered Sep 13 '13 at 19:21

0

Set autogenerate columns to false and then add each column one by one to the grid. Then set the column you don't want to see to visible = false. No need for code behind.

answered Sep 13 '13 at 19:21

briskovich

670
1
11
26

score 0 · Answer 3 · answered Dec 12 '13 at 08:51

Try this:

VB.net:

    Private Sub dgvVendorDetails_ColumnAdded(sender As Object, e As DataGridViewColumnEventArgs) Handles dgvVendorDetails.ColumnAdded
        If e.Column.Name = "CompanyID" Then dgvVendorDetails.Columns("CompanyID").Visible = False
    End Sub

C#:

private void dgvVendorDetails_ColumnAdded(object sender, DataGridViewColumnEventArgs e)
{
    if (e.Column.Name == "CompanyID")
        dgvVendorDetails.Columns("CompanyID").Visible = false;
}

Not able to hide first column in datagridview?

3 Answers3