Click here to Skip to main content
15,895,794 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
So i got here this program runing:

{
    SQLiteConnection ObjConnection = new SQLiteConnection("Data Source=C:toma.sqlite;");
    SQLiteCommand ObjCommand = new SQLiteCommand("INSERT into toma (name,number) VALUES('toma12','123')", ObjConnection);
    ObjConnection.Open();
    ObjCommand.ExecuteNonQuery();
    ObjConnection.Clone();


}

it should insert toma12 and 123 into the toma table in the column name and number,later in i change the values to text boxes. I created an sqlite database in fiefox sqlite manager it worked fine. I made the database created the table, runed some queries i inserted some data and listed them so i can see if it works. I did work. Now i connected Visual Studio with that db. In the server explorer i can see that DB and the table. but when i run this code it says:SQLite error
no such table: toma. Help please.
Posted

1 solution

Check the schema of your toma table and your user
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900