ASP.Net 2.0 gridview sybase paging

I am using either the aseclient or odbc methods to connect a gridview in asp.net 2.0 to sybase. I am using a select statement to retrieve the data. I want to limit the number of rows displayed in the gridview and use paging. However, it will not limit the rows and ignores the pagesize. Can you tell me if this can be done and how?

Thanks.