我用If DataTables("库存数据源").DataRows.Count = 0 And DataTables("出纳数据记账源").DataRows.Count = 0 And DataTables("财务数据源").DataRows.Count = 0 Then判断空表,如果是空表,就执行反审,结果死活不让我反审,调试发现库存数据源没有数据,但存在空行,如何判断所有单元格为空值?这样写了一下,不会弄了!不能用Compute函数统计整行为0,因为有的单元格是字符类型,不能统计。 Dim sr() As String = {"库存数据源", "出纳数据记账源", "财务数据源"}
For Each s As String In sr
For Each c As DataCol In DataTables(s).DataCols
For Each dr As DataRow In DataTables(s).DataRows
If dr.IsNull(c) Then
End If
Next
Next
Next
[此贴子已经被作者于2022/9/24 9:28:26编辑过]