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