连接Access 数据库

涉及到三个文件

1. web.config

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 <appSettings>
  <add key="strConn" value="App_Data/mainData#.mdb"/>
  <add key="siteName" value="第一师范"/>
 </appSettings>
 <connectionStrings/>
</configuration>

2.显示数据页面 testRead.aspx

<asp:GridView ID="GridView1" runat="server">
 </asp:GridView>

3.Code Behind 文件 testRead.aspx.cs

using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class admin_block_testRead : System.Web.UI.Page
{
    string strConn = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("~/"+ConfigurationManager.AppSettings["StrConn"]);
        if(!IsPostBack)     { Data_Binding(); }
   
        }
    private void Data_Binding()
    {
        this.GridView1.DataSource = GetData();
        this.GridView1.DataBind();
   
    }
    private DataTable GetData()
    {   OleDbConnection conn = new OleDbConnection(strConn);
        string strSql = "select * from siteBlock";
        OleDbDataAdapter objDa = new OleDbDataAdapter(strSql, conn);
        DataSet objDs = new DataSet();       
        objDa.Fill(objDs);
        return objDs.Tables[0];
    }
}