string path = “你的sqlite路径”;
SQLiteConnection cn = new SQLiteConnection(“Data Source=” + path);
cn.Open();
SQLiteCommand cmd = new SQLiteCommand();
cmd.Connection = cn;
#开启事务
System.Data.Common.DbTransaction trans = cn.BeginTransaction();
#创建表
cmd.CommandText = “CREATE TABLE IF NOT EXISTS 表名()”;
cmd.ExecuteNonQuery();
#插入数据
cmd.CommandText = “INSERT INTO suddle1(id) VALUES(@id)”;
cmd.ExecuteNonQuery();
trans.Commit();
cn.Close();