Reader Level:
ARTICLE

How to: Generate or find Connection String from Visual Studio

Posted by Suthish Nair Articles | Visual Studio February 07, 2011
If you are just starting with ADO.NET and database programming in .NET, you may not remember the connection string syntax's. You can use Visual Studio designer to do the work for you.
  • 0
  • 0
  • 59055

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 helps 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 short listed, 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 


the Server Explorer window. Enter Server Name and user credentials then select the database and click on Test Connection.

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 (lets 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 drop down, 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!


COMMENT USING

Trending up