SQLite问题 [英] SQLite problem

问题描述

所以我在这里运行了该程序:

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();


}

它应该在列名和列号的toma表中插入toma12和123，之后我将值更改为文本框.我在fiefox sqlite管理器中创建了一个sqlite数据库，它运行良好.我让数据库创建了表，运行了一些查询，插入了一些数据并列出了它们，以便可以查看它是否有效.我工作了现在，我将Visual Studio与该数据库连接.在服务器资源管理器中，我可以看到该数据库和该表.但是当我运行此代码时，它说:SQLite错误
没有这样的表:toma.请帮助.

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.

推荐答案

检查您的toma表和用户的模式

Check the schema of your toma table and your user

这篇关于SQLite问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！