<connectionStrings>
<add name="SQLCONNECTIONSTRING01" connectionString="data Source=SIMON;database=mysimon;user id=sa;pwd=11111111" providerName="System.Data.SqlClient"></add>
<add name="SQLCONNECTIONSTRING02" connectionString="data source=SIMON; Initial Catalog=new01; Integrated Security=True" providerName="System.Data.SqlClient"></add>
</connectionStrings>
方法一SQLCONNECTIONSTRING01是通过用户“sa”来登陆SQL server数据库,访问表格mysimon
方法二SQLCONNECTIONSTRING02是通过windows验证方式登陆SQL server,不需要用户和密码,访问表格new01,应该只能是访问本机安装的SQL server!