.netaccess数据库操作类

using System;
using System.Data;
using System.Data.OleDb;

public class AccessDatabaseHelper
{
    private string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\path\\to\\your\\database.mdb";

    public DataTable ExecuteQuery(string sql)
    {
        DataTable result = new DataTable();
        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();
            using (OleDbCommand command = new OleDbCommand(sql, connection))
            {
                using (OleDbDataReader reader = command.ExecuteReader())
                {
                    result.Load(reader);
                }
            }
        }
        return result;
    }
}

// 使用示例
public class Program
{
    public static void Main()
    {
        AccessDatabaseHelper dbHelper = new AccessDatabaseHelper();
        string sql = "SELECT * FROM YourTable";
        DataTable data = dbHelper.ExecuteQuery(sql);
        foreach (DataRow row in data.Rows)
        {
            Console.WriteLine(row["ColumnName"]);
        }
    }
}