Generate or find Connection String from Visual Studio

This article is about how to generate or find and where to find or how to know the correct Database Connection String for your application.

Introduction
 
This article is about how to generate or find and where to find or how to know the correct Database Connection String for your application. Now you all might think, what will be the big deal about knowing what the actual Connection String is. Most of the people will do a web search and copy and paste into the project, there will be a 50-50 chance of successful working of the Connection String. This article will help and show a simple way to generate or find the correct Connection String that will run without an error for the project. Also, I will list other a couple of ways to find the correct Connection String.
 
Getting Started
 
Let's say, if you are looking for a job change, got shortlisted, during the technical round the company asked you to create an application which does simple insertions into a Database table. You are provided with Visual Studio and a SQL Client. If it's your lucky day then the Connection String you used will work for you like a charm. But, if that doesn't work what will you do, how will I find the correct Connection String.
 
So how will you find the correct Connection String? It's simple, couple of ways there. Check below :)
 
1. Using Connect to Database method from Tools Menu.
 
Open Visual Studio, create a Web Site and click on Tools --> Connect to Database option. Add a new data connection from
 
1.jpg 
 
If the connection is successful then click on Advanced; that will open the properties window. Below the Data Source you can find the actual Connection String. So your  Connection String got generated, it simple huh !
 
2.jpg 
 
Another way is to right click on the newly created connection and select properties. The Connection String property will show the actual value.
 
3.jpg 
 
2. Using a web control (let's try with or use DropDownList) 
 
Drag and drop a DropDownList control to your form. Click on Choose Data Source from task list; this will open the Data Source Configuration Wizard.
 
4.jpg 
 
Select a New data source from dropdown, choose a Data Source Type (example: SQL Database) and click Next.
 
5.jpg 
 
From Choose Your Data Connection window you can create a new connection (refer to above point 1) or select existing one.
 
The following Connection String area will shows the actual value.
 
6.jpg 
 
That's it. You can even test the database connection with the preceding process without writing a single line of code.
 
Conclusion
 
I tried to show different ways to generate the correct Connection String using Visual Studio. 
 
Hope this article helped you. If you know any another way, please free to post below.
 
Please post your comments and rate the article. Also, post your questions to our Forum section.
 
Thank You!