Live Chat Icon For mobile
Live Chat Icon

How do I hide a column

Platform: WinForms| Category: Datagrid

There are several ways to hide a column:

1) You can use your DataSet’s ColumnMapping property to hide a column.

  // Creating connection and command sting
  string conStr = @''Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb'';
  string sqlStr = ''SELECT * FROM Employees'';
  // Create connection object
  OleDbConnection conn = new OleDbConnection(conStr);
  // Create data adapter object
  OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);

  // Create a dataset object and fill with data using data adapter’s Fill method
  DataSet ds = new DataSet();
  da.Fill(ds, ''Employees'');

  // Hide the column and attach dataset’s DefaultView to the datagrid control
  ds.Tables[''Employees''].Columns[''LastName''].ColumnMapping = MappingType.Hidden;
  dataGrid1.DataSource = ds.Tables[''Employees''];

2) Another way to hide a column is to set its width to zero. Check out the FAQ How do I set the width of a column in my DataGrid?.

3) Another way to hide a column is to create a custom table style, and as you add columnstyles to your tablestyle, omit the column you want hidden. Check out the FAQ How do I add an unbound column in my bound DataGrid? to see how to create a custom table style.

Share with

Related FAQs

Couldn't find the FAQs you're looking for?

Please submit your question and answer.