如何在web.config里面写数据库的连接

来源：互联网发布：淘宝产品如何排名靠前编辑：程序博客网时间：2024/06/04 19:32

1.你可以在WEB.CONFIG里写
<configuration>

<appSettings>
<add key="ConnectionString" value="server=localhost;uid=sa;password=ssss;database=wwwww" />
</appSettings>
</configuration>

用的时候 System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];

2.可以写在global.aspx.cs里
protected void Session_Start(Object sender, EventArgs e)
  {
   this.sqlConnection = new System.Data.SqlClient.SqlConnection();
   this.sqlConnection.ConnectionString = "data source=127.0.0.1;initial catalog=database;password=123;persist security info=True;user id=sa;workstation id=cpu;packet size=4096";
Session["DBcnnt"]=this.sqlConnection;
  }

用时候去调Session["DBcnnt"]

web.config:
<appSettings>
<add key="Con" value="server=(local);uid=sa;pwd=;database=temp"/>
</appSettings>
.cs:
using System.Configuration;
SqlConnection Con=new SqlConnection(ConfigurationSettings.AppSettings["Con"]);

====================================================================

简单方便。
在VS.net中直接从数据选项卡中添加oledb(sql)connection。就可以了
在程序中根据不同情况可采用以下的方法。
程序中用1
Dim conn As OleDb.OleDbConnectio
Dim connstr As String
constr=“Provider=Microsoft.Jet.OLEDB.4.0;data source=fiofficedbdbglobal.mdb“
conn =new ole.oledbconnection(concstr)
程序中2
Dim conn As OleDb.OleDbConnectio
Dim connstr As String
constr=“Provider=Microsoft.Jet.OLEDB.4.0;data source=“+server.mappath(“.“+“dbdbglobal.mdb“)
conn =new ole.oledbconnection(concstr)
程序中3，添加System.IO
Dim conn As OleDb.OleDbConnection
Dim sr As StreamReader
Dim str As String
str = Server.MapPath(config.txt)
sr = File.OpenText(str)
Dim constr As String
constr = sr.ReadLine
conn = New OleDb.OleDbConnection(constr)
在程序根目录下有一个config.txt的文本文件。文本文件内容如下：
Provider=Microsoft.Jet.OLEDB.4.0;Data source=fiofficedbdbglobal.mdb
程序中4,使用web.config存储数据库连接字符串
在web.config中添加键值。
appSetting
add Key=“constring“
value=“Provider=Microsoft.Jet.OLEDB.4.0;data source=fiofficedbdbglobal.mdb“
appSetting

注意大小写。在程序中添加
Dim conn As OleDb.OleDbConnectio
Dim connstr As String
constr=configurationsetting.appsettings(“constring“)
conn =new ole.oledbconnection(concstr)