如何将数据从datagridview插入到数据库mysql vb.net

Imports MySql.Data.MySqlClient

' 数据库连接字符串
Dim connString As String = "server=数据库服务器地址;user id=用户名;password=密码;database=数据库名"

' 创建数据库连接对象
Using conn As New MySqlConnection(connString)
    ' 打开数据库连接
    conn.Open()

    ' 循环遍历DataGridView的行
    For Each row As DataGridViewRow In dataGridView1.Rows
        ' 获取DataGridView中的数据
        Dim column1Value As String = row.Cells("Column1").Value.ToString()
        Dim column2Value As String = row.Cells("Column2").Value.ToString()

        ' 构建插入数据的SQL语句
        Dim sql As String = "INSERT INTO 表名 (列1, 列2) VALUES (@value1, @value2)"

        ' 创建命令对象
        Using cmd As New MySqlCommand(sql, conn)
            ' 添加参数并设置值
            cmd.Parameters.AddWithValue("@value1", column1Value)
            cmd.Parameters.AddWithValue("@value2", column2Value)

            ' 执行插入操作
            cmd.ExecuteNonQuery()
        End Using
    Next

    ' 关闭数据库连接
    conn.Close()
End Using