To run the Simple code sample in Visual Studio

1. Start Visual Studio.

2. Choose File » Open » Project.

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

4. When you 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 Simple 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 a reference to the Data Provider DLL in your project.

5. You must also add a using directive to your source code to reference the Data Provider classes. This has already been done in the Simple code sample. To view the using directive:

   • Open the source code for the project. In the Solution Explorer window, right-click Form1.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.

6. Choose Debug » Start Without Debugging or press Ctrl+F5 to run the Simple sample.

   The SQL Anywhere Sample window appears.

   • In the SQL Anywhere Sample window, click Connect.

     The application connects to the SQL Anywhere sample database and puts the last name of each employee in the window, as follows:

     

7. Click the X in the upper right corner of the screen to shut down the application and disconnect from the sample database. This also shuts down the database server.