Visual Studio + Mysql

[richardgerman]

Mira yo lo que hago es agregar referencia -->despues le doy la ruta c:arc..progra...\mysql\Mysqlconnector Net 5.1.4\Binaries\.net 2.0\MySql.Data ...despues lo acepto y escribo este codigo:

Imports System
Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports MySql.Data.MySqlClient
Public Class Form1
Public strCon As String
Public xcon As MySqlConnection

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
strCon = "Data Source =localhost;"
strCon += "database=matriculas;" 'aqui debes poner el nombre de la base de datos'
strCon += " User Id= root; Password=root" 'este password es de mysql'
xcon = New MySqlConnection(strCon)
xcon.Open()
MsgBox("Conexion satisfactoria !!", MsgBoxStyle.Information + MsgBoxStyle.OkOnly)
xcon.Close()
Catch ex As Exception
MsgBox("error de Conexion ..." , MsgBoxStyle.Critical +MsgBoxStyle.OkOnly)
End Try
End Sub
End Class