• Sybase SQL Anywhere Studio 7.x or later
• asademo.db file (included with Adaptive Server Anywhere)
• ASA 8.0 Sample data source (created by default when Adaptive Server Anywhere is installed)
• Microsoft Visual Studio .NET version 7.0
• Microsoft ADO.NET
• Windows NT, 98, 2000, Me, or XP

1. Start Visual Studio .NET.

2. Create a new project. Select Visual C# Projects from the left side.

• Select Console Application from the right side.
• Enter the project name CustomerDataReader.
• Enter the project location: c:\temp.
• Click OK to close the New Project dialog.

3. In your code, you must set the  System.Data name space. This is where all the ADO.NET classes are located. Enter the following  using directive at the beginning of your project:

   Using system.Data;

4. The next required  using directive is the OLE DB .NET Data Provider. Add the following  using directive to your project to use the Microsoft OLE DB .NET provider:

   Using System.Data.OleDb;

   Your source should now look like the following:

   using System; using System.Data; using System.Data.OleDb; namespace CustomerDataReader { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main(string[] args) { // // TODO: Add code to start application here // } } }

   Now you can write the code required to establish communication between Adaptive Server Anywhere and your C# application.

5. Add the following code to the  public static void Main() function after the  //TODO: Add code to start application here  comment:

//Set your connection string OleDbConnection myConnection =  new OleDbConnection(   @"Data Source=ASA 8.0 Sample;Provider=ASAProv.80"); //open the connection myConnection.Open(); //Creating command object. OleDbCommand myCommand = myConnection.CreateCommand(); //Specify query myCommand.CommandText = "Select fname, lname from Customer";

//DataReader for the command OleDbDataReader myDataReader = myCommand.ExecuteReader(); //Let's display data while ( myDataReader.Read()) { Console.WriteLine("\t{0}\t{1}", myDataReader["fname"],myDataReader["lname"]); } myDataReader.Close(); myConnection.Close();

6. Run the project by pressing CTRL+F5. You should see the following listing:

                :                 :         Dominic Johansen         Stanley Jue         Harry   Jones         Marie   Curie         Elizabeth       Bordon         Len     Manager         Tony    Antolini         Tom     Cruz         Janice  O'Toole         Stevie  Nickolas         Philipe Fernandez         Jennifer        Stutzman  &n

[1] [2]  下一页