?

web.config

1

?

<?xml?version="1.0"?encoding="utf-8"?>

<!--
??有關如何配置?ASP.NET?應用程序的詳細消息，請訪問
??http://go.microsoft.com/fwlink/?LinkId=169433
??-->

<configuration>
??<appSettings>
????<add?key="AccessConnString"?value="provider=microsoft.jet.oledb.4.0;data?source="/>
????<add?key="AccessDbPath"?value="~/App_Data/guestbook.mdb"/>
??</appSettings>
??<connectionStrings>
????<add?name="AccessConnectionString"??connectionString="Provider=Microsoft.Jet.OleDb.4.0;Data?Source="?providerName="System.Data.OleDb"/>
????<add?name="Access_Path"?connectionString="~/App_Data/guestbook.mdb"/>
????<add?name="SqlConnectionString"?connectionString="Data?Source=localhost;Initial?Catalog=guestbook;User?ID=sa;password=123456;"?providerName="System.Data.SqlClient"/>
????<add?name="OracleConnectionString"?connectionString="Data?Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xp2008)(PORT=1521)))(CONNECT_DATA=(SID=guandb)(SERVER=DEDICATED)));User?ID=system;Password=k2763826;Unicode=True"?providerName="System.Data.OracleClient"/>
??</connectionStrings>
??<system.web>
????????<compilation?debug="true"?targetFramework="4.0"?/>
????</system.web>

</configuration>

?

?

2

?

<?xml?version="1.0"?encoding="utf-8"?>

<!--
??有關如何配置?ASP.NET?應用程序的詳細消息，請訪問
??http://go.microsoft.com/fwlink/?LinkId=169433
??-->

<configuration>
??<appSettings>
????<add?key="AccessConnString"?value="provider=microsoft.jet.oledb.4.0;data?source="/>
????<add?key="AccessDbPath"?value="~/App_Data/guestbook.mdb"/>
??</appSettings>
??<connectionStrings>
????<add?name="AccessConnectionString"?connectionString="Provider=Microsoft.Jet.Oledb.4.0;data?source="/>
????<add?name="Access_Path"?connectionString="~/App_Data/guestbook.mdb"/>
????<add?name="SqlConnectionString"?connectionString="Data?Source=localhost;Initial?Catalog=HuaRunDb;User?ID=sa;password=123456;"?providerName="System.Data.SqlClient"/>
??</connectionStrings>
??<system.web>
????????<compilation?debug="true"?targetFramework="4.0"?/>
????</system.web>

</configuration>

?

?

后臺 aspx.CS

?

?

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.Configuration;
using?System.Configuration;
using?System.Data.OleDb;
using?System.Data;

namespace?TestOracle
{
????public?partial?class?TestConnect?:?System.Web.UI.Page
????{
????????public?static?readonly?string?connStr1?=?System.Web.Configuration.WebConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString+?HttpContext.Current.Server.MapPath(WebConfigurationManager.ConnectionStrings["Access_Path"].ConnectionString);
????????public?static?readonly?string?connStr2?=?System.Configuration.ConfigurationManager.AppSettings["AccessConnString"].ToString()?+?System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["AccessDbPath"])?+?";";
????????public?static?readonly?string?connStr3?=?"Provider?=?Microsoft.Jet.OLEDB.4.0?;Data?Source="?+?HttpContext.Current.Server.MapPath("~/App_Data/guestbook.mdb");
????????protected?void?Page_Load(object?sender,?EventArgs?e)
????????{

????????}

????????protected?void?Button1_Click(object?sender,?EventArgs?e)
????????{
????????????OleDbConnection?conn?=?new?OleDbConnection(connStr1);
????????????try
????????????{
????????????????conn.Open();
????????????????string?sql?=?"select?*?from?GtContent";
????????????????OleDbDataAdapter?myadapter?=?new?OleDbDataAdapter(sql,?conn);
????????????????DataSet?ds?=?new?DataSet();
????????????????myadapter.Fill(ds);

????????????????this.GridView1.DataSource?=?ds;
????????????????this.GridView1.DataBind();
????????????????this.Label1.Text?=?"數據庫連接成功！";
????????????}
????????????catch?(Exception?ee)
????????????{
????????????????this.Label1.Text?=?ee.ToString();
????????????}



????????}
????}
}

?

?

connStr1 ,connStr2 ，connStr3

用這三個連接字符串哪 個都可以。

轉載于:https://www.cnblogs.com/tiger8000/archive/2012/01/03/2310936.html

總結

以上是生活随笔為你收集整理的asp.net 连接 Access 的几种方法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。