G
Guest
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.
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.