Breaking News: Grepper is joining You.com. Read the official announcement!

c# read access database without oledb

SubZero answered on March 5, 2023 Popularity 2/10 Helpfulness 8/10

answer c# read access database without oledb

c# read access database without oledb

Comment

To read an Access database without using OleDb, you can use the Microsoft Access Database Engine (ACE) driver. Here's an example of how to do it:

1- First, make sure you have the ACE driver installed on your system. You can download it from the Microsoft website.

2- Add a reference to the Microsoft.Office.Interop.Access.Dao assembly.

Use the following code to read data from an Access database:

using System.Collections.Generic;
using Microsoft.Office.Interop.Access.Dao;

public List<string> ReadAccessData(string databasePath, string tableName, string fieldName)
{
    List<string> result = new List<string>();

    // Create a DAO DBEngine object
    var dbEngine = new DBEngine();

    // Open the database
    var database = dbEngine.OpenDatabase(databasePath);

    // Open the table
    var table = database.TableDefs[tableName];

    // Get the field index
    var fieldIndex = table.Fields[fieldName].OrdinalPosition - 1;

    // Open the recordset
    var recordset = table.OpenRecordset();

    // Loop through the recordset and add the data to the result list
    while (!recordset.EOF)
    {
        result.Add(recordset.Fields[fieldIndex].Value.ToString());
        recordset.MoveNext();
    }

    // Close the recordset and the database
    recordset.Close();
    database.Close();

    return result;
}

//You can then call this method like this:
var data = ReadAccessData(@"C:\path\to\database.accdb", "MyTable", "MyField");

This will return a list of strings containing the data from the specified field in the specified table.

Popularity 2/10 Helpfulness 8/10 Language csharp

Source: Grepper

Tags: c# database oledb read-access

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

c# read access database without oledb

Contents

More Related Answers

c# read access database without oledb

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.