VB.NET Deleting Columns in the DataGrid Control

The deleted or hidden columns still exist in the data source the grid is bound to, and can still be accessed programmatically. They are just no longer visible in the datagrid.

Note   If your application does not access certain columns of data, and you do not want them displayed in the datagrid, then it is probably not necessary to include them in the data source in the first place.

To delete a column from the DataGrid programmatically

1. In the declarations area of your form, declare a new instance of the DataGridTableStyle class.
2. Set the DataGridTableStyle.MappingName property to the table in your data source that you want to apply the style to. The following example uses the DataGrid.DataMember property, which it assumes is already set.
3. Add the new DataGridTableStyle object to the datagrid's table styles collection.
4. Call the RemoveAt method of the DataGrid's GridColumnStyles collection, specifying the column index of the column to delete.

       ' Declare a new DataGridTableStyle in the
       ' declarations area of your form.
       Dim ts As DataGridTableStyle = New DataGridTableStyle()

       Sub DeleteColumn()
           ' Set the DataGridTableStyle.MappingName property
           ' to the table in the data source to map to.
           ts.MappingName = DataGrid1.DataMember

           ' Add it to the datagrid's TableStyles collection
           DataGrid1.TableStyles.Add(ts)
    
           ' Delete the first column (index 0)
           DataGrid1.TableStyles(0).GridColumnStyles.RemoveAt(0)
       End Sub

To hide a column in the DataGrid programmatically

1. In the declarations area of your form, declare a new instance of the DataGridTableStyle class.
2. Set the MappingName property of the DataGridTableStyle to the table in your data source that you want to apply the style to. The following code example uses the DataGrid.DataMember property, which it assumes is already set.
3. Add the new DataGridTableStyle object to the datagrid's table styles collection.
4. Hide the column by setting its Width property to 0, specifying the column index of the column to hide.
   
       Dim ts As DataGridTableStyle = New DataGridTableStyle()

       Sub HideColumn()
           ' Set the DataGridTableStyle.MappingName property
           ' to the table in the data source to map to.
           ts.MappingName = DataGrid1.DataMember

           ' Add it to the datagrid's TableStyles collection
           DataGrid1.TableStyles.Add(ts)

           ' Hide the first column (index 0)
           DataGrid1.TableStyles(0).GridColumnStyles(0).Width = 0
       End Sub