且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何检查datagridview单元是否为空

更新时间:2023-11-29 19:55:16

您需要检查 属性 nofollow> DataGridViewCell Nothing (等效于 null in C#)。

You need to check if the Value property of the DataGridViewCell is Nothing (the equivalent of null in C#).

您可以使用以下代码进行操作:

You can do that with the following code:

If myDataGridView.CurrentCell.Value Is Nothing Then
    MessageBox.Show("Cell is empty")
Else
    MessageBox.Show("Cell contains a value")
End If



如果您想通知用户何时尝试将保留为空的单元格保留为空白,您需要在 CellValidating 事件处理程序方法。例如:


If you want to inform the user when they try to leave the cell that it has been left empty, you need to use similar code in the CellValidating event handler method. For example:

Private Sub myDataGridView_CellValidating(ByVal sender As Object,
               ByVal e As DataGridViewCellValidatingEventArgs)
               Handles myDataGridView.CellValidating
    If myDataGridView.Item(e.ColumnIndex, e.RowIndex).Value Is Nothing Then
        ' Show the user a message
        MessageBox.Show("You have left the cell empty")

        ' Fail validation (prevent them from leaving the cell)
        e.Cancel = True
    End If
End Sub