Datasheet

Figure 1-17: Results of query execution

You can also use VWD to work with data that is located in a remote SQL Server or other database,

as well as with local data (as we do in this book). Right-click on the root entry named Data Connections

at the top of the Database Explorer window, and select Add Connection. . . . This opens the Add

Connection dialog where you specify details of the database server to which you want to connect. At

the top of this dialog is the Data source (type), and the default is Microsoft SQL Sever (SqlClient). This

is the most efficient way to access a SQL Server database, because it uses the built-in high-speed inter-

face called Tabular Data Stream (TDS) that is native and exclusive to SQL Server.

However, you can click the Change button (see Figure 1-18) and select a different data source type if

required. For example, you can connect to an Access database file, any database system that has an open

database connectivity (ODBC) provider available, direct to a persisted SQL Server (MDF) file, or to an

Oracle database. You can even specify, using the checkbox at the bottom of the window, if this should be

the default data source (type) to use in the future.

Chapter 1

04_588079 ch01.qxd 11/29/05 3:48 PM Page 16