Can I define in datatable hidden columns?
Posted on 2006-04-23
I have datatable which is bound to grid.
In addition, this datatable is stored on server side and used to retrieve properties on server side as well.
Now I need to add to select sql 1 additional property:
this property will be used only on business logic side (so no need to render it to client).
But once I addit to sql - it's automatically displayed in grid.
I know how to make the property hidden by GridColumn.Hidden = true, but don't know the answers to the following questaions:
The questions are:
1. Can I define in datatable that column should not be bounded (so that it won't be rendered to client)? - the preferable option since I am chanign business logic and don't want grid be aware of that
2. Can I define in datagrid that column should not be bounded (so that it won't be rendered to client)?
3. Can I define in datatable that column should be hidden (so that it will be rendered to client but won't be dispalyed in grid)?
4. I feel somethign is wrong in my design: I am changing sql, and this requires changing grid as well (unless you find a solution to question 1). What is wrong? What's the right design for such cases?