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"?><!--有关如何配置 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> |
第二种方法：
|
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"?><!--有关如何配置 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
|
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 = "数据库连接成功！";}catch (Exception ee){this.Label1.Text = ee.ToString();}}}} |
以上所述是小编给大家介绍的ASP.NET连接 Access数据库的几种方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：http://www.cnblogs.com/tiger8000/archive/2012/01/03/2310936.html
