web.config
第一種方法：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?xml version="1.0" encoding="utf-8"?><!--有關(guān)如何配置 ASP.NET 應(yīng)用程序的詳細(xì)消息，請(qǐng)?jiān)L問(wèn)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> |
第二種方法：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<?xml version="1.0" encoding="utf-8"?><!--有關(guān)如何配置 ASP.NET 應(yīng)用程序的詳細(xì)消息，請(qǐng)?jiān)L問(wèn)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> |
后臺(tái) aspx.CS
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
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 = "數(shù)據(jù)庫(kù)連接成功！";}catch (Exception ee){this.Label1.Text = ee.ToString();}}}} |
以上所述是小編給大家介紹的ASP.NET連接 Access數(shù)據(jù)庫(kù)的幾種方法，希望對(duì)大家有所幫助，如果大家有任何疑問(wèn)請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)服務(wù)器之家網(wǎng)站的支持！
原文鏈接：http://www.cnblogs.com/tiger8000/archive/2012/01/03/2310936.html
