How to re-select row in a gridview _after_ sorting?

Discussion in 'ASP .Net' started by Bogdan, Dec 8, 2009.

  1. Bogdan

    Bogdan Guest


    I have a gridview with ObjectDataSource attached and page/sort enabled. A
    user can select a row on a given page. The app 'remembers' data item linked
    to the selected row. The row is rendered as selected only if a user
    navigates to the page containing the selected data. A user can navigate to
    the selected data item's detail page and then come back to the grid view.
    Although the 'coming back' is not a page postback, the corresponding row
    will still be selected and a proper page displayed.
    This is relatively easy to do - I simply handle the Selected event of the
    data source object and based on its table content I calculate current page
    index and selected index (i.e. if the selected data happens to be on the
    current page).

    Unfortunately the above approach does not work when sorting is involved.
    The sort occurs after the Selected event so I have no way of determining on
    what page the selected data item is.

    Is there another way I could accomplish the above? Is there an event fired
    _after_ the ObjectDataSource sort operation is performed?

    Bogdan, Dec 8, 2009
    1. Advertisements

  2. You mean "the default methodology does not allow me to selected a sorted

    Assume you are also using paging?

    If you want a user to select a row, remember the row, and have paging
    and sorting, you will have to do some work on the result set yourself.
    You will also have to store pointers and create the grid results. It is
    not impossible, just work.

    As a high level, I would suggest binding a DataView to the Grid. You
    then have to figure out what the grid consists of and create the proper
    row filter.

    Ultimately, this means custom paging and sorting, but there are plenty
    of Google hits on both topics. You will also need to keep "state" as far
    as selected row goes. This can be stored in ViewState, if you want it
    for this page alone.

    Hope this helps.

    Peace and Grace,

    Gregory A. Beamer (MVP)

    Twitter: @gbworld

    | Think outside the box! |
    Gregory A. Beamer, Dec 8, 2009
    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.