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!

Using standard security:

Using Trusted:


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?