Thanks

thanks heath i moved toward distributed application so you may find me ask many qoustion about this topic so any suggestion will be appreciated thanks agai

sorry for posting in wrong forum but i did that in case that i have to write application to do this in all cases thanks for your help

Thanks Heath , Guillermo i agree with you but i have a comment about using Ado server side cursor as heath mentioned some of its advantage i see that keeping long time open connection with the database server and the number of the round trips between the client and server may be unaccepted and may be this solution violate the philosophy of ado.net what i want to say make this last solution. what is your opinions ? TO Heath : i posted another quetsion about paging decision at sql,ado.net forum may you take a look?

THANKS FOR ALL

To: Mohamad Al Husseiny Hi there. Have you got a solution to your problem already? Because im encountering that same problem. if you already have the solution please it would help me a lot thanks.:)