Most of the time, when a connection string is required, developers write it either manually, or use visual studio wizard from somewhere take make visual studio slower. So here is a quick fast way to do it. Let's build it more faster and easier way.
- Right click on desktop and create a new text document, say cn.txt
- Open that document and save it with .udl extension, cn.udl.
- save and close the file
- you will notice the file icon is now changed
- double click the icon.
- that will open a connection string dialog, same as you see in visual studio.
- choose provider, enter other details acoording to your provider and just test connection and click on ok
- right click that file, and open it in notepad. The file will contain connection string.
- Copy the connection string and use it anywhere you want.
Happy coding :)
Just thought you might like to know about an alternative method - using the online sql connection string generator on Devfusion. It only works for SQL server/express at the moment but it makes things nice and simple :)
ReplyDelete