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

0 comments suggest edit

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!

Found a typo or error? Suggest an edit! If accepted, your contribution is listed automatically here.

Comments

avatar

2 responses

  1. Avatar for Victor Boctor
    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.

  2. Avatar for Ayende Rahien
    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.