Web.config-Visual Studio 2010 Pro vs 2015社区 [英] Web.config - Visual Studio 2010 Pro vs 2015 Community

问题描述

你好

我当前在VS 2010 Pro的web.config文件中使用System.Data.SqlClient连接字符串，该文件位于以下位置:C:\ Windows \ Microsoft.NET \ Framework \ v4.0.30319 \ Config

使用此功能，我可以在浏览器中对应用程序进行身份验证/运行.但是，当我在VS 2015中尝试相同的应用程序时，无法进行身份验证.好像2015年根本没有使用web.config.我的字符串格式如下:

    < connectionStrings>
        <删除名称=" LocalSqlServer"/>
        <添加名称="BioAffidavit"
                  providerName =" System.Data.SqlClient"
                  connectionString =数据源= zzzzzzzzzzzzzz，15026；初始目录= zzzzzzzzzzzzzzzzz；用户ID = aaaaaaaa；密码= aaaaaaaaa； MultipleActiveResultSets = True" />
    </connectionStrings>

2015是否需要其他格式或文件位置?

谢谢

Jon

解决方案

Jbirdmotox，

在我的VS2015中，我可以成功连接到SQL Server数据库.请参考以下代码.

在Web.config中连接字符串:

< connectionStrings>
  < add name =" ConnectionStringName"
    providerName ="System.Data.SqlClient"；
    connectionString ＝数据源＝ ****；初始目录＝结果；持久安全性信息＝ true；用户ID ＝ ***；密码＝ ***；池＝假". />
    
  </connectionStrings> 

并测试用于验证此连接字符串是否可以成功连接到数据库的代码:

字符串myvar1 = ConfigurationManager.ConnectionStrings [" ConnectionStringName"].ToString();
            SqlConnection conn =新的SqlConnection(myvar1);
            尝试
            {
                conn.Open();
                Response.Write(成功连接")；
            }
            抓住(前例外)
            {
                Response.Write(连接失败")；
            } 

据我所知，我建议您不要使用本地数据库，这在移动项目时可能会出现一些问题.以下MSDN文档是有关如何在Web应用程序中为ASP.NET配置连接字符串的.请参考连接字符串格式 通过以下链接:

https://msdn.microsoft.com/en-us/library/jj653752(v = vs.110).aspx

此致

奥斯卡

Hello,

I'm currently using a System.Data.SqlClient connection string in VS 2010 Pro in my web.config file located here: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

Using this I'm able to authenticate/run the application in a browser. However when I try the same application in VS 2015 I'm unable to authenticate. It's as if 2015 is not using the the web.config at all. The format of my string is like this:

    <connectionStrings>
        <remove name="LocalSqlServer"/>
        <add name="BioAffidavit"
                 providerName="System.Data.SqlClient"
                 connectionString="Data Source=zzzzzzzzzzzz,15026;Initial Catalog=zzzzzzzzzzzzzzz;User ID=aaaaaaaa;Password=aaaaaaaaa;MultipleActiveResultSets=True" />
    </connectionStrings>

Does 2015 require a different format or different file location?

Thanks,

Jon

解决方案

Hi Jbirdmotox,

In my side VS2015, I could connect to SQL Server Database successfully. Please refer to the following code.

Connect string in Web.config:

  <connectionStrings>
  <add name="ConnectionStringName"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=****;Initial Catalog=results;persist security info=true;user id=***;password=***;pooling=false" />
    
  </connectionStrings>

And test code that to verify whether this connect string could connect to database successfully:

            string myvar1 = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ToString();
            SqlConnection conn = new SqlConnection(myvar1);
            try
            {
                conn.Open();
                Response.Write("connect successfully");
            }
            catch (Exception ex)
            {
                Response.Write("connect failed");
            }

As far as I know, I suggest you do not use local database, which may be has some problems in moving project. The following MSDN document is about how to configure connection strings for ASP.NET in Web Applications. Please refer to the connection string format from the following link:

https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx

Sincerely,

Oscar

这篇关于Web.config-Visual Studio 2010 Pro vs 2015社区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！