AsEnumerable Data Table - Count rows

hey @Ruy_Codo

  1. dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.Length = 5).ToString()

  2. dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.StartsWith("9")).ToString()

  3. dtTransactionData.AsEnumerable().Count(Function(row) Not row("Ref. to other vendor").ToString.StartsWith("9") AndAlso row("Ref. to other vendor").ToString.Length <> 5).ToString()

2 Likes