by
Eng Nasser , programmer_ اعداد برامج , الشركة الوطنية لانشاء وتنمية وادارة الطرق
Data Source=tcp:(ip address),(port number);User Id=...; Password
>>>
لو انت على نتورك خاصه
.....................................
اما لو انت والسرفر على نفس النتورك
connection string easy :
SqlConnection con = new SqlConnection(@"server = name of server; integrated security = sspi;user id = ----;password = -------;Database=name of database")
Very simple. If you can connect to the local DBMS then the same way you connect to the real time DBMS with the change of the connection string parameters. Have a look also on this:
http://www.connectionstrings.com
by
Waleed AlZoghby , Software Engineer , OpenWare Information System Consulting Co.
The connection string will vary according to the Data Framework that you will use, In case if you will use ADO.NET so you can pick one of the following data providers to use according to your requirements such as SQLClient, OleDb, Odbc and OracleClient you can take a look on the following link "http://msdn.microsoft.com/en-US/library/ms254500(v=vs.80).aspx". In case if you will use Entity Framework (EF) you can take a look on this link "http://msdn.microsoft.com/en-us/library/cc716756.aspx".