Link to home
Start Free TrialLog in
Avatar of tgatif
tgatif

asked on

How to make a connection string

I need to find out that is there a way to make the connection string in VB.net through a already-developed wizard.

I know that in VB, if you right-click on control named "adodc" and select properties, a window of wizard appears through which you make the connection string by selecting the options.
Avatar of Glom
Glom
Flag of France image

Hi,

Try to put a SQLConnection (drag it from the data panel in design mode) in your windows form. Then you can access its ConnextionString property, and select "Create a new connection...".

That's all ;)
Avatar of Bob Learned
Another way, if you have the right O/S, is to create a text file on your desktop.  The name is not important, at first.  

After the empty file is created, then rename it to Connection Builder.udl.  When you double-click on the icon, you will get a connection wizard.  To get the connection string, drag the .UDL icon to a NOTEPAD icon on the desktop.

Bob
Avatar of tgatif
tgatif

ASKER

@Glom

I like to do this on fly.  When I press the button on the frame, this window appears and the result of the connecton string is appeared in one textbox.

Thanks
Avatar of tgatif

ASKER

@TheLearnedOne

I like to do this on fly.  Whe I press the button on the frame, this window appears and the result of the connectin string is appeared in one textbox

Thanks
There is another way, in the Server explorer, but I don't have the specifics right now.

Bob
ASKER CERTIFIED SOLUTION
Avatar of checoo
checoo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tgatif

ASKER

Thanks checoo