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.
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.
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
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
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
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
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
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
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks checoo
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 ;)