Question

C#中在Web.Config中配置数据库联接写在哪能个地方？

<configuration>
<appSettings/>
<connectionStrings>
</connectionStrings>搞不清写在哪个地方。

Answer 1

两个地方都可以写的，只不过读的时候有点不太一样。
一般都会放到
<connectionStrings>
<add/>
</connectionStrings>
里面

Answer 2

<appSettings/>
<connectionStrings>
这两个都行

<appSettings>
<add key="ConnectionString" value="Data Source=.;Initial Catalog=master;User ID=sa;Password=123"/>
</appSettings>

Answer 3

asp.net 2.0
<connectionStrings>
<add name="qxConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\wwwroot\qx\App_Data\personBase.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
asp.net 1.0
<add key ="qxConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\wwwroot\qx\App_Data\personBase.mdb"
providerName="System.Data.OleDb"/>

你只要把dataSource改成你的数据库文件在的路径就行了

Answer 4

在<connectionStrings>里面

<connectionStrings>
<add name="Data1" connectionString="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;" />
</connectionStrings>

Answer 5

读取webconfig里面的appSetting和connectionString
<appSettings>
<add key="SiteURL" value="http://moss2007:7000" />
<add key="WebURL" value="" />
</appSettings>
在页面读取： private string siteUrl = ConfigurationManager.AppSettings["SiteURL"];
<connectionStrings>
<!--<add name="LogDBConn" connectionString="Data Source=IP;Initial Catalog=* ;User ID=sa;Password=*"/>-->
<add name="LogDBConn" connectionString="Data Source=*

" />
</connectionStrings>

在页面读取：string strLogDBConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["LogDBConn"].ToString();

Answer 6

<appSettings>
<add key="yourStr" value="server=.;database=test;uid=sa;pwd=sa"></add>
</appSettings>

SqlConnection con=new SqlConnection(ConfigurationSettings.AppSettings["yourStr"]);