Find the number of data you want in the data table

[minth08 (태희 민)]

I Used…
Dt.Select(“[Result] = ‘Fail’”).CopytoDatatable.RowCount

But…
An error occurs if there is no ‘Fail’ data.

How can I find the number by query?

[Anil_G (Anil Gorthi)]

@minth08

You need not do copytodatatable you can directly use count that way you wont get any error

also another way is dt.AsEnumerable.Where(function(x) x("Result").ToString.Equals("Fail")).Count

or your way Dt.Select("[Result] = 'Fail'").Count

cheers

[supermanPunch (Arpan)]

@minth08

An error occurs if there is no ‘Fail’ data.

@minth08 ,

Could check with the below post as well om handling the error :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[postwick (Paul)]

Filter Data Table on Result = “Fail” into a tempDT

If tempDT.Rows.Count > 0
Then get ConsumerNumber
Else do whatever is necessary if there are no Fails

[sasi_poosarla (sasi p)]

dt.Asenumerable.Where(Function(row) row(“Result”).tostring.ToLower.Equals(“fail”)).count

[Parvathy (PS Parvathy)]

Hi @minth08

Try this:

dt.AsEnumerable().Where(Function(row) row.Field(Of String)("Result") = "Fail").Count()

I/P :

Hope it helps!!