[C#] 連線到SQL的Connectionstring 使用Windows 驗證和SQL認證

Windows 驗證

 <connectionStrings>
    <add name="DBConnectionString" connectionString="Data Source=.; Database=DBName; Integrated Security=SSPI" providerName="System.Date.sqlClinet"/>

  </connectionStrings>



SQL驗證


  <connectionStrings>
    <add name="DBConnectionString" connectionString="Data Source=.;Database=DBName; User ID=LoginID; Password=LoginPassword" providerName="System.Date.sqlClinet"/>
  </connectionStrings>


這裡是以本機的DB為範例所以Data Source設為. 。如果並非機的話就設定遠端的IP及Port就可以了。格式為[IP,Port]