connection string

Expand Post »

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!

Similar Threads

connection string of SqlConnection in C#
Access connection string in Vb.Net 2003 to Oracle in VB.NET
Connection String in ASP.NET
Connection String in Visual Basic 4 / 5 / 6
Connection String in MS Access and FileMaker Pro

Digvijaysinh

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Feb 2009

Permalink

Feb 14th, 2009

Re: connection string

Using standard security:

ASP.NET Syntax (Toggle Plain Text)

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Using Trusted:

ASP.NET Syntax (Toggle Plain Text)

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?

techniner

Reputation Points: 12

Solved Threads: 19

Posting Pro

Offline

521 posts
since May 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: autocomplete textbox

Next Thread in ASP.NET Forum Timeline: Log File reading

DaniWeb Message

Cancel Changes

User Name
Password