Saturday, 12 March 2016
Connection string is a string with server information which is used to connect to the database with the details of the server, database name and credentials with which we want to connect.
Steps to get connection string from Visual Studio Server Explorer:
Example: Data Source=WINBC250150-JUL\SQLEXPRESS;Initial Catalog=Db_RestaurantMgmtSystem;Integrated Security=True
Steps to get connection string from Visual Studio Server Explorer:
Right click on data connection in server explorer – Add connection
Enter server name of your SQL server in which database is present
Select authentication as windows or SQL server authentication which is used for your SQL Server
Select your database from the dropdown list
Click on Test Connection button to check the connection and then click on OK.
Then right click on the newly added connection for your database under Data Connections
Select properties and copy the connection string.
Enter server name of your SQL server in which database is present
Select authentication as windows or SQL server authentication which is used for your SQL Server
Select your database from the dropdown list
Click on Test Connection button to check the connection and then click on OK.
Then right click on the newly added connection for your database under Data Connections
Select properties and copy the connection string.
Example: Data Source=WINBC250150-JUL\SQLEXPRESS;Initial Catalog=Db_RestaurantMgmtSystem;Integrated Security=True
