Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > sqldatasource filterexpression and paging

Thread Tools

sqldatasource filterexpression and paging

Posts: n/a
I have a simple web site that does a search in a table.

On the top of the screen i have several fields that allow a user to
type in data and a search button.
In the click of the button i set the FilterExpression of the
(I am doing this manually because the where clause can be complex)

So it may look like something as simple as
ds.FilterExpression = "name like 'abc%'";

When the user hits the search button the filter works correctly.
The results are displayed and i have my paging buttons on the bottom.

If the user then clicks any of the paging buttons. My filter expression
is removed and a select occurs on the entire database.

how can i get the datasource to retain my filter expression between

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
GridView - Changing FilterExpression of SQLDataSource and Paging Henry Habermacher [MVP Access] ASP .Net 2 07-31-2007 04:05 AM
sqldatasource filterexpression - Cannot find column jobs ASP .Net 1 01-29-2007 04:29 AM
sqldatasource filterexpression and paging lewis ASP .Net 0 01-10-2007 04:52 PM
SqlDataSource FilterExpression doesn't support LIKE + 'String__' pattern ASP .Net 0 04-07-2006 06:31 PM
Programmatically set FilterExpression and FilterParameters of SqlDataSource ASP .Net 1 08-25-2005 02:24 PM