[2005] Datagridview column visibility

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

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

-tg

I also have found that this works:

VB Code:

'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!

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.