Hi All.

I am developing an application in vb.net. There is one form in my application which loads CustomerId and CustomerName fields from the customer table in my sql server 2000 database. The database is stored on different physical computer located in other area far away from my system and I m connecting to remote system using dial-up connection or might even use vpn connection in future to connect my system with remote system. Now whenever I m opening this form, its taking long time to load the CustomerId and CustomerName list from the remote database and everyday this list goes on increasing coz new customers are added daily.

What my concern is how to cache this CustomerId and CustomerName data locally on my system so that I dont need to read data every time from remote computer? Also how to check whether the data I m caching on my computer is not changed on the remote computer by someone. I mean how to create this kind of applications for commercial purpose?

Please help me out.
Thanks.