paging in gridview using ODBC

Question

hi all,

i've implemented a Gridview wich occurs a problem when im trying to raise the paging-event.
it leaves a blank gridview when i'm trying to 'page' to next page.

In the gridview properties the AllowPaging is set on "true".
i Double clicked on "PageIndexChanging" to actually raise the event.

I'm using ODBC to connect to my (MySql) database.
I'm using also Dataset to fill my Gridview.
I'm aware of the fact that paging not works while using a dataset.
But what is in my case e better alternative?

Some usefull information wich can put me in the right direction would be very nice.....

kind regards Romano