hello po sa lahat, help naman po dito.
here's my Module and code/sql connection IP/user/pass/database
View attachment 326802How to add database? Properties window Data>DataSource? From my SQL from another computer.
here's my Module and code/sql connection IP/user/pass/database
Code:
Imports MySql.Data.MySqlClient
Module dbModule
Public conn As New MySqlConnection
Public Sub dbConnect()
Try
If conn.State = ConnectionState.Closed Then
'Local Database
conn.ConnectionString = "server=127.0.0.1;userid=root;password=root;database=dashboard"
conn.Open()
End If
Catch ex As Exception
MsgBox(ex.ToString())
End Try
End Sub
End Module