Hiding fields of a datagrid

[RachWill]

I was wondering whether it is possible to have a select statement where you select all the fields, but then later hide some of the fields using a datagrid?
Thanks,
Rachel

[Pirate]

Why don't you have two sql statements , one to select all fileds and the other one for some fields to show in the Grid.

[hellswraith]

Use a dataview to filter the results in the datagrid, then bind the datagrid to the dataview instead of directly to the dataset.