連接配接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];

    }

}