用VB.net编程限制mysql数据库的行数

SELECT * FROM table_name LIMIT 10;

SELECT TOP 10 * FROM table_name;

Imports MySql.Data.MySqlClient

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim connString As String = "server=your_server;user id=your_username;password=your_password;database=your_database"
        Dim query As String = "SELECT * FROM table_name LIMIT 10"

        Using conn As New MySqlConnection(connString)
            conn.Open()

            Using cmd As New MySqlCommand(query, conn)
                Using reader As MySqlDataReader = cmd.ExecuteReader()
                    While reader.Read()
                        '处理每一行数据
                        Dim column1 As String = reader.GetString(0)
                        Dim column2 As Integer = reader.GetInt32(1)
                        '...
                    End While
                End Using
            End Using

            conn.Close()
        End Using
    End Sub
End Class