怎么在web.config 中实现对SQL server 的连接?

Question

例如：
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings> <add key="ConnectionString" value="driver={SQL Server};server=192.168.0.1;uid=sa;pwd=sa;database=test;" /> 
<!-- 数据库连接字符串 -->

</appSettings></configuration>

Answer 1

<appSettings>
        <add key="ConnectionString" value="initial catalog=databasename;persist security info=False;user id=sa;password=;Data Source=servernameorIP;packet size=4096" />
    </appSettings>读取：
using System.Configuration;string connString = ConfigurationSettings.AppSetting["ConnectionString"];

Answer 2

在倒数第二行加： 
<appSettings>
  <add key="ServiceName" value="OK"/>//VALUE=机器名 </appSettings>

Answer 3

<appSettings>
<add key="ConnectionString" value="User ID=sa;PWD=xxxx;Data Source=Catter;Initial Catalog=DataBase" 
</appSettings> 
 string strconn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]；