Anybody Know of a Control for Building .NET SqlConnection Strings?

I’m looking for a Windows Forms control or dialog used to both parse and build connection strings by walking the user though selecting a server, database, etc…

If you know of such a control, please provide a comment. I’ve been able to build OLEDB connection strings using the Microsoft OLE DB type library, but it only produces OLEDB connection string. I want a dialog or control that can walk a user into building a valid connection string like:

Server=localhost;Database=SubtextData;Trusted_Connection=True

Thanks!

Comments

2 responses

Victor Boctor • May 8th, 2005
In .NET 2.0 there is the DbConnectionStringBuilder base class which allows you to generate/parse/modify connection strings. It is not a control however.

The following db specific classes are derived from DbConnectionStringBuilder:

- System.Data.Odbc.OdbcConnectionStringBuilder

- System.Data.OleDb.OleDbConnectionStringBuilder

- System.Data.OracleClient.OracleConnectionStringBuilder

- System.Data.SqlClient.SqlConnectionStringBuilder

Regards,

Victor.

Ayende Rahien • May 11th, 2005
What about the Data Link Properties?

It's not .NET, but it's COM and can be called easily for the same result.