soluton

if the sql database is there on the client side then it easy else webservice is need in the case where the sql server is maintained out side client's network.

you can also use the connection string to access the remote database using the IP address and port,