How there a utility to make connection string

[ad]

I often make mistake when making a connection to SqlServer.
I heard that there is a utility to make connection in Sql2005.
Has that?

 

[Kalpesh]

Use Server Explorer in VS.NET & see the properties of the connection
Alternatively, www.connectionstrings.com might help

HTH
Kalpesh

 

[William \(Bill\) Vaughn]

The 2.0 Framework includes a new "StringBuilder" class that can help.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[ad]

I have used StringBuilder to make ordinary string for a long time.

How can I use it to make connection string?

 

[Sahil Malik [MVP]]

I think Bill meant "ConnectionStringBuilder"

... anyway .. yes you can use SqlConnectionStringBuilder to create a
connection string for SQL Server etc. programmatically, but if you want that
GUI, where the user can specify details and connect to the SQL Server, you
should look into SMO (Sql Server Management Objects).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx


----------------------------------------------------------------------------