Limiting Columns shown in a DataGrid?

Question

Folks if you have a dataSet that has 5 columns for example is there a way to show the DataSet in a DataGrid but limit which columns are shown? DataSet ds = some stored procedure call; myDataGrid.dataSource = ds; Essentially I still want to be able to access data in all columns but only want some columns to show - is the doable? E.g. I might hide column[0] but still want to access its value if the user hilights a row in my DataGrid with code like: string HiddenColumnValue = myDataGrid[myDataGrid.CurrentCell.RowNumber 0] // gets column0's value for this row. (I've seen the ADO.NET view classes which let you control the rows coming back by providing filters but I dont think they allow you to control the columns.) Thanks.

Bloopy · Answer

Surely if you want to have access to columns that aren't shown the best way is to simply set the column width to 0?

Andrzej Wegierski · Answer

An example: DataGridTableStyle ts1 = new DataGridTableStyle(); ts1.MappingName = myTable; DataGridBoolColumn myDataCol = new DataGridBoolColumn(); myDataCol.HeaderText = MyColumn; myDataCol.MappingName = myColumn; ts1.GridColumnStyles.Add(myDataCol); dataGrid1.TableStyles.Add(ts1); to make column invisible set MappingName to invalid name: myDataCol.MappingName = myInvisibleColumn; or add them in Visual Designer if You use Visual Studio etc.

aeroswan · Answer

could you explain it in detail?

Andrzej Wegierski · Answer

Don't use automatic mode in creating DataGrid columns. Create Your own TableStyle and ColumnStyles.