Daft question but how do I remove a filter from a datasource??

[AAJ]

I know this sounds nuts, but how do I remove the following filter from a
Object Datasource that looks at my business layer...

ODSDefaultUserProfiles.FilterExpression = "AllowedWebPage = '" +
m_SelectedPageName + "'";

I tried the obvious ones such as

ODSDefaultUserProfiles.FilterExpression = "";
forcing a select(), databind(); all to no avail

many thanks if anyone knows

Andy

 

[nick_nw]

I know this sounds nuts, but how do I remove the following filter from a
Object Datasource that looks at my business layer...

ODSDefaultUserProfiles.FilterExpression = "AllowedWebPage = '" +
m_SelectedPageName + "'";

I tried the obvious ones such as

ODSDefaultUserProfiles.FilterExpression = "";
forcing a select(), databind(); all to no avail

many thanks if anyone knows

Andy

I'm assuming ODSDefaultUserProfiles is your own class so it's difficult
to say how you'd remove the filter. In Ado.Net setting a filter string
to null will remove a filter, e.g.

DataTable table = new DataTable ();

// Add data to table.

DataView view = new DataView (table);

// Apply filter.
view.RowFilter = filterString;

// Cancel filter.
view.RowFilter = null;

Best,

Nick
http://seecharp.blogspot.com/

 

[AAJ]

Setting .FilterExpression = null; worked


obvious when you think about it, but not so obvious I thought about it !!!!


cheers Nick

Andy