Remove Column from DataGridView

Question

I have a database that has a Users table and I present the data in a DataGridView. I would like to remove 4 columns, but the code I have (referenced from MSDN) seems to append the columns at the end. How can I totally REMOVE the columns?

So this is how the DGV looks without the columns removed

The Code I use to TRY and remove the columns

RadarServerEntities rse = new RadarServerEntities();
gvUsers.DataSource = rse.Users;

gvUsers.Columns.Remove("ID");
gvUsers.Columns.Remove("InsertDate");
gvUsers.Columns.Remove("Connections");
gvUsers.Columns.Remove("MachineID");

The result

I would like to get rid of the last 4 columns, so why isnt my code doing it?

Many Thanks :)

Answer 1

I tend to just hide the fields instead.

gvUsers.Columns["ID"].Visibility = false;

Et cetera.

Answer 2

To actually remove automatically generated column you have to turn off automatic generation after data binding.

So the code would be:

RadarServerEntities rse = new RadarServerEntities();
gvUsers.DataSource = rse.Users;
gvUsers.AutoGenerateColumns = false;
gvUsers.Columns.Remove("ID");
gvUsers.Columns.Remove("InsertDate");
gvUsers.Columns.Remove("Connections");
gvUsers.Columns.Remove("MachineID");

I haven't checked what exactly happens, but probably the moment DGV becomes visible, missing columns are re-autogenerated.

So with this solution you have columns generated at the moment of binding data, then you turn it off and remove columns that you don't need. Missing columns can't be re-generated.