connect client to server in c# windows application

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi all,

Now am successfully connect client and server based on ip address. my connection string at client is (Data Source=192.168.x.x(server IP),Initial Catalog=aaa,User=sa,Password='xxx'). Data are successfully saved both client and server. But now my problem is data are stored only when the internet is enable otherwise my data are stored only at client side.
here am think new idea that is "if the data is stored in client when no internet but after the connection is enable between client server the datas are automatically transferred to server".. Is this possible or not, if YES means please say your valuable suggestions..

Thanks in Advance

Dhinesh Kumar.V

Posted 1-Jul-12 21:07pm

Dhinesh kumar.V

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-07-01T21:18:00

That's a bit odd - 192.168.x.x is not an internet IP address - it's part of your local LAN setup (it's a reserved address range).

As for client data later being updated onto a server DB, the process you shoudl be looking at is Replication, and it is a bit more complex than you think...

Start reading here: http://msdn.microsoft.com/en-us/library/ms151198.aspx[^] - but don't expect it to be a five minute job!