mysql - 类型 'MySqlConnection' 未定义

Question

我在 app_code 中创建函数调用类时遇到以下代码的错误。

我的错误显示 -->BC30002:未定义类型“MySqlConnection”。请帮助。谢谢!

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

Answer 1

我遇到了同样的错误。

添加后

Imports MySql.Data.MySqlClient;

，以及对 MySql.Data.dll 的引用，我得到“MySqlConnection 未定义”。

我已经通过从 V2.0 而不是 V4.5 添加引用 MySql.Data.dll 来修复它>.