The Server Explorer in Visual Studio needs little introduction for many a programmer; but for newbie, it might need some proper explanation; hence, this article. Let me start at the beginning.
What Is the Server Explorer?
The Server Explorer is a shortcut to accessing servers, either installed on the system, or connected to the system. These servers are usually database servers such as SQL Server. By accessing the server, you access all the databases on the specific server, and then you can build the connections needed inside your program, for your program. You also can get access to SharePoint servers. I will touch on SharePoint a little bit later, but for now, I will concentrate on using the Server Explorer with an SQL Server, and then move on to the inner workings of the Server Explorer.
How Does the Server Explorer Work?
As said, the Server Explorer provides quick access to the connected database servers. With the Server Explorer, you can set up queries for use in your program. A default instance of the Server Explorer looks like the following:
Figure 1: The Server Explorer
You can see in Figure 1 that there are three items listed:
- Data Connections
- SharePoint Connections
As the name implies, the Data Connections item allows you to add, edit, and remove data connections within your program. To connect to a database on a server, follow these steps:
- Click the Connect to Database button on the Server Explorer’s toolbox.
Figure 2: Add Connection
- You simply enter (or choose) the server name, choose the database name, and click OK.
- The connection will be entered into the Server Explorer window. It’s as simple as that.
The Servers item gives you access to all the servers connected to your computer, as displayed in Figure 3:
Figure 3: Servers
Apart from seeing the servers, you get access to several tools as well. These tools assist in checking the performance of your queries as well as the event logs. You can have a look here for a detailed explanation on Performance Counters.
Earlier, I spoke briefly about SharePoint. According to Wikipedia, SharePoint is basically a web application platform. SharePoint integrates content management and document management capabilities. SharePoint is a set of web technologies that provides intranet portals, document management, collaboration, social networks, websites, enterprise search, and business intelligence. For a detailed list of SharePoint capabilities and what you can do with SharePoint, have a look here.
You might find the following articles quite helpful in your ventures inside the world of databases:
- Exploring the Data Controls in Visual Basic.NET
- Doing Data Extraction with Visual Basic.NET
- Using Parameterized Queries and Reports in VB.NET Database Applications
I hope you have enjoyed today’s article. Until next time, cheers!