How to check whether datatable has all rows contains "=" operator ,without checking for each row in data table


#1

how to check whether datatable has all rows contains “=” operator ,without checking for each row in data table


#2

Hi

one way by using LINQ query,

(From dr In ipdt.AsEnumerable() Where (convert.ToString(dr(0)).Contains("=")) Select Convert.tostring(dr(0))).ToArray()

The above query can give all the rows that contains “=” operator.
If we do .count we’ll get rows count, which contains “=” operator.
By doing datatable.rows.count we’ll get total number of rows in the datatable.
Compare both counts.