1.Access数据库
web.config文件:
<appSettings>
<add key="DBPath" value="database/test.mdb" />
<add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="/>
</appSettings>
test.aspx.cs文件:
string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] + Server.MapPath(strDBPath);
OleDbConnection myConnection = new OleDbConnection(strConn);
2.Sql Server数据库
web.config文件:
<appSettings>
<add key="Conntction" value="server=localhost;uid=sa;pwd=system;database=test"/>
</appSettings>
test.aspx.cs文件:
string strConn = "server=localhost;uid=sa;pwd=system;database=test";
SqlConnection myConnection = new SqlConnection(strConn);