在ASP.NET中连接 Access数据库的方法

这篇文章将为大家详细讲解有关在ASP.NET中连接 Access数据库的方法，文章内容质量较高，因此小编分享给大家做个参考，希望大家阅读完这篇文章后对相关知识有一定的了解。

web.config

第一种方法：

<?xmlversion="1.0"encoding="utf-8"?>
<!--
有关如何配置ASP.NET应用程序的详细消息，请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<appSettings>
<addkey="AccessConnString"value="provider=microsoft.jet.oledb.4.0;datasource="/>
<addkey="AccessDbPath"value="~/App_Data/guestbook.mdb"/>
</appSettings>
<connectionStrings>
<addname="AccessConnectionString"connectionString="Provider=Microsoft.Jet.OleDb.4.0;DataSource="providerName="System.Data.OleDb"/>
<addname="Access_Path"connectionString="~/App_Data/guestbook.mdb"/>
<addname="SqlConnectionString"connectionString="DataSource=localhost;InitialCatalog=guestbook;UserID=sa;password=123456;"providerName="System.Data.SqlClient"/>
<addname="OracleConnectionString"connectionString="DataSource=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xp2008)(PORT=1521)))(CONNECT_DATA=(SID=guandb)(SERVER=DEDICATED)));UserID=system;Password=k2763826;Unicode=True"providerName="System.Data.OracleClient"/>
</connectionStrings>
<system.web>
<compilationdebug="true"targetFramework="4.0"/>
</system.web>
</configuration>

第二种方法：

<?xmlversion="1.0"encoding="utf-8"?>
<!--
有关如何配置ASP.NET应用程序的详细消息，请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<appSettings>
<addkey="AccessConnString"value="provider=microsoft.jet.oledb.4.0;datasource="/>
<addkey="AccessDbPath"value="~/App_Data/guestbook.mdb"/>
</appSettings>
<connectionStrings>
<addname="AccessConnectionString"connectionString="Provider=Microsoft.Jet.Oledb.4.0;datasource="/>
<addname="Access_Path"connectionString="~/App_Data/guestbook.mdb"/>
<addname="SqlConnectionString"connectionString="DataSource=localhost;InitialCatalog=HuaRunDb;UserID=sa;password=123456;"providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilationdebug="true"targetFramework="4.0"/>
</system.web>
</configuration>

后台 aspx.CS

usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.Configuration;
usingSystem.Configuration;
usingSystem.Data.OleDb;
usingSystem.Data;
namespaceTestOracle
{
publicpartialclassTestConnect:System.Web.UI.Page
{
publicstaticreadonlystringconnStr1=System.Web.Configuration.WebConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString+HttpContext.Current.Server.MapPath(WebConfigurationManager.ConnectionStrings["Access_Path"].ConnectionString);
publicstaticreadonlystringconnStr2=System.Configuration.ConfigurationManager.AppSettings["AccessConnString"].ToString()+System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["AccessDbPath"])+";";
publicstaticreadonlystringconnStr3="Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+HttpContext.Current.Server.MapPath("~/App_Data/guestbook.mdb");
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
OleDbConnectionconn=newOleDbConnection(connStr1);
try
{
conn.Open();
stringsql="select*fromGtContent";
OleDbDataAdaptermyadapter=newOleDbDataAdapter(sql,conn);
DataSetds=newDataSet();
myadapter.Fill(ds);
this.GridView1.DataSource=ds;
this.GridView1.DataBind();
this.Label1.Text="数据库连接成功！";
}
catch(Exceptionee)
{
this.Label1.Text=ee.ToString();
}
}
}
}

关于在ASP.NET中连接 Access数据库的方法就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。