Connection string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stig-Arne Basberg - 13 Sep 2006 08:08 GMT

I would like to make it easy for users of my app to change database. Not
everyone knows all the necessary settings in a connection string, so is
there any way for me launch the database "Connection properties" window
(same as when generating a connection string in VS2005) from my application?

Regards Stig

Reply to this Message

Miha Markic [MVP C#] - 13 Sep 2006 08:42 GMT

Hi Stig,

Well, you still can but you'll have to parse/adjust connection string (just
google around and you'll find plenty of examples such as
http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_f
rm/thread/fa85d5af8ae2bac9/2c09b11eb6b489eb?lnk=st&q=show+data+link+window+group
%3A*adonet*&rnum=2&hl=sl#2c09b11eb6b489eb).
However, I would recommend using your code - with DbConnectionStringBuilder
derived classes and DbDataSourceEnumerator derived classes it shouldn't be
hard.

Signature

Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

>I would like to make it easy for users of my app to change database. Not
>everyone knows all the necessary settings in a connection string, so is
[quoted text clipped - 3 lines]
>
> Regards Stig

Reply to this Message

Stig-Arne Basberg - 13 Sep 2006 09:29 GMT

Thanks, I'll try that.

Stig

> Hi Stig,
>
[quoted text clipped - 12 lines]
>>
>> Regards Stig

Reply to this Message

Connection string

Free Magazines