public void PrepareLoop(long fid)
{
adp = new SQLiteDataAdapter();
trans = sql.BeginTransaction();
command.Transaction = trans;
command.CommandText = "SELECT * FROM tgi WHERE 1 = 2";
bld = fact.CreateCommandBuilder();
bld.DataAdapter = adp;
adp.SelectCommand = command;
adp.InsertCommand = (SQLiteCommand)((ICloneable)bld.GetInsertCommand()).Clone();
bld.DataAdapter = null;
tbl = new DataTable("tgi");
adp.Fill(tbl);
}
private DatabaseManager()
{
this.db_last_msg = string.Empty;
this.sql_conn = new SQLiteConnection(sql_conn_str);
this.sql_adapter = new SQLiteDataAdapter(sql_adapter_str, this.sql_conn);
this.sql_adapter.ContinueUpdateOnError = true; // Ignore errors on failed row update
// Create SQLite command builder for data adapter
SQLiteFactory sql_factory = new SQLiteFactory();
SQLiteCommandBuilder sql_builder = (SQLiteCommandBuilder)sql_factory.CreateCommandBuilder();
sql_builder.SetAllValues = false;
sql_builder.DataAdapter = this.sql_adapter;
this.sql_conn.Open();
}
