Trying to connect to accdb database with c# and .NET 4.0

Question

I keep getting an exception when I try to fill the adapter and i can't figure out why. Here is my code. Thank you very much in advance for any information!

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

Can you post what exception you are getting?

Dhwanil Shah
– Dhwanil Shah

2012-02-16 11:36:35 +00:00
Commented Feb 16, 2012 at 11:36 — Dhwanil Shah
– Dhwanil Shah, Commented Feb 16, 2012 at 11:36
Without exception error, is hard to understand!

Angelo Badellino
– Angelo Badellino

2012-02-16 11:38:52 +00:00
Commented Feb 16, 2012 at 11:38 — Angelo Badellino
– Angelo Badellino, Commented Feb 16, 2012 at 11:38

KV Prajapati · Accepted Answer · 2012-02-16 11:35:32Z

1

Try the following connection string. (Close the MS-Access/database file if it is opened)

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

answered Feb 16, 2012 at 11:35

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Edward Specht Over a year ago

Thanks for answering my post! Unfortunately that did not help... I'm getting the following exception at adapter.fill(dataset, "Dishes"): 'The invocation of the constructor on type 'SoBeWFF.MainWindow' that matches the specified binding constraints threw an exception.' Line number '3' and line position '9'.

Collectives™ on Stack Overflow

Trying to connect to accdb database with c# and .NET 4.0

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related