how to check whether datatable has all rows contains “=” operator ,without checking for each row in data table
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.