public SQLiteCommand(String commandText, SQLiteConnection connection) : this(commandText) { if (connection == null) throw new ArgumentNullException("Connection is null."); Connection = connection; }
internal SQLiteTransaction(SQLiteConnection connection) { _Connection = connection; if (_Connection == null) throw new ArgumentNullException("Connection cannot be null."); Execute("BEGIN"); }
private void Form1_Load(object sender, EventArgs e) { _Connection = new SQLiteConnection("Data Source=test1.db;NewDatabase=True;Synchronous=Off;Encoding=UTF8;Emulator=true"); _Connection.Open(); InitializeTables(); SQLiteCommand cmd = _Connection.CreateCommand(); cmd.CommandText = "select id, items, customer, amount from orders"; DataTable table = new DataTable(); table.Columns.Add("Id"); table.Columns.Add("Items"); table.Columns.Add("Customer"); table.Columns.Add("Amount"); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DataRow row = table.NewRow(); row["Id"] = reader.GetInt32(0); row["Items"] = reader.GetInt32(1); row["Customer"] = reader.GetString(2); row["Amount"] = reader.GetDouble(3); table.Rows.Add(row); } dataGridView1.DataSource = table; }
private void Form1_Load(object sender, EventArgs e) { _Connection = new SQLiteConnection("Data Source=\\Program Files\\sqlitetest\\test.db;NewDatabase=True;Synchronous=Off;Encoding=UTF8"); _Connection.Open(); }
public BelugaDb() { _Connection = new SQLiteConnection("Data Source=" + DATA_PATH + @"\db\beluga.db;NewDatabase=False;Synchronous=Off;Encoding=UTF8"); }
private void Form1_Load(object sender, EventArgs e) { _Connection = new SQLiteConnection("Data Source=c:\\data\\redfivelabs\\temp\\SQLiteTest.sqlite;NewDatabase=True;Synchronous=Off;Encoding=UTF8;Emulator=false"); _Connection.Open(); }