首页 > 代码库 > C#操作Advantage Database Server

C#操作Advantage Database Server

简单Demo:

引用 D:\Program Files (x86)\Advantage 11.10\ado.net\2.0\Advantage.Data.Provider.dll

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();            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();        }    }}