SQLDataSource FilterExpression reset question

Discussion in 'ASP .Net' started by fniles, Mar 29, 2009.

  1. fniles

    fniles Guest

    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.
     
    fniles, Mar 29, 2009
    #1
    1. Advertisements

  2. On Mar 29, 8:03 pm, "fniles" <> wrote:
    > 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.


    I think it must be set to Nothing
     
    Alexey Smirnov, Mar 30, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    1
    Views:
    8,005
    Markus
    Aug 25, 2005
  2. Henry Habermacher [MVP Access]

    GridView - Changing FilterExpression of SQLDataSource and Paging

    Henry Habermacher [MVP Access], Jan 20, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    11,735
    kmarchiony
    Jul 31, 2007
  3. Replies:
    0
    Views:
    3,250
  4. lewis
    Replies:
    0
    Views:
    582
    lewis
    Jan 9, 2007
  5. lewis
    Replies:
    0
    Views:
    681
    lewis
    Jan 10, 2007
  6. jobs
    Replies:
    1
    Views:
    1,411
    =?Utf-8?B?SmFzb24gVmVybWlsbGlvbg==?=
    Jan 29, 2007
  7. fniles
    Replies:
    0
    Views:
    670
    fniles
    Mar 25, 2009
  8. fniles
    Replies:
    0
    Views:
    547
    fniles
    Mar 29, 2009
Loading...