Gridview persistance

i’ve been making apps for a while using 2.0 .
everything went fine until staff started requesting some customization on the gridview.
i thought i had it handled, but when i start to try to customized paging and editing unexpected things happen.

if we sort and then edit, once we’re finished the record might no longer be visable or selected.

it’s simple stuff that people expect, but i haven’t been able to make it work.

is there anyone or anything that can help me learn gridview fundamentals and basics so i can customize intelligently?

Are the records in your gridview joins into other tables?

no, it’s a very simple setup. pulling data from just one database