Hide Columns in DataGrid

Question

Hi Everyone.

This is a simple problem which l simply can not work out whats wrong.

l am using C# and SQL CE . l can display a table in a datagrid with all fields however all l need to display is a few fields. Check out the following code.
----------------------------------------------------------------------------------------------

// create tables in Database

SqlCeConnection ssceconn = new SqlCeConnection(conString);
ssceconn.Open();
SqlCeCommand sqlCreateTable = ssceconn.CreateCommand();

sqlCreateTable.CommandText = "CREATE TABLE clientstable(client_id int IDENTITY(0,1) PRIMARY KEY, c_name nvarchar(50), c_address nvarchar(50), c_suburb nvarchar(50), c_state nvarchar(20), c_country nvarchar(30), c_abn nvarchar(30), c_contact1 nvarchar(50), c_contact2 nvarchar(50), c_telephone nvarchar(30), c_fax nvarchar(30), c_mobile nvarchar(30), c_terms nvarchar(20), c_category nvarchar(20), c_discount nvarchar(10), c_startdate datetime)";

sqlCreateTable.ExecuteNonQuery();

SqlCeCommand sqlInsertRow = ssceconn.CreateCommand();

sqlInsertRow.CommandText = "INSERT INTO clientstable(c_name, c_address, c_suburb, c_state, c_country, c_abn, c_contact1) VALUES ('ELIAS', '120 Down Town', 'Road', 'Melbourne', 'Victoria', 'Australia', '123 123 123')";

sqlInsertRow.ExecuteNonQuery();

//fill table

string sql = "SELECT * FROM clientstable";
try {

      DataSet sqlDS = new DataSet();
      System.Data.SqlServerCe.SqlCeDataAdapter sqlDA = new SqlCeDataAdapter(sql, ssceconn);
      sqlDA.Fill(sqlDS);
      dataGrid1.DataSource = sqlDS.Tables[0].DefaultView;
     }

catch(Exception ex)
{}

// Setup dataGrid Style

DataGridTableStyle dgts = new DataGridTableStyle();

dgts.MappingName = "clientstable";
DataGridTextBoxColumn clientColumn = new DataGridTextBoxColumn();
clientColumn.MappingName = "c_client";
clientColumn.HeaderText = "c_client";
clientColumn.Width = 0;
dgts.GridColumnStyles.Add(clientColumn);

DataGridTextBoxColumn nameColumn = new DataGridTextBoxColumn();

nameColumn.MappingName = "c_name";
nameColumn.HeaderText = "c_name";
nameColumn.Width = 50;
dgts.GridColumnStyles.Add(nameColumn);

DataGridTextBoxColumn addressColumn = new DataGridTextBoxColumn();

addressColumn.MappingName = "c_address";
addressColumn.HeaderText = "c_address";
addressColumn.Width = 0;
dgts.GridColumnStyles.Add(addressColumn);


dataGrid1.TableStyles.Add(dgts);

ssceconn.Close();

}

catch(Exception ex){}

}
-------------------------------------------------------------------------------------------

The above code works interms of creating sql ce database and displaying in a dataGrid, however when trying to hide a column by setting its width=0 does not work.

Any ideas ?

Thanking you in advance !!!