SQLite example
System.Data.SQLite.dll
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Copy SQLite.Interop.dll and System.Data.SQLite.dll to your project.
Add reference to System.Data.SQLite.dll.
Form1.Designer.cs
namespace SQLite_example
{
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.button4 = new System.Windows.Forms.Button();
this.panel1 = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.panel1.SuspendLayout();
this.SuspendLayout();
//
// button1
//
this.button1.Location = new System.Drawing.Point(3, 3);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 23);
this.button1.TabIndex = 0;
this.button1.Text = "CreateDB";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(85, 3);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 1;
this.button2.Text = "CreateTable";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Location = new System.Drawing.Point(167, 3);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(75, 23);
this.button3.TabIndex = 2;
this.button3.Text = "Insert";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView1.Location = new System.Drawing.Point(0, 29);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(369, 232);
this.dataGridView1.TabIndex = 3;
//
// button4
//
this.button4.Location = new System.Drawing.Point(248, 2);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(75, 23);
this.button4.TabIndex = 4;
this.button4.Text = "Read";
this.button4.UseVisualStyleBackColor = true;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// panel1
//
this.panel1.Controls.Add(this.button1);
this.panel1.Controls.Add(this.button4);
this.panel1.Controls.Add(this.button2);
this.panel1.Controls.Add(this.button3);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(369, 29);
this.panel1.TabIndex = 5;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(369, 261);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.panel1);
this.Name = "Form1";
this.Text = "as-to.eu::SQLite_example";
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.panel1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Panel panel1;
}
}
Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SQLite;
namespace SQLite_example
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SQLiteConnection.CreateFile("example.db");
}
private void button2_Click(object sender, EventArgs e)
{
try
{
SQLiteConnection con = new SQLiteConnection("Data Source=example.db;Version=3;");
con.Open();
SQLiteCommand command = new SQLiteCommand(con);
command.CommandText = "CREATE TABLE testTable (id INTEGER PRIMARY KEY AUTOINCREMENT, testColumn TEXT NOT NULL)";
command.ExecuteNonQuery();
con.Close();
}
catch(Exception ex)
{
MessageBox.Show("Error:"+ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
SQLiteConnection con = new SQLiteConnection("Data Source=example.db;Version=3;");
con.Open();
SQLiteCommand command = new SQLiteCommand(con);
command.CommandText = "INSERT INTO testTable (testColumn) VALUES('Test one')";
command.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
try
{
SQLiteConnection con = new SQLiteConnection("Data Source=example.db;Version=3;");
con.Open();
SQLiteCommand command = new SQLiteCommand(con);
command.CommandText = "SELECT * FROM testTable";
SQLiteDataReader reader = command.ExecuteReader();
dt.Load(reader);
reader.Close();
con.Close();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.Message);
}
}
}
}
