This tutorial is based on the Table Viewer project that is included with the SQL Anywhere .NET Data Provider.
The complete application can be found in your SQL Anywhere samples directory in samples-dir\SQLAnywhere\ADO.NET\TableViewer.
For information about the default location of samples-dir, see Samples directory.
The Table Viewer project is more complex than the Simple project. It illustrates the following features:
For more information about how the sample works, see Understanding the Table Viewer sample project.
To run the Table Viewer code sample in Visual Studio
Start Visual Studio.
Choose File » Open » Project.
Browse to samples-dir\SQLAnywhere\ADO.NET\TableViewer and open the TableViewer.sln project.
If you want to use the SQL Anywhere .NET Data Provider in a project, you must add a reference to the Data Provider DLL. This has already been done in the Table Viewer code sample. You can view the reference to the Data Provider DLL in the following location:
For instructions about adding a reference to the Data Provider DLL, see Adding a reference to the Data Provider DLL in your project.
You must also add a
using directive to your source code to reference the Data Provider classes. This has already been done in the Table Viewer code
sample. To view the
usingdirectives in the top section, you should see the following line:
This line is required for C# projects. If you are using Visual Basic, you need to add an
Imports line to your source code.
Choose Debug » Start Without Debugging or press Ctrl+F5 to run the Table Viewer sample.
The Table Viewer window appears.
The application connects to the SQL Anywhere sample database.
The application retrieves the data from the Employees table in the sample database and puts the query results in the Results datagrid, as follows:
Click the X in the upper right corner of the screen to shut down the application and disconnect from the SQL Anywhere sample database. This also shuts down the database server.
You have now run the application. The next section describes the application code.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|