public static void Test() { // Connect string provider = DB.GetProvider("ACE"); if (provider == null) { Console.WriteLine("Error: No ACE Provider"); return; } OleDbConnection db = DB.Connect(provider, @".\priv\db\example.accdb"); db.Open(); DBServer srv = new DBServer(db); srv.Start(); //srv.Execute("Dies ist ein Test",10); OleDbDataReader r = srv.Query("SELECT Title, Author, Date FROM Pages;", 10); System.IO.StreamWriter file = new System.IO.StreamWriter(Console.OpenStandardOutput()); CSV.Write(r, file, ";", null, -1); r.Close(); file.Close(); srv.Stop(); }
private void req_students(Pink.Request req, string format, int ean) { string stm = "SELECT Schueler.ID, Schueler.Vorname, Schueler.Name, SchuelerLernabschnittsdaten.Klasse, SchuelerLernabschnittsdaten.ASDJahrgang " + "FROM EigeneSchule, Schueler INNER JOIN SchuelerLernabschnittsdaten ON Schueler.ID = SchuelerLernabschnittsdaten.Schueler_ID " + "WHERE (((SchuelerLernabschnittsdaten.Jahr)=[EigeneSchule].[Schuljahr]) AND ((SchuelerLernabschnittsdaten.Abschnitt)=[EigeneSchule].[SchuljahrAbschnitt]));"; OleDbDataReader r = DB.Query(stm, 100); string[] header = new string[] { "id", "student_givenname", "student_surname", "class", "grade" }; req.StatusCode = 200; if (format == Pink.MIME.CSV) { req.ContentType = Pink.MIME.CSV; Pink.CSV.Write(r, req.Output, SEP, header, ean); } else { req.ContentType = Pink.MIME.JSON; Pink.JSON.Write(r, req.Output, header, ean); } r.Close(); return; }