It's not question of the .net code, it's a question of how the data is structured and queried. Are you trying to use any complex joins? Do you have covering indexes? Do you really need to retrieve all 100000 at once? This seems extremely excessive for a mobile application. I know the language. I've read a book. - _Madmatt

Yajjoj wrote: Jsp full code and the connection string to connect JSP with Microsoft Sql Server 2005 database If this is a request for code, you will not get it. If you have a sensible programming question perhaps you could post it here instead.

write this code in response page "Response.Redirect(string.Format(default.aspx?id={0}",id), true); Write this code in secound page string id=Request.QueryString["id"]; u will get the id in string format otherwise store it in session If It Helps Click It as Answer

THANK YOU SO MUCH MY FREIND BUT I AM NOT LOOKING FOR AccordianControl in ajax extender I AM LOOKING FOR SLIDE SHOW (NUMBER OF PICS AND THEY AUTOMATIC CHANGE IN SPESIFY TIME) al hajjaj

you too :thumbsup:N a v a :rose:n e e t h:thumbsup: thank you so much. al hajjaj

:thumbsup::thumbsup:yes , it's the best idea :^) but i don't know where to start. :-O al hajjaj

Web service is an ultimate solution but if you think this way is not possible you can move just the reservations table on web service and you can synchronize other tables at a specific time. On this way you have enough time to convert all your database to web service. Good luck!