endrec
asked on
Determine If Row Is Empty in Datagridview
How do you determine if an entire row is empty?
The code below is not working well. Even if there is one row of data it has two blocks of text output.
If IsDBNull(datagrid1.Item(0, r).Value) = False And IsDBNull(datagrid1.Item(1, r).Value) = False And IsDBNull(datagrid1.Item(2, r).Value) = False And IsDBNull(datagrid1.Item(3, r).Value) = False And IsDBNull(datagrid1.Item(4, r).Value) = False Then
strTransportSequence &= CurRowStr & " ========================== ====" & vbCrLf
End If
For r As Integer = 0 To datagrid1.Rows.Count - 1
Dim CurRowStr As String = ""
CurRowStr = CurRowStr & " Test1 : " & datagrid1.Item(0, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test2 : " & datagrid1.Item(1, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test3 : " & datagrid1.Item(2, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test4 : " & datagrid1.Item(3, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test5 : " & datagrid1.Item(4, r).Value & vbCrLf
If IsDBNull(datagrid1.Item(0, r).Value) = False And IsDBNull(datagrid1.Item(1, r).Value) = False And IsDBNull(datagrid1.Item(2, r).Value) = False And IsDBNull(datagrid1.Item(3, r).Value) = False And IsDBNull(datagrid1.Item(4, r).Value) = False Then
strTransportSequence &= CurRowStr & " ========================== ====" & vbCrLf
End If
Next
The code below is not working well. Even if there is one row of data it has two blocks of text output.
If IsDBNull(datagrid1.Item(0,
strTransportSequence &= CurRowStr & " ==========================
End If
For r As Integer = 0 To datagrid1.Rows.Count - 1
Dim CurRowStr As String = ""
CurRowStr = CurRowStr & " Test1 : " & datagrid1.Item(0, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test2 : " & datagrid1.Item(1, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test3 : " & datagrid1.Item(2, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test4 : " & datagrid1.Item(3, r).Value & vbCrLf
CurRowStr = CurRowStr & " Test5 : " & datagrid1.Item(4, r).Value & vbCrLf
If IsDBNull(datagrid1.Item(0,
strTransportSequence &= CurRowStr & " ==========================
End If
Next
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.