网页与access数据库连接

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

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

    public DataTable GetDataTable(string sql)
    {
        DataTable dt = new DataTable();
        using (OleDbConnection conn = new OleDbConnection(connectionString))
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
            adapter.Fill(dt);
        }
        return dt;
    }

    public int ExecuteNonQuery(string sql)
    {
        int result = 0;
        using (OleDbConnection conn = new OleDbConnection(connectionString))
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            result = cmd.ExecuteNonQuery();
        }
        return result;
    }
}