VB.NET如何将整个DataGridView数据一次性导出/插入到Sqlite表中

Dim connectionString As String = "Data Source=<数据库文件路径>;Version=3;"
Dim connection As New SqliteConnection(connectionString)

connection.Open()

Dim insertQuery As String = "INSERT INTO <表名> (<列1>, <列2>, ...) VALUES (@Value1, @Value2, ...)"

Dim command As New SqliteCommand(insertQuery, connection)

For Each row As DataGridViewRow In dataGridView1.Rows
    command.Parameters.Clear()
    command.Parameters.AddWithValue("@Value1", row.Cells("列1的名称").Value)
    command.Parameters.AddWithValue("@Value2", row.Cells("列2的名称").Value)
    ' 添加更多的参数，以匹配目标表的列数

    command.ExecuteNonQuery()
Next

connection.Close()