Thank you. That would be the best solution for the moment. I will do that. Much appreicate everyone.

Hi Johnson and peterhe,

Thank you for the codes peterhe. I have that done in my datalayer.

John. Here are my answers to your questions.

Order...

Hi jcobble,

Thank you. But my sort order will be used only for PK. Not on other fields. I'm afraid I feel using cursor would slow down the performance as we...

Thank you Phil and Remi.

Remi, it can be any rows up to the user. I have a huge table file and am using my custom paging control. I need the...

Thanks for reply. But I do not have any identity field that can be devide by interger or whatever. My Primary Key is CustomerID which is nvarchar(20). Hope this way...