using System;

using Advantage.Data.Provider;  



namespace ADSDemo

{

    class Program

    {

        static void Main(string[] args)

        {

            // create a connection object  

           // AdsConnection conn = new AdsConnection("data source=c:\\data;" + 

            //"ServerType=remote|local; TableType=ADT");



            //AdsConnection conn = new AdsConnection();

            //conn.ConnectionString = "data source=c:\\data\\Demo2.add; " +

            //"user id = adssys; password = '' " +

            //"ServerType=local; TrimTrailingSpaces = true";



            //AdsConnection conn = new AdsConnection();

            //conn.ConnectionString = "data source=c:\\data\\Demo2.add; " +

            //"user id = adssys;  " +

            //"ServerType=local; TrimTrailingSpaces = true";
      

                 //AdsConnection conn = new AdsConnection("Data Source=\\\\127.0.0.1:6262\\data\\Demo2.add;ServerType=REMOTE;
      

      User ID=AdsSys;Password=XXXXX;");



            AdsConnection conn = new AdsConnection();

            conn.ConnectionString = "data source=c:\\data\\Demo2.add; " + 

            "ServerType=local; TrimTrailingSpaces = true";





            AdsCommand cmd; 

            AdsDataReader reader; 

            int iField;

            try

            { 

                conn.Open();

                // create a command object  

                cmd = conn.CreateCommand();

                // specify a simple SELECT statement  

                cmd.CommandText = "select * from users";

                // execute the statement and create a reader  

                reader = cmd.ExecuteReader();

                // dump the results of the query to the console  

                while (reader.Read())

                {

                    for (iField = 0; iField < reader.FieldCount; iField++)

                        Console.Write(reader.GetValue(iField) + " ");

                    Console.WriteLine();

                }

                conn.Close();

            }

            catch (AdsException e)

            {

                Console.WriteLine(e.Message);



            }

            catch (System.Exception ex)

            {

                Console.WriteLine(ex.Message);

            }

            Console.ReadKey();

        }

    }

}