Hii
everybody,
i want to make connection of my window application in c# and asp.net with
remote sql server 2005 then how can i make connectionstring and connection with remote database? please help me on this topic.
also if suppose connection is established, then how we can show the data of table of remote
server database in datagridview of our application.
thanx in advance!
Digvijaysinh
0
Newbie Poster
techniner
2
Posting Pro
Using standard security:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;Using Trusted:
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;Just curious, why aren't you using the data source tools in Visual Studio to basically drag and drop your connection and display data grid?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.