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