Filtering SQL Mobile

I have been tryingh to initiate a dynamic filter on a WM 5.0 PC - SQL Mobile (*.sdf) file with no luck.

In previous editions of SQL (7/2000) I could specify the filter off of the recordset such as

rs.filter = "Title LIKE '" (filter_text) "'"

but this doesn;t seem to be available.

I am using C# Visual Studio .NET 2005 -- targeting the WM 5.0 PC Smartdevice

Any help would be most welcome.

BizTalk User

Thank you,

I will run the gammit on dataviews and see if I can put them to use -- thanks for the nudge in the right direction ;-)
msavalia
I'm not sure what you mean by that. DataView is a class which can sort and filter data in DataTable which you can populate from SQL CE/Mobile database.

It's not related to SQL Server views nor it’s related to SQL Mobile directly. Here’s how to use DataView class:

http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconcreatingdataview.asp
stranger in a strange land
As far as I remember there never was any "dynamic filters" in SQL CE/Mobile managed providers and there's no "recordset" class.

To filter data please execute query with respective where clause. You could also use DataView filtering if you're using DataSet class.
cguy1
How would I set up a DataView with a configureable parameter
Filtering SQL Mobile