Hiding colums in a datagrid
I'am reading data from a mysql database into a datagrid
see example
------------------------------------------------------------------------------------------------
string connectionString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=klanten;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";
OdbcConnection conn= new OdbcConnection(connectionString);
conn.Open();
this.da = new OdbcDataAdapter ("SELECT naw_id as id ,klantcode as Code, voorletters as Voornaam, tussenvoegsel as Tussenv, naam as Achternaam,totaalopen as Tegoed, adres as Adres, postcode as Postcode, plaats As Woonplaats, tel as Telefoon, email as 'Email adres' FROM naw order by totaalopen desc", conn);
this.ds = new DataSet();
da.Fill(ds, "Klantenlijst");
dataGrid1.DataSource= ds.Tables[0];
conn.Close();
I want to hide the first selection ( naw_id as id ) from the database does someone nows how to do this.
kr