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
Printable View
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
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.
Use a dataview to filter the results in the datagrid, then bind the datagrid to the dataview instead of directly to the dataset.