如何不将数据网格视图中的空行插入到sql表vb.net中

' 假设你已经连接到了数据库，并且有一个名为"YourTable"的表

' 获取数据网格视图中的所有行数据
Dim rows As DataGridViewRowCollection = YourDataGridView.Rows

' 遍历每一行
For Each row As DataGridViewRow In rows
    ' 检查是否为空行
    Dim isEmptyRow As Boolean = True
    For Each cell As DataGridViewCell In row.Cells
        If Not String.IsNullOrEmpty(cell.Value?.ToString()) Then
            isEmptyRow = False
            Exit For
        End If
    Next
    
    ' 如果行不为空行，则将其插入到SQL表中
    If Not isEmptyRow Then
        ' 获取行数据
        Dim column1Value As String = row.Cells("Column1").Value.ToString()
        Dim column2Value As String = row.Cells("Column2").Value.ToString()
        ' ...

        ' 执行插入操作
        Dim query As String = "INSERT INTO YourTable (Column1, Column2) VALUES (@Column1, @Column2)"
        Using connection As New SqlConnection("YourConnectionString")
            Using command As New SqlCommand(query, connection)
                command.Parameters.AddWithValue("@Column1", column1Value)
                command.Parameters.AddWithValue("@Column2", column2Value)
                ' ...

                connection.Open()
                command.ExecuteNonQuery()
            End Using
        End Using
    End If
Next