I made an app for my PDA and use SQLite as database. I did it as below:
- Added System.Data.SQLite.dll to my REFERENCE
- Added SQLite.Interop.066.DLL , SQLite.Interop.066.exp , SQLite.Interop.066.lib to solution
- Called ref with using System.Data.SQLite;
and my connection string and command string is:
SQLiteConnection con = new SQLiteConnection("Data Source=BSTDB.sqlite;Version=3");
string sqlwrite = "INSERT INTO RR (Serial) VALUES('"+cBox1.Text+"')";
SQLiteCommand cmdwrite = new SQLiteCommand(sqlwrite, con);
con.Open();
cmdwrite.ExecuteNonQuery();
con.Close();
But when I start program, this error occurs:
SQLite error no such table:
Can anyone guide me what is my problem?
Meanwhile, this app is working correct on Windows 7 now.
Aucun commentaire:
Enregistrer un commentaire