Ada beberapa cara dalam membaca connection string dalam vb.net. namun disini akan dibahas 2 cara saja. langsu aja nih.....
cara pertama :
tampilan conectionstring di app.config.
<connectionStrings>
<add name="WindowsApplication1.My.MySettings.Setting"
connectionString="Data Source=oirrio-pc;Initial Catalog=obat;User
ID=sa;Password=oirrio" providerName="System.Data.SqlClient" />
</connectionStrings>
trus cara membacanya dari form begini nih temen-temen,
Ketik coding ni pada form load dan nanti ketika di running akan muncul
message box yang berisi connection string yang ada di app.config :
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim con As New SqlConnection(My.Settings.Setting)
Dim constring As String = con.ConnectionString
MsgBox(constring)
End Sub
cara kedua :
tampilan conectionstring di app.config.
<appSettings>
<add key="ConnectionString" value="Data Source=OIRRIO-PC;Initial Catalog=obat;User Id=sa;Password=oirrio;"/>
</appSettings>
trus cara membacanya dari form begini nih temen-temen,
Ketik coding ni pada form load dan nanti ketika di running akan muncul
message box yang berisi connection string yang ada di app.config :
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connectionstring As String = System.Configuration.ConfigurationManager.AppSettings("ConnectionString")
MsgBox(connectionstring)
End Sub
0 komentar:
Posting Komentar