配置WebPart个性化数据库连接

使用SQL Server时可以按如下配置：

1. 在服务器上运行生成数据库:
C:/WINDOWS/Microsoft.NET/Framework/<versionNumber>/aspnet_regsql.exe

2. 配置Web.config有两种方法:

(1)比较简单,用局部设置覆盖全局设置
  <connectionStrings>
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=aspnetdb;Persist Security Info=True;User ID=sa;Password=123456" providerName="System.Data.SqlClient" />
  </connectionStrings>

(2)新建一个设置:
  <connectionStrings>
    <add name="DataServer" connectionString="Server=(local);Trusted_Connection=true; Database=aspnetdb"/>
  </connectionStrings>

<system.web>
    <webParts>
      <personalization defaultProvider="MyPersonalizationProvider">
        <providers>
          <add name="MyPersonalizationProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider" connectionStringName="DataServer" />
        </providers>
        <authorization>
          <allow users="*" verbs="modifyState" />
          <allow roles="Administrators" verbs="enterSharedScope" />
        </authorization>
      </personalization>
    </webParts>
</system.web>