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();
}
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=c:\\data\\redfivelabs\\temp\\SQLiteTest.sqlite;NewDatabase=True;Synchronous=Off;Encoding=UTF8;Emulator=false");
_Connection.Open();
}
