[2005] Datagridview column visibility

[UsefulIdiot]

Hello,

I have a problem with a datagridview. In the datagrid view I have the primary key and foriegn key values that are inserted into it when the rowsadded event is fired. This works great except for the fact that I do not want my users to see the pk/fk values, and would like to not show them at all. If I set the visibility property to false, the values are not set, and throws an exception when they try and save.

I tried looking into the mappingtype property but have been unable to solve the problem.

How can I hide the columns but still have their values correctly stored?


Thanks,
Chris

[techgnome]

YourDataGridView.Columns(your_col_index).Visible = True / False as needed.

-tg

[NLISI]

I also have found that this works:

'Hide the column and attach dataset's DefaultView to the datagrid control 
DSBinData.Tables(0).Columns(7).ColumnMapping = MappingType.Hidden

Where '0' is the index of which table you are using and '7' is which column number you are hiding. Hope this helps!

[jmcilhinney]

You shouldn't use the ColumnMapping property of a DataColumn to hide a DataGridView column because that is not it's purpose. It has that effect but that is not its primary purpose so it has other implications as well.