You need to do custom paging. That is:
--> Make a simple user control (or simply do on required page) which contains repeater with simple links (1, 2 ,4 ...) showing page numbers.
--> Decide max number of elements to be shown at a time (eg. 10)
--> In ur query, multiply ur page number(eg. 2) with 10 into MaxRows and get rows from MaxRows -10 to MaxRows.
There are various methods to this thing in Stored Procdeure (query). You can use ROW_NUMBER feature or whatever is available in ur DB features.