SQLite3

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 ();
}