SQLite连接在C＃中不起作用 [英] SQLite Connection not working in C#

问题描述

我正在使用处理SQLite数据库的C＃应用​​程序，直到昨天工作正常，正在检索记录，

I was working with C# Application that manipulates a SQLite Database , Till yesterday It was working fine, It was retrieving records,

但是从昨晚开始，连接字符串返回了数据源= null

But since last night, Connection String returns Data Source = null

下面是测试代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;

namespace SQLiteTest
{
    public partial class Form1 : Form
    {
        //string connection_string = "Data Source=UrduDictionary";
        string connection_string = "Data Source=" + Environment.CurrentDirectory + "\\Test.sqlite";
        string query = "";
        private SQLiteConnection _connection;
        private SQLiteCommand _command;
        private SQLiteDataAdapter _adapter;
        DataSet local;
        public Form1()
        {
            InitializeComponent();
        }
    void Make_Connection()
    {
        _connection = new SQLiteConnection(connection_string);
    }
    private void button1_Click(object sender, EventArgs e)
    {                 
         Make_Connection();
    }

}

}

下面是在监视窗口中的调试过程中看到的图像。

Below is the image what have seen during Debug in Watch Window..

我正在使用的库 SQLite-1.0.66.0-setup.exe

我已经对创建的其他数据库进行了测试，但结果相同，任何机构都可以提供帮助？

I have tested with other Database created but same results, Any body can help?

推荐答案

我所做的：

private void button2_Click(object sender, EventArgs e)
{
    string dbPath = Path.Combine(Environment.CurrentDirectory, "UrduDictionary");
    string connString = string.Format("Data Source={0}", dbPath);

    using (SQLiteConnection conn = new SQLiteConnection(connString))
    {
        StringBuilder query = new StringBuilder();
        query.Append("SELECT * ");
        query.Append("FROM CATIGORY_TABLE ");

        using (SQLiteCommand cmd = new SQLiteCommand(query.ToString(), conn))
        {
            conn.Open();

            using (SQLiteDataReader dr = cmd.ExecuteReader())
            {
                while (dr.Read())
                {
                    Console.WriteLine("{0} {1} {2}",
                        dr.GetValue(0),
                        dr.GetValue(1),
                        dr.GetValue(2));
                }
            }
        }
    }
}

这篇关于SQLite连接在C＃中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！