How do I hide a column?

How do I hide a column?

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"];