Differences

This shows you the differences between two versions of the page.

--- swdev:sqlite:custom_client_in_csharp [2018/07/12 10:48]
smayr [Get Table Schema]
+++ swdev:sqlite:custom_client_in_csharp [2018/07/12 10:52] (current)
smayr [Insert Table Entries]
@@ Line 78: / Line 78: @@
 ==== Insert Table Entries ====
 <code csharp>
-command.CommandText = "INSERT INTO MyTable (Key,Value) VALUES ('key one','value one')";
+string sql = "INSERT INTO MyTable (Key,Value) VALUES ('key one','value one')";
+SQLiteCommand command = new SQLiteCommand(sql, conn);
 command.ExecuteNonQuery();
+Console.WriteLine("NewRecID: " + conn.LastInsertRowId);
 </code>