Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQLDataSource FilterExpression question

Thread Tools

SQLDataSource FilterExpression question

Posts: n/a
I am using VS 2005 and sqldatasource.
Once I set the FilterExpression of the sqldatasource, how can I set it back
to the original sqldatasource without the FilterExpression ?
Say, I have a sqldatasource "select col1,col2 from tbl1"
When a filter button is hit, say I set sqldatasource.FilterExpression =
"col1 = 5"
After that if I want to go back to "select col1,col2 from tbl1", how can I
do that ?
Thank you.

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
SQLDataSource FilterExpression reset question fniles ASP .Net 1 03-30-2009 09:10 AM
SQLDataSource FilterExpression question fniles ASP .Net 0 03-25-2009 02:28 AM
GridView - Changing FilterExpression of SQLDataSource and Paging Henry Habermacher [MVP Access] ASP .Net 2 07-31-2007 04:05 AM
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