Gridview Woes

[Esoteric]

I must just not get it. I have a gridview, I have parameters, the default query executes perfectly. Sorting, paging are all perfect. As soon as I enter something in my search box, the result is perfect but my sorting and paging revert to the initial load of the data.

Gridview1.Databind() does nothing

updating parameters, does nothing, everything I try leads to a dead end.

Is it just not possible to use sorting and paging in conjunction with SQL parameters? Why does it always go back to the initial load of the data? Why does it not keep the new data that is there on the screen in the control? I mean its right there, just sort the darn thing.

Thanks,

[ Ésôtêrîç ]

 

[jmeckley]

yes, this is the default behavior of the gridview. it's annonying to say the least. you need to track the page/sort (usually viewstate) yourself and set these properties right before you databind.

Jason Meckley
Programmer
Specialty Bakers, Inc.