1 using System;
 2 using System.Collections.Generic;
 3 using System.ComponentModel;
 4 using System.Data;
 5 using System.Drawing;
 6 using System.Linq;
 7 using System.Text;
 8 using System.Windows.Forms;
 9 using System.Data.SQLite;
10 
11 namespace SqliteTest
12 {
13     public partial class Form1 : Form
14     {
15 
16         private string dataSource = "TestDB.sqlite";
17         private SQLiteConnection dbConn;
18 
19         public Form1()
20         {
21             InitializeComponent();
22         }
23 
24         private void btnCreateDatabase_Click(object sender, EventArgs e)
25         {
26             SQLiteConnection.CreateFile(dataSource);
27             btnCreateDatabase.Text = "数据库创建完成";
28             dbConn = new SQLiteConnection("Data Source=" + dataSource);
29         }
30 
31         private void btnCreateTable_Click(object sender, EventArgs e)
32         {
33             dbConn.Open();
34 
35             SQLiteCommand dbCmd = dbConn.CreateCommand();
36 
37             dbCmd.CommandText = "CREATE TABLE tabname (id varchar(20) ,dogname varchar(30), mousename varchar(20))";
38 
39 
40             dbCmd.ExecuteNonQuery();
41 
42             dbConn.Close();
43 
44             btnCreateTable.Text = "表格创建完成";
45         }
46 
47         private void btnInsert_Click(object sender, EventArgs e)
48         {
49             dbConn.Open();
50             SQLiteCommand dbCmd = dbConn.CreateCommand();
51             dbCmd.CommandText = "INSERT INTO tabname VALUES(‘20投‘ , ‘沙漠死神‘  ,‘图奇‘)";
52 
53             dbCmd.ExecuteNonQuery();
54             dbConn.Close();
55             btnInsert.Text = "插入成功";
56         }
57 
58         private void btnShow_Click(object sender, EventArgs e)
59         {
60             dbConn.Open();
61             SQLiteCommand dbCmd = dbConn.CreateCommand();
62             dbCmd.CommandText = "SELECT * FROM tabname";
63             SQLiteDataReader dataReader = dbCmd.ExecuteReader();
64 
65             DataTable dataTable = new DataTable();
66 
67             if (dataReader.HasRows)
68             {
69 
70                 dataTable.Load(dataReader);
71 
72             }
73 
74             dgvShow.DataSource = dataTable;
75 
76             dataReader.Close();
77             dbCmd.Dispose();
78             dbConn.Close();
79             btnShow.Text = "显示成功";
80         }
81     }
82 }