web.config
1
<?xmlversion="1.0"encoding="utf-8"?>
<!--
有关如何配置应用程序的详细消息，请访问
/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=xp)(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>
2
<?xmlversion="1.0"encoding="utf-8"?>
<!--
有关如何配置应用程序的详细消息，请访问
/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();
}
}
}
}
connStr1 ,connStr2 ，connStr3
用这三个连接字符串哪 个都可以。
