Link to home
Start Free TrialLog in
Avatar of Rowel Virgo
Rowel VirgoFlag for Philippines

asked on

Chart Visual Studio .NET

How to add database? Properties window Data>DataSource? From my SQL from another computer.
User generated imagehere's my Module and code/sql connection IP/user/pass/database

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Miguel Oz
Miguel Oz
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rowel Virgo

ASKER

I'll try more