How To fix "The source contains no DataRows."?

[Iwan_Kurniawan2 (Iwan Kurniawan)]

I filter nothing data in datatable, my expect is i get rows.count “0”, but i get this error “The source contains no DataRows.” how to fix it ?

[Gokul001 (Gokul Balaji)]

Hi @Iwan_Kurniawan2

Have a look on the thread

[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…

Regards
Gokul

[THIRU_NANI (NaNi)]

Hey!

There might be a chance of having the white spaces. Try to use the trim.

Whenever we’re using string variable will suggest you to use the Trim.

Try this and let me know…

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

Try with below expression

This expression will return an bool value.

Dt.AsEnumerable().Where(Function(x) x(1).Tostring="20").Any

Regards
Gokul

[Iwan_Kurniawan2 (Iwan Kurniawan)]

Thanks, btw can you tell me what different .Select and .Where ?

[Iwan_Kurniawan2 (Iwan Kurniawan)]

oke thanks bro

[Iwan_Kurniawan2 (Iwan Kurniawan)]

thanks… very helpful

[Gokul001 (Gokul Balaji)]

Understanding .AsEnumerable() in LINQ to SQL

Regards
Gokul

[ppr (Peter)]

@Iwan_Kurniawan2

Thanks, btw can you tell me what different .Select and .Where ?

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum