C#操作 Advantage Database Server 数据库

相关下载

http://devzone.advantagedatabase.com/dz/content.aspx?key=31

1.安装数据库:

Advantage Database Server

2.安装数据库工具:

Advantage Data Architect

3.安装.NET数据访问组件(Advantage.Data.Provider.dll for .net 2.0或Advantage.Data.Entity.dll for 3.5以上):

Advantage .NET Data Provider

简单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("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();

        }

    }

}