losing selection from dropdownlist when paging

[Dabbler]

I have a search textbox for entering search value. I use with OnCommand event
in an ImageButton to set the SqlCommand string manually in the OnCommand
method.

When I click on a page number other than the first page the Gridview acts as
if the default SqlCommand was in being used and shows all rows instead of the
ones determined by a where clause. In other words, my custom SqlCommand is
not persisting when the Pager navigation is being used.

Any suggestions on how this should be handled would be appreciated.

Thanks.

[clickon]

Are you re-binding the data every time the PAgeLoad event occurs, have you
tried putting the initial databinding in a if (!IsPostBack) condtion.

"Dabbler" wrote:

I have a search textbox for entering search value. I use with OnCommand event
in an ImageButton to set the SqlCommand string manually in the OnCommand
method.

When I click on a page number other than the first page the Gridview acts as
if the default SqlCommand was in being used and shows all rows instead of the
ones determined by a where clause. In other words, my custom SqlCommand is
not persisting when the Pager navigation is being used.

Any suggestions on how this should be handled would be appreciated.

Thanks.

[Phillip Williams]

The OnCommand event of the button fires only once and sets the SqlCommand
during that one postback. You have to persist that search condition in the
Session object and reset it while handling the page.init if the Session
variable is not null.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have a search textbox for entering search value. I use with OnCommand event
in an ImageButton to set the SqlCommand string manually in the OnCommand
method.

When I click on a page number other than the first page the Gridview acts as
if the default SqlCommand was in being used and shows all rows instead of the
ones determined by a where clause. In other words, my custom SqlCommand is
not persisting when the Pager navigation is being used.

Any suggestions on how this should be handled would be appreciated.

Thanks.

[Dabbler]

That's the ticket!

"Phillip Williams" wrote:

The OnCommand event of the button fires only once and sets the SqlCommand
during that one postback. You have to persist that search condition in the
Session object and reset it while handling the page.init if the Session
variable is not null.

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have a search textbox for entering search value. I use with OnCommand event
in an ImageButton to set the SqlCommand string manually in the OnCommand
method.

When I click on a page number other than the first page the Gridview acts as
if the default SqlCommand was in being used and shows all rows instead of the
ones determined by a where clause. In other words, my custom SqlCommand is
not persisting when the Pager navigation is being used.

Any suggestions on how this should be handled would be appreciated.

Thanks.