We recommend using Visual Studio 2017

Data Sample: Demonstrates Simple Access to a SQL Database

The Data sample demonstrates a simple query from an existing SQL database using the console. The result of the query is displayed and the program exits.


The sample assumes an existing SQL server and table. To run this sample to completion, you must provide a SQL server, a database, and a table.

Security noteSecurity Note

This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown. We recommend that you add security and error-handling code to make your projects more secure and robust. Microsoft provides this sample code "AS IS" with no warranties.

To get samples and instructions for installing them:

To access samples from Visual Studio

  • On the Help menu, click Samples.

    By default, these samples are installed in drive:\Program Files\Microsoft Visual Studio 10.0\Samples\.

  • For the most recent version of this sample and a list of other samples, see Visual Studio Samples on the MSDN Web site.

To build and run Data using Visual Studio

  1. In the Visual Studio IDE, load the solution file data.sln.

  2. In Solution Explorer, right-click the Data solution.

  3. On the shortcut menu, click Build.

  4. On the Debug menu, click Start.

This sample demonstrates the following classes:

SQLDataReader; DataSet

This sample demonstrates the following keywords:

SQLDataReader; DataSet; SQL; Data