SQLite 3 杂记

1、如何得到最后插入项的自动增长ID值？ 对应的C#代码段如下：

using (SQLiteConnection cn = new SQLiteConnection (“data source = Test.db”))
{
      cn.Open ();

      SQLiteCommand cmd = new SQLiteCommand ("INSERT INTO TestTable VALUES (NULL, ‘TestString’); SELECT last_insert_rowid ()",  cn);
      int NewID = Convert.ToInt32 (cmd.ExecuteScalar ());

      cn.Close ();
}

NewID值为0表示插入未成功。 2、如何将查询结果直接保存到表？ 保存到表之前，首先将表清空。对应的C#代码段如下：

using (SQLiteConnection cn = new SQLiteConnection (“data source = Test.db”))
{
      cn.Open ();

      SQLiteCommand cmd = new SQLiteCommand ("DELETE from TestTable; INSERT INTO TestTable SELECT ID, Name from TestTable",  cn);
      cmd.ExecuteNonQuery ();

      cn.Close ();
}