在VS2017的C#中打开SQLite数据库

using System.Data.SQLite;

string connectionString = "Data Source=path_to_database_file";

using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
    connection.Open();
    // 在此处执行数据库操作
}

// 创建并执行查询语句
string query = "SELECT * FROM table_name";
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
    using (SQLiteDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // 处理查询结果
        }
    }
}

// 插入数据
string insertQuery = "INSERT INTO table_name (column1, column2) VALUES (@value1, @value2)";
using (SQLiteCommand insertCommand = new SQLiteCommand(insertQuery, connection))
{
    insertCommand.Parameters.AddWithValue("@value1", value1);
    insertCommand.Parameters.AddWithValue("@value2", value2);
    insertCommand.ExecuteNonQuery();
}

// 更新数据
string updateQuery = "UPDATE table_name SET column1 = @value1 WHERE column2 = @value2";
using (SQLiteCommand updateCommand = new SQLiteCommand(updateQuery, connection))
{
    updateCommand.Parameters.AddWithValue("@value1", value1);
    updateCommand.Parameters.AddWithValue("@value2", value2);
    updateCommand.ExecuteNonQuery();
}

connection.Close();