ASP.NET连接 Access数据库的几种方法

<?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>

<?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>

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();}}}}