sqlite中这个错误的含义是什么？ [英] what's the meaning of this error in sqlite ?

问题描述

您好。

有人可以帮我理解这个奇怪的sqlite错误的含义及其原因是什么？

它在C＃

和这里我的C＃代码。

Hi.
Can someone please help me to understand the meaning of this peculiar sqlite error and what's the cause of it ?
it's in C#
and here's my C# code.

try
            {
                string query = @"insert into tbl (pkey, field)
                            values (@_pkey, @_txt);";

                string conString = @"Data Source = \testdb.s3db; version = 3;";
                SQLiteConnection con = new SQLiteConnection(conString);
                con.Open();
                SQLiteCommand cmd = new SQLiteCommand(query, con);
                cmd.Parameters.Add("@_pkey", System.Data.DbType.Int32).Value = 10;
                cmd.Parameters.AddWithValue("@_txt", "hello world");
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            { Console.WriteLine(ex.Message); }

但是当我点击运行时，它会在cmd中显示。

But when I click the run, it displays this in the cmd.

SQL logic error or missing database
no such table: tbl
Press any key to continue . . .

我确定有一个数据库和一个适合查询的表格。

我试过更改表名。



这有什么问题？



提前致谢。

And Im dead sure that there's a database and a table which fits the queries.
I tried changing the table name.

What's the wrong with this ?

Thanks in advance.

推荐答案

您的连接字符串可能有问题...尝试

Your connection string is probably at fault ... try

string conString = @"Data Source = c:\myFolder\testdb.s3db; version=3;";

用数据库的实际路径替换 c：\ myFolder

replacing c:\myFolder with the actual path to the database

这篇关于sqlite中这个错误的含义是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！