Link to home
Start Free TrialLog in
Avatar of rp
rpFlag for Portugal

asked on

Read data/write remotley from website to local application

I need read and write data from a remote sql database located in a web host provider to my local application in my pc. Can someone show some code. Or what the difference between connection with local database and remote. I try read data from database in web host to a gridview, and work but i have only a few records. If i have many records the connection remain stable or any problem may occur?  
Avatar of maXXXeE
maXXXeE

The only difference is in the connection string. The ipaddress or the server url and other parameters will be changed in the connection string.

There is no difference in code or how the data is retrieved or shown. The application need not know or does not know if the database is local or remote.
Avatar of rp

ASKER

But in this case for ex. i need to read from remote database about 3000 records daily  and write in a local database, and mark the records (write) in remote database. What can I do to keep a stable connection, because is established       through internet.
ASKER CERTIFIED SOLUTION
Avatar of maXXXeE
maXXXeE

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial