can datagrid column hidden in vb.net ?

  • Thread starter Thread starter Localbar
  • Start date Start date
L

Localbar

hi all,

If I have a datagrid, actually has 5 column. but I would like in run
time hidden last column.
The reason is the form also have combobox for filter datagrid row. my
problem is that I don't want the filter key show in datagrid. so that's why
I would like to hidden it...any idea..

Thanks
 
Is this a Windows Forms DataGrid? If so, you can set the column width
to zero to hide a column provided you have a non-Nothing tablestyle.
Here is some code snippets.

'.... make sure your DataGrid is using a tablestyle
dataGrid1.DataSource = _dataSet.Tables("customers")
Dim dgts As New DataGridTableStyle()
dgts.MappingName = "customers"
dataGrid1.TableStyles.Add(dgts)

'......

'method to set a column with by colnumber
Public Sub SetColWidth(tableStyle As DataGridTableStyle, colNum As
Integer, width As Integer)
Try
tableStyle.GridColumnStyles(colNum).Width = width
tableStyle.DataGrid.Refresh()
Catch 'empty catch .. do nothing
End Try
End Sub 'SetColWidth

'....


' here is how you might call this method
Private Sub button1_Click(sender As Object, e As System.EventArgs)
Dim tableStyle As DataGridTableStyle =
dataGrid1.TableStyles("customers")
SetColWidth(tableStyle, 1, 0) 'set width to zero
End Sub 'button1_Click

===============
Clay Burch
Syncfusion, Inc.
 
In the designer (or via code) you can toggle the columns Visible
property off.

HTH,

Wayne P.
 
Back
Top