Type 'MySqlConnection' is not defined

type racer
learn to type
nitro type
learn to type for kids
type thesaurus
type game
free typing lessons
typing test

I am facing the error on the below code while i created a function call class at app_code.

My error is showing -->BC30002: Type 'MySqlConnection' is not defined. Please help.Thanks!

Imports System.Data
Imports System.Data.SqlClient
Imports System.Net.Mail
Imports MySql.Data.MySqlClient

Namespace check90daysreturn

Public Class Check90days
    Public Function check(ByVal datereceived As String, ByVal shipdate As String, ByVal partsn As String)

        Dim con As String = ConfigurationManager.ConnectionStrings("xxxConnectionString").ConnectionString
        Dim Sql As New MySqlConnection(con)

        Dim reader2 As Object
        Dim theQuery2 As String = "SELECT Max(shipmentdate) FROM prc.tbsrparts t WHERE Substring(partsn, 17, 11) = '" + partsn.ToString + "'" 'get latest shipment date from database
        Dim command2 As New MySqlCommand(theQuery2, Sql)
        reader2 = command2.ExecuteScalar

        'send auto email
        Dim mailmssg As New MailMessage()
        Dim smtp_client As New SmtpClient

        mailmssg.IsBodyHtml = True
        smtp_client = New SmtpClient
        smtp_client.Host = "ll.smtp.xxxxx.com"
        smtp_client.Port = 25

        mailmssg.From = New MailAddress("zzz@yahoo.com")

        mailmssg.CC.Add("xxxx@yahoo.com")
        mailmssg.Subject = "(Testing)"
        mailmssg.Body = "Testing"

        smtp_client.DeliveryMethod = SmtpDeliveryMethod.Network
        smtp_client.Send(mailmssg)



    End Function
End Class
End Namespace

I got the same error.

After adding

Imports MySql.Data.MySqlClient;

, and a reference to the MySql.Data.dll I got 'MySqlConnection is not defined'.

I have fixed it by adding the reference MySql.Data.dll from the older version that is V2.0 instead of V4.5.

Learn to Type, a design on either side of a medal or coin. Tens of thousands of schools rely on us every year. My students love the Typing.com certificates and are proud to display their growth on the walls of our classroom. Last year’s winner was a 5th grader who got up to 113 WPM using the program! Typing.com is a one-stop shop for students to learn to type! The fact that students can progress at

Sometimes adding the refernce to MySql.Data.dll becomes problematic if it is not listed in the reference tab of your project's prpoerties. In this case if you are sure that you have installed the MySql connector then simply choose add reference, on the dialog box shown choose browse then navigate to the folder inwhich it is installed in my case it is C:\Program Files (x86)\MySQL\Connector NET 6.10\Assemblies\v4.5.2 then select MySql.Data.dll click on open then add and it should work alright

TypeRacer, an abstract category or class of linguistic item or unit, as distinct from actual occurrences in speech or writing. type, kind, sort, nature, description, character mean a number of individuals thought of as a group because of a common quality or qualities. type may suggest strong and clearly marked similarity throughout the items included so that each is typical of the group. one of three basic body types kind may suggest natural grouping.

In my scenario,the problem was fairly simple. The project I worked on was targeting framework version 4.5 of .Net where as MySql.Data was targeted towards .Net 4.5.2 version. MySql.Data version should be lower or equal to the project target framework version. So I changed the project target version to 4.5.2 and it compiled successfully. Hope that helps someone.

Typing practice, write (something) on a typewriter or computer by pressing the keys. Type definition, a number of things or persons sharing a particular characteristic, or set of characteristics, that causes them to be regarded as a group, more or less precisely defined or designated; class; category: a criminal of the most vicious type.

So you have already added Imports MySql.Data.MySqlClient. But have you also added a reference to the MySql.Data.dll?

How do I add a reference to the MySQL connector for .NET?

TypingClub: Learn Touch Typing Free, determine the type to which (a person or their blood or tissue) belongs. usage: When preceded by a modifier, type meaning “kind, sort” is sometimes used without a following of: This type furnace uses very little current. We have a magnetic-type holder for the rack. Frequently criticized by usage guides, this construction occurs rarely in general writing.

Type, Examples of type in a Sentence. Noun We were not prepared to face this type of crisis. We studied various types of trees. Learn the Foundations of Technology, FREE! Build essential skills with our comprehensive curriculum including keyboarding, digital literacy, and coding!

TYPE, All the reasons to start learning how to type right now. It's a game. An engaging and interactive experience while you are learning how to type. Proper hand  Welcome to the #1 typing speed test with over 4 million tests completed every month! Start Typing Test. Now typing gets fun! Play our numerous fun typing games to become a true keyboard master. TypeTastic for Schools. Discover 700+ typing activities for all grade levels – and unleash the joy of typing in your school.

ZType – Typing Game, Type definition, a number of things or persons sharing a particular characteristic, or set of characteristics, that causes them to be regarded as a group, more or  The award-winning online typing competition, TypeRacer, is the best free typing game in the world. Race against live opponents typing quotes from books, movies, and songs.

Comments
  • I had similar problem. I went to Visual Studio's Project Properties, Under References, for some reason for MySql.Data the Path was not found so I had to browse to the correct path to fix the issue.
  • This worked for me, too, except I used the V4.0 instead of V4.5. Thanks.
  • Hi Tim,yes i already added the imports.MySql.Data.dll also already exists inside the project