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)
{
}
