public void InsertData(DeviceUserSqliteObject data)
{
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
cmdInsert.CommandText = string.Format("INSERT INTO {0} VALUES({1})",
TableName, data.ValuesTableToString());
cmdInsert.ExecuteNonQuery();
}
public SqliteUtil()
{
Datas = new List <DeviceUserSqliteObject>();
conn = null;
string dbPath = "Data Source =" + Environment.CurrentDirectory +
"/" + DatabaseName + ".db";
conn = new SQLiteConnection(dbPath); //创建数据库实例，指定文件位置
conn.Open(); //打开数据库，若文件不存在会自动创建
var data = new DeviceUserSqliteObject();
string sql = string.Format("CREATE TABLE IF NOT EXISTS {0}({1});",
TableName, data.CreateTableToString());//建表语句
SQLiteCommand cmdCreateTable = new SQLiteCommand(sql, conn);
cmdCreateTable.ExecuteNonQuery();//如果表不存在，创建数据表
}
