Connection String from Visual Studio

Connection String:
A connection string contains connection information need to connect with data source.You can connect your project with any database by connection string.Visual Studio provides a very efficient way to find connection string.Follow these steps

  1. Open Visual Studio
  2. Go to View ->Server Explorer
  3. Right Choose Data Connection and Choose Add Connection
         














  4. New window open Click Change.By default data source SQL SERVER (sqlclient) selected. you can change it

     













5.  Select Data Source click ok and Fill information

5. Click ok connection created in server explorer
6. Right click on connection and select properties
    
see properties


Your connection string now created you can copy this and use as you want.

7. Similarly you can create connection string with any of the data base like oracle,access, and mysql.

2 comments:

  1. Simple and Use full..........

    ReplyDelete
  2. Thanks for sharing such informative guide on .Net technology. This post gives me detailed information about the .net technology. I am working as trainer in leading IT training academy offering Dot Net Training in Chennai and i use your guide to educate my students.

    ReplyDelete

Please leave a comment for this post