MySQL Connection

[insignia96]

How do i make a mySql Connection in VB 2008? I am working on a program that is a DB editor in VB and I know it is possible. Ive tried googling it and i didnt get anything good. Any help?

[epic_]

Oh I have a tutorial here
http://fiveoheight.110mb.com/508_Client_Public.html

[Clain]

Exact snippet from one of my programs :P

        Try
            Using conn As New MySqlConnection(GetConnectionInfo())
                conn.Open()

                If conn IsNot Nothing Then
                    If conn.State = ConnectionState.Open Then
                        conn.Close()
                    End If
                End If
            End Using
            'MessageBox.Show("Your credentials have been verified, transferring now!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk)

        Catch sqlerror As MySqlException
            MessageBox.Show(sqlerror.Message, "An error occured", MessageBoxButtons.OK, MessageBoxIcon.Error)
            Exit Sub
            'Throw new Exception("An error occured while logging into the SQL server.", sqlerror); 
        End Try

        FrmMain.Show()
        Me.Close()

Then add the function

Public Function GetConnectionInfo() As String
        Return ("Data Source=" + TxtHost.Text + ";uid=" + TxtUsername.Text + ";pwd=" + TxtPassword.Text + ";database=" + TxtWorld.Text + ";")
    End Function

Of course you need to edit the code for your uses. OR you could google it :P http://www.google.com/search?hl=en&q...sql+connection

[insignia96]

Clain = Pure Win

+Rep for You

EDIT: Gotta Spread

[insignia96]

also how can you make it so that the program refrences libmysql.dll so it know all the stuff?

[Clain]

Oh... sorry forgot the references... Add "Mysql.Data.dll" to your project. You don't use libmysql.dll for this. Google Mysql.Data.Dll to DL it

[insignia96]

Clain i have to say you are pure win