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

web.config

第一种方法：

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

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

以上所述是小编给大家介绍的asp.net连接 access数据库的几种方法，希望对大家有所帮助