General .NET tip 3: How to easily get connection strings?

By Shivprasad Koirala

Now many times as a .NET developer we need connection strings to connect to databases. Connection string are long and cryptic and very difficult to remember. In this tip we will see a easy way of getting connection strings.

General .NET tip 3:- How to easily get connection strings?

Now many times as a .NET developer need connection strings to connect to databases. Connection string are long and cryptic and very difficult to remember.  In tip we will see an easy way of getting connection strings.  Open a empty notepad and save the notepad with .UDL extension.  For example you can see in the image below we have created “myConnection.udl”. You can also notice the icon change for UDL extensions.



Now double click on the “MyConnection.UDL” and you should see your most visited data link properties box. Fill the details of the server and databases and press OK.




Now open the UDL file in a simple noted pad and you should see your connection string as shown in the below figure. Copy and start connecting to your database.

Related FAQs

When we select source code in visual studio it selects the complete source code , but what if we want to select the code in a rectangular manner?
In this section we will see a very interesting and useful trick of visual studio called the extract method.
Many times we write comments in code to remind about certain tasks to be performed later and then we forget about the same as the comments gets lost in those million lines code.
Many times due to project pressure and lazy attitude you violate encapsulation and create public variables for classes as shown below. Even though your inner heart knows that the best practice is to create set and get property function but your lazy attitude overrules it.
While debugging you often want to skip debugging on certain lines of code. For instance in the below code you have set the debug point to the first line, you would like to skip the in between lines and jump directly to “console.writeline” step.
As a developer you always need some common codes again and again. Rather than writing those common codes from scratch you would like to get them easily from some handy place.
General .NET tip 3: How to easily get connection strings?  (801 Views)
Create New Account