Click here to Skip to main content
Sign Up to vote bad
good
See more: C#4.0
how to connect C# windows application to online sql server which is in hosting site
Posted 17 Dec '12 - 23:52

Comments
Avinash_Pathak - 18 Dec '12 - 6:14
that online sql server must have servername (ip address) and the database you want to connect must have username and password so take it from there and put it your web.config file in your connectionstring...and you done it...

1 solution

Try Connection String Like following
connectionString="Data Source=127.0.0.1;Initial Catalog=DatabaseName;User ID=sa;Password=PWD@123" providerName="System.Data.SqlClient"
 
Hope will help you...
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Mahesh Bailwal 413
1 Sergey Alexandrovich Kryukov 384
2 Maciej Los 200
3 Aarti Meswania 193
4 Rohan Leuva 165
0 Sergey Alexandrovich Kryukov 9,417
1 OriginalGriff 7,204
2 CPallini 3,933
3 Rohan Leuva 3,211
4 Maciej Los 2,743


Advertise | Privacy | Mobile
Web04 | 2.6.130516.1 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid