Winform加入MS SQL連線字串
App.config:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
</startup>
<connectionStrings>
<!-- '*** 資料庫 連結字串*** -->
<add name="DBcs"
connectionString="Data Source=210.65.10.150;Initial Catalog=STSP;Persist Security Info=True;User ID=sa;Password=jsene2wsx#EDC"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
連線字串:
Private Sub alarm_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim Conn As SqlConnection = New SqlConnection
Conn.ConnectionString = ConfigurationManager.ConnectionStrings("Dbcs").ConnectionString()
Conn.Open()
End Sub
加入連線字串之前須參照:
