SqlConnectionStringBuilder form in .net C#

Question

I am wondering how I can add DATA LINK form to my WIN application. You know those forms where Users can choose on witch SQL server they going to connect and what type of security they going to use and on wht database.

Something like on this picture alt text http://img186.imageshack.us/img186/7259/datalink.png

Paul Alexander · Accepted Answer · 2009-04-10 06:24:28Z

2

You can do it through some COM Introp...but then you have to pull in a bunch of Interop assemblies into your project which can be a drag. This code will show the dialog using reflection instead.

public static string ShowDialog( IWin32Window owner, 
                                 string connectionString )
{
    Type dlType = Type.GetTypeFromProgID( "DataLinks", true );
    Type acType = Type.GetTypeFromProgID( "ADODB.Connection", true );

    object form = Activator.CreateInstance( dlType );
    object connection = Activator.CreateInstance( acType ); 

    acType.InvokeMember( 
        "ConnectionString", 
        BindingFlags.Public | BindingFlags.SetProperty, 
        null, 
        connection, 
        new object[]{ connectionString } 
        );  
    object result = 
    dlType.InvokeMember( 
        "PromptEdit", 
        BindingFlags.Public | BindingFlags.InvokeMethod, 
        null, 
        form, 
        new object[]{ connection } 
        );          
    if( result != null && (bool)result )
        return acType.InvokeMember( 
                    "ConnectionString", 
                    BindingFlags.Public | BindingFlags.GetProperty, 
                    null, 
                    connection, 
                    new object[]{} ) as string;

    return null;
}

This basically translates to the following VB Script

form = GetObject( "DataLinks" )
connection = GetOBject( "ADODB.Connection" )
connection.ConnectionString = "existing connection"
form.PromptEdit( connection )
Return connection.ConnectionString

answered Apr 10, 2009 at 6:24

Paul Alexander

32.5k16 gold badges100 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

adopilot Over a year ago

I am again stacked on this issue, Now I try to send connection sting from app.config file to fill up Initial parameters but I alway get exeption on object result=dlType.InvokeMember. Any advice Thanx in advice

Paul Alexander Over a year ago

Might actually help to open a new question on SO so the entire problem/resolution can be documented for others.

adopilot Over a year ago

Thanx on Your attention Ill try yet for while If I couldn't figure it Then I am going to open new SO, But I am kind shamed asking over and over people to do code for me. Best regards

Paul Alexander Over a year ago

No shame...we all have to learn somewhere. Alot of this stuff is just down right bizzare and you only learn by banging your head on the wall for days at a time.

Community · Accepted Answer · 2017-05-23 12:17:02Z

1

Comments

Adriano Machado · Accepted Answer · 2010-06-01 22:31:11Z

1

I think that the best choice is to use the code provided from Microsoft here: http://code.msdn.microsoft.com/Connection.

It is the connection dialog used inside Visual Studio.

However, it only works with registered ADO.NET providers.

answered Jun 1, 2010 at 22:31

Adriano Machado

2323 silver badges17 bronze badges

Collectives™ on Stack Overflow

SqlConnectionStringBuilder form in .net C#

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related