Question

我开始在网上撰写项目,并面临麻烦。当我试图执行该法典时:

System.Web.Security.Roles.CreateRole("User");

I get an exception: An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax. Parameter name: connectionString

我的项目组合的这一部分:

<configuration>
    <system.web>
      ...
      <roleManager enabled="true" defaultProvider="SqlRoleProvider">
        <providers>
          <clear/>
          <add name="SqlRoleProvider"
               connectionString="ForumDB"
               applicationName="/"
               type="System.Web.Security.SqlRoleProvider"/>
        </providers>
      </roleManager>
    </system.web>
  <connectionStrings>
    <clear/>
    <add name="ForumDB"
         connectionString="Data Source=(local)SQLEXPRESS;Initial Catalog=ForumDB;Integrated Security=True;Pooling=False"
         providerName="System.Data.SqlClient"/>
  </connectionStrings>
</configuration>

我最初认为,连接线铺设错误,但我几次检查。该法典还致力于:

    var connectionString = ConfigurationManager.ConnectionStrings["ForumDB"];
    DbProviderFactory providerFactory = DbProviderFactories.GetFactory(connectionString.ProviderName);
    DbConnection connection = providerFactory.CreateConnection();
    connection.ConnectionString = connectionString.ConnectionString;
    connection.Open();

我确信,显示联系的文字是正确的。什么是错的?

Answer 1

我在此犯了一个错误:

<roleManager enabled="true" defaultProvider="SqlRoleProvider">
    <providers>
        <clear/>
            <add name="SqlRoleProvider"
                connectionString="ForumDB"
                applicationName="/"
                type="System.Web.Security.SqlRoleProvider"/>
    </providers>
</roleManager>

我必须写:

connectionStringName="ForumDB"

友情链接