未定义MySqlConnection

Question

我是vb.net和mysql的新手。

当我将Dim SQLConnection定义为MySqlConnection = MySqlConnection时，我感到困惑。

它说，新的"MySqlConnection“没有定义，但我确保我已经导入了所需的名称空间或任何东西，但我仍然有一个错误，我不能找出问题是什么。

这是我的代码：

 Imports MySql.Data.MySqlClient 

 Public Class EditInfo
Dim bednumber As String = ""
Dim patient_name As String = ""
Dim patient_age As String = ""
Dim date_of_confinement As String = ""
Dim type_of_sickness As String = ""
Dim type_of_IV_fluid As String = ""
Dim number_of_bottles As String = ""
Dim drop_rate As String = ""

Dim ServerString As String = "Server=localhost; database=patientinfo;user id=root;password=root" 'connection to phpmyadmin database
Dim SQLConnection As MySqlConnection = New MySqlConnection

 Private Sub PatientInfoBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PatientInfoBindingNavigatorSaveItem.Click
    Me.Validate()
    Me.PatientInfoBindingSource.EndEdit()
    Me.PatientInfoTableAdapter.Update(Me.PatientInfoDBDataSet.PatientInfo)

End Sub

任何帮助都将不胜感激。谢谢!我搞糊涂了，对不起，XD

Answer 1

尝试：

替换

Dim SQLConnection As MySqlConnection = New MySqlConnection

通过

Dim SQLConnection As New MySqlConnection()

另外，您可以使用String.Empty来设置字符串的值，而不是"“。

HTH。