SQL Anywhere® Server - Programming
  Tutorial: Using the SQL Anywhere .NET Data Provider
Tutorial: Using the Table Viewer code sample

This tutorial is based on the Table Viewer project that is includecan 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 The samples directory.

The Table Viewer project is more complex than the Simple project. It illustrates the following features:

• connecting to a database using the SAConnection object

• executing a query using the SACommand object

• obtaining the results using the SADataReader object

• using a grid to display the results using the DataGrid object

• more advanced error handling and result checking

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

1. Start Visual Studio .NET.

2. Choose File>Open>Project.

3. Browse to samples-dir\SQLAnywhere\ADO.NET\TableViewer and open the TableViewer.sln project.

4. 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 coden the TableViewer.sln project.

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

   • In the Solution Explorer window, open the References folder.

   • You should see iAnywhere.Data.SQLAnywhere in the list.

     For instructions about adding a reference to the Data Provider DLL, see Adding wer code sample. To view the using directive:

     • Open the source code for the project. In the Solution Explorer window, right-click TableViewer.cs and choose View Code from the popup menu.

     • In the using directives in the top section, you should see the following line:

       using iAnywhere.Data.SQLAnywhere;

       This line is required for C# projects. If you are using Visual Basic .NET, 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 dialog appears.

     • In the Table Viewer dialog, click Connect.

       The application connects to the SQL Anywhere sample database.

     • In the Table Viewer dialog, click Execute.

       The application retrieves the data from the Employees table in the sample database and puts the query results in the Results DataList, as follows:

       

     • You can also execute other SQL statements from this application: type a SQL statement in the SQL Statement pane, and then click Execute.

   • Click the X in the upper right corner of the screen to terminate the application and disconnect from the SQL Anywhere sample database. This also shuts down the database server.

Understanding the Table Viewer sample project