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 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.

To get samples and instructions for installing them:

  • On the Visual Studio Help menu, click Samples.

    For more information, see Visual Studio Samples.

  • The most recent version and complete list of samples is available online from the Visual Studio 2008 Samples page.

  • You can also locate samples on your computer's hard disk. By default, samples and a Readme file are copied into a folder under \Program Files\Visual Studio 9.0\Samples\. For Express editions of Visual Studio, all samples are located online.

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

Community Additions