Paging and Filtering in Gridview (.NET 2.0)

Discussion in 'ASP .Net Web Controls' started by Bill Manring, Jan 11, 2006.

  1. Bill Manring

    Bill Manring Guest

    I am writing a very simple web application using VS 2005 and a SQL Server
    Database. I am just starting to experiment wth .NET 2.0 and I am trying out
    the supposedly improved databinding.

    I dragged a table from a datasource on to my web form and the GridView
    cpntrol was created. I turned on paging, and Edit and Delete buttons. I ran
    the app and everything worked great - not a single line of code written yet.

    Then I wanted to add a simple feature where the user could filter out data
    based on a value in a single column. I added a little code that set the
    FilterExpression property of the SqlDataSource, and that seemed to work fine
    as well. Here is the FilterExpression code:

    SqldataSource1.FilterExpression = "LastName = '" + txtFilterValue.Text + "'";

    This worked fine - I got a subset of the original data based on the last
    name I entered into a text box.

    The problem began if I tried to edit a record in the filtered data or go to
    another page in the filtered data. Taking either of these actions resulted
    in the restoration of the original unfiltered dataset. If I hit Edit on the
    first record of the first page in the filtered dataset, I was switched back
    to the first record in the unfiltered dataset and put in edit mode in the
    GridView control. If I go to another page of data in the Filtered dataset,
    the original dataset is resotred and I am sent to that page number in the
    original dataset.

    I tried taking the approach of changing the SelectCommand property of the
    SqlDataSource object instead of using the FilterExpression property, but that
    behaved the same way.

    The only code I have is in the "Filter" button click event. I have no code
    at all in the page_load event.

    This seems like it should be simple, but I am obviously missing something.
    I'm pretty sure I could go back to my current .NET v1.1 habits of doing
    everything myself in code, but I want to give the new databinding a chance
    before I abandoned it.

    Anyone have any idea what I am doing wrong?
    Bill Manring, Jan 11, 2006
    1. Advertisements

  2. Hi Bill,

    I am not sure because I haven't tried your scenario yet. I believe it
    might be built in behavior of the GridView. But like I said, I am not
    entirely sure on this.


    Wouter van Vugt
    Trainer - Info Support
    Wouter van Vugt, Jan 11, 2006
    1. Advertisements

  3. You might just need to move the line of code that sets the filter condition
    to the page_load so that the filter would be set upon each PostBack.
    Phillip Williams, Jan 11, 2006
  4. Bill Manring

    Bill Manring Guest


    That worked - thanks.
    Bill Manring, Jan 13, 2006
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.