用于集合中的MYSQL查询查找的VB.Net查询

Imports MySql.Data.MySqlClient

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim connectionString As String = "server=localhost;user=root;password=123456;database=mydatabase"
        Dim query As String = "SELECT * FROM mytable"

        Using connection As New MySqlConnection(connectionString)
            connection.Open()

            Using command As New MySqlCommand(query, connection)
                Using reader As MySqlDataReader = command.ExecuteReader()
                    While reader.Read()
                        ' 处理查询结果
                        Dim id As Integer = reader.GetInt32("id")
                        Dim name As String = reader.GetString("name")
                        ' ...

                        ' 输出查询结果
                        Console.WriteLine("ID: " & id & ", Name: " & name)
                    End While
                End Using
            End Using
        End Using
    End Sub
End Class