asp.net操作access数据库

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\your\database.mdb";
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
    conn.Open();
    // 进行数据库操作
}

string sql = "SELECT * FROM Customers WHERE CustomerID = ?";
using (OleDbCommand cmd = new OleDbCommand(sql, conn))
{
    cmd.Parameters.AddWithValue("@CustomerID", "ALFKI");
    using (OleDbDataReader reader = cmd.ExecuteReader())
    {
        while (reader.Read())
        {
            // 处理数据
        }
    }
}

using System;
using System.Data.OleDb;
using System.Web.UI;

public partial class Default : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\your\database.mdb";
        using (OleDbConnection conn = new OleDbConnection(connectionString))
        {
            conn.Open();
            string sql = "SELECT * FROM Customers";
            using (OleDbCommand cmd = new OleDbCommand(sql, conn))
            {
                using (OleDbDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string customerId = reader["CustomerID"].ToString();
                        string companyName = reader["CompanyName"].ToString();
                        Response.Write($"Customer ID: {customerId}, Company Name: {companyName}<br/>");
                    }
                }
            }
        }
    }
}