How to connect a database from the Server Explorer window?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to connect a database from the Server Explorer window?
Rating:
Take the following steps to connect a database from the Server Explorer window:
- Select the View menu from the Visual Studio .NET development tool and choose the Server Explorer option.
- Select the Data Connections node in the Server Explorer option. Right-click the node and select the Add Connection option.
- The Choose Data Source dialog box appears if a database connection is created for the first time. In this dialog box, select the appropriate Data Source and the Data Provider for the application, and then click on the Continue option button.
- Click the Test Connection option to check whether the connection is established without closing the dialog box.
- Lastly, click the OK option button. Now, the database connection is established successfully. The connection can be viewed in the Server Explorer window under the Data Connections node.
After the database connection is established from the Server Explorer, the next step is to navigate through the database for the required stored procedure node until the desired stored procedure is found.
Rating:
Was this information helpful?
Other articles
- What is serialization?
- What are channels?
- What is CAB project?
- What is COUNT function?
- What is the WriteXml(string, XmlWriteMode) method?
