An error in SQLite
C#
1
Posts
1
Posters
0
Views
1
Watching
-
I use this code in a button to save data into a SQLite file:
//path of data base
string conString = @"URI=file:" + Application.StartupPath + "\\DataBase.db"; //database created in debug folder
cmd.CommandText = "INSERT INTO FileInfo(EqpCode, EqpName, FileName) VALUES(@EqpCode, @EqpName, @FileName)";
SQLiteConnection con = new SQLiteConnection(conString);
SQLiteCommand cmd = new SQLiteCommand(con);con.Open(); for (int i = 0; i < myTable02.Rows.Count; i++) { string EqpCode = myTable02.Rows\[i\]\[0\].ToString(); string EqpName = myTable02.Rows\[i\]\[1\].ToString(); string FileName = myTable02.Rows\[i\]\[2\].ToString(); cmd.Parameters.AddWithValue(@EqpCode, EqpCode); cmd.Parameters.AddWithValue(@EqpName, EqpName); cmd.Parameters.AddWithValue(@FileName, FileName); cmd.ExecuteNonQuery(); }
con.Close();
The error is thrown in cmd.ExecuteNonQuery() line: System.Data.SQLite.SQLiteException: 'unknown error Insufficient parameters supplied to the command' Please help me.