尝试使用C#和.NET 4.0连接到accdb数据库

Trying to connect to accdb database with c# and .NET 4.0(尝试使用C#和.NET 4.0连接到accdb数据库)

问题描述

当我尝试填充适配器时，我总是收到异常，但我找不到原因。这是我的代码。非常感谢您提前提供任何信息！

public partial class MainWindow : Window
{
    private OleDbConnection connection;
    private OleDbCommand command;
    private OleDbDataAdapter adapter;
    private DataSet dataset;

    public MainWindow()
    {
        InitializeComponent();

        connection = new OleDbConnection();
        command = new OleDbCommand();
        adapter = new OleDbDataAdapter();
        dataset = new DataSet();

        connection.ConnectionString =
            @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/SoBeWFF.accdb;" +
            "Persist Security Info=False";

        command.Connection = connection;
        command.CommandText = "SELECT * FROM Dishes";

        adapter.SelectCommand = command;

        try
        {
            adapter.Fill(dataset, "Dishes");
        }
        catch (OleDbException)
        {
            MessageBox.Show("Error occured while connecting to database.");
           // Application.Exit();
        }
    }
}

推荐答案

尝试以下连接字符串。(如果MS-Access/数据库文件已打开，请将其关闭)

connection.ConnectionString =@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:SoBeWFF.accdb";

这篇关于尝试使用C#和.NET 4.0连接到accdb数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！