Web配置连接设置

Question

我已经设计了一个网站，其中每个页面都通过编写每个page....Can中的代码与SQL server连接，任何人帮助我做这项工作只在网络配置文件在一次…

提前感谢..！

Answer 1

请尝试以下操作：

在web配置中：

<connectionStrings>
  <add 
    name="NorthwindConnectionString" 
    connectionString="Data Source=serverName;Initial 
    Catalog=Northwind;Persist Security Info=True;User 
    ID=userName;Password=password"
    providerName="System.Data.SqlClient"
  />
</connectionStrings>

在.cs页面中阅读

System.Configuration.Configuration rootWebConfig =
                System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
            System.Configuration.ConnectionStringSettings connString;
            if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
            {
                connString =
                    rootWebConfig.ConnectionStrings.ConnectionStrings["NorthwindConnectionString"];
                if (connString != null)
                    Console.WriteLine("Northwind connection string = \"{0}\"",
                        connString.ConnectionString);
                else
                    Console.WriteLine("No Northwind connection string");
            }

http://msdn.microsoft.com/en-us/library/ms178411.aspx

Answer 2

<connectionStrings>  
        <add name="ConnectionString" connectionString="Data Source=(local); 
        Initial Catalog=DbName; Integrated Security=True" 
        providerName="System.Data.SqlClient" />
</connectionStrings>

Answer 3

在web.config文件中

    <add name="ConnectionString" connectionString="server=(local); 
database=DbName; uid=*username*; password=*password*;" 
providerName="System.Data.SqlClient" />