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.
Note
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.
.gif "Security note") Security 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.
Building and Running the Sample
To build and run Data using Visual Studio
In the Visual Studio IDE, load the solution file data.sln.
In Solution Explorer, right-click the Data solution.
On the shortcut menu, click Build.
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