報錯語句:SqliteException: SQLite error no such column:
- 這個坑的核心被丧,是插值時候旧困,字符串兩端必須有"'"即單引號汗唱,否則可能報錯
var mDbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
mDbConnection.Open();
const string sqlPart = @"REPLACE INTO watchList('cloumA', 'cloumB') VALUES ({0},{1})";
//此處需要強(qiáng)調(diào)的是傻唾,cloumA,cloumB必須有"'"存在湃崩,且valueA,valueB作為string插入時候未荒,兩端也必須有"'"即單引號
var sqlWords = string.Format(sqlPart, valueA,valueB);
var command = new SQLiteCommand(sqlWords, mDbConnection);
command.ExecuteNonQuery();
Console.WriteLine("write success");
mDbConnection.Close();