data binding

[muharrem]

I am binding a datatableof a dataset to a gridview. But I want to exclude some columns from binding. How? string strSQL = string.Format("SELECT A,B,C,..); MySqlDataAdapter da = new MySqlDataAdapter(strSQL,myCommand); DataSet ds = new DataSet(); da.Fill(ds,"MyTable"); myGridView.DataSource = ds.Tables["MyTable"]; Above line, how to exclude some columns from binding to grid? Thanks

[Ashfield]

You need to create and bind individual columns. Alternativley, in the design view you can specifiy columns and their corresponding datasource. An easier way would be to only select the columns you need. A final alternative, for those columns you do not want to see, set the width to zero.

Bob Ashfield Consultants Ltd