Is it possible to retrieve a list of the columns in a DataView?
My home page shows results from multiple data views, which contain different column names. If somebody types in say 'date: today', this works OK for data views that have a date column, but errors out on data views that don't.
So instead of just this:
Resources_View.RowFilter = SearchExpression;
I need to do this:
If ColumnName exists in DataView
{
Resources_View.RowFilter = SearchExpression;
}
The problem is, the SearchExpression variable is a single string (StringBuilder), so it could be: 'date: today and status: 1 and staff: joe bloggs.
Go to the complete details ...