This documentation is archived and is not being maintained.

Data Sample: Demonstrates Simple Access to a SQL Database 

Download sample

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 provided to illustrate a concept and should not be used in applications or Web sites, as it may not illustrate the safest coding practices. Microsoft assumes no liability for incidental or consequential damages should the sample code be used for purposes other than as intended.

Building and Running the Sample

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.

Classes and Keywords

This sample demonstrates the following classes:

SQLDataReader; DataSet

This sample demonstrates the following keywords:

SQLDataReader; DataSet; SQL; Data

See Also