VB.NET - MySQL Error

I want to search  for a record in MySql database using a name inputed to a textbox, if the record is found, then the record with that name would be outputed to another form's textboxes.
Now I have the following code:

Imports MySql.Data.MySqlClient
Public Class frmSearchResult

    Dim con As MySqlConnection = New MySqlConnection("Datasource=localhost; Database=employee; username=root;")
    Dim sql As MySqlCommand = New MySqlCommand("SELECT * FROM employeedetails WHERE Employee Name='" & Trim(frmSearch.txtSearchEmpName.Text) & "'", con)


    Private Sub frmSearchResult_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      Try
        Dim c As New MySqlCommand(sql.ToString, con)
        Dim s As MySqlDataReader
        con.Open()
        s = c.ExecuteReader
        While s.Read
          txtEmpNum.Text = Trim(s.GetValue(0))
          txtEmpName.Text = Trim(s.GetValue(1))
          txtDateJoined.Text = Trim(s.GetValue(2))
          txtLeavedays.Text = Trim(s.GetValue(3))
          txtDaysWorked.Text = Trim(s.GetValue(4))
          txtSickDays.Text = Trim(s.GetValue(5))
          txtWorkingDays.Text = Trim(s.GetValue(6))
          txtDaysAllowed.Text = Trim(s.GetValue(7))
          txtNumofLeaveDays.Text = Trim(s.GetValue(8))
        End While
      Catch ex As Exception
        MsgBox(Err.Description)
        con.Close()
      End Try

    End Sub

    Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
      Me.Hide()
      frmLeaveDaysCalculator.Show()
      Form4.Hide()
      frmDatabase.Hide()
      frmLogin.Hide()
    End Sub
End Class

Now if I run the program, am receiving the following error:

You have an error in your SQL Syntax; check the manual that corresponds to your MySQL Server Version for the right syntax to use near
MySQL.Data.MySQLClient.MySQL at line 1

How should I go about this error.

Thank you very much

hi,

The first thing we need to do is add a reference to the MySql assembly. Click the Project from the menu and then select Add Reference. Under the .Net tab, browse for the MySQL.Data assembly.

Now that the reference has been added, we need to use the Imports directive to import the
MySql.Data.MySqlClient namespace.

That, I had done already, but the error still comes up

hi,

About your error please refer this link:http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-5-2-8.html

Thanks,