المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : For Remote Connection -SQL Server



C# Programming
10-05-2011, 10:41 PM
I developed a small remote application, and connected with one of my client. But everytime Iam using the below code to connect with my server and accessing the sqlserver...And hence I found my application is slow at data loading and saving...

Is there any other way to connect the server faster manner ? or Any other approaches...

Thanks for the helps

public string WMSCon_1 = "Data Source=172.178.1.120; initial Catalog=Sales_Master; User Id=codeproject; Password=xxxxxxx"
Actually I given the above connection string and connecting with the client for data access. Simply every where Iam giving the ip and just connecting, whether I have to keep any other things for this remote access to increase the speed..?

Thankshttp://www.barakasoft.com/script/Forums/Images/thumbs_up.gif
PARAMU