C # Operations Advantage Database Server

Simple demo:

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