public static DataTable EseguiSQLDataTable(string sql, DbParameter[] param, DataColumn[] colonne = null) { var t = new DataTable(); if (colonne != null) { t.Columns.AddRange(colonne); } using (var cm = CreaCommandNoConnection(sql, param)) { if (DataBaseAttuale == DataBase.Access) { using (var a = new System.Data.OleDb.OleDbDataAdapter((System.Data.OleDb.OleDbCommand)cm)) a.Fill(t); } else if (DataBaseAttuale == DataBase.SQLite) #if __MonoCS__ { using (var a = new Mono.Data.Sqlite.SqliteDataAdapter((Mono.Data.Sqlite.SqliteCommand)cm)) a.Fill(t); } #else { using (var a = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cm)) a.Fill(t); } #endif } return(t); }
public static void Main(string[] args) { Mono.Data.Sqlite.SqliteConnection v_con = null; Mono.Data.Sqlite.SqliteDataAdapter v_adapter = null; System.Data.DataTable v_table; Console.WriteLine("Exemplo SQLite usando DataAdapter"); Console.WriteLine(); try { // 1) instanciando Connection v_con = new Mono.Data.Sqlite.SqliteConnection( "Data Source=../../../databases/lugares.db;Version=3;Synchronous=Full;Journal Mode=Off;" ); // 2) abrindo Connection v_con.Open(); // 3) instanciando DataAdapter v_adapter = new Mono.Data.Sqlite.SqliteDataAdapter("select * from estados", v_con); // 4) instanciando DataTable v_table = new System.Data.DataTable("RESULTADO"); // 5) alimentando DataTable v_adapter.Fill(v_table); // 6) usando DataTable (imprimindo na tela) foreach (System.Data.DataColumn c in v_table.Columns) Console.Write("{0} ", c.ColumnName); Console.WriteLine(); foreach (System.Data.DataRow r in v_table.Rows) { foreach (System.Data.DataColumn c in v_table.Columns) Console.Write("{0} ", r[c].ToString()); Console.WriteLine(); } } catch (Mono.Data.Sqlite.SqliteException ex) { Console.WriteLine(ex.ToString()); } finally { // 7) fechando e liberando Connection if (v_con != null) { v_con.Close(); v_con = null; } } Console.ReadKey(); }
public SqliteCommandBuilder(Mono.Data.Sqlite.SqliteDataAdapter adp) { }