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.

1 comment:

Please leave a comment for this post