Error encountered on datatable select

[joscares (Joshua Oscares)]

Here is the code

Here is the error encountered
If Remarks has N/A: Cannot perform ‘=’ operation on System.Int32 and System.String.

Filter datatable is not working that’s why im trying this approach

[Nithinkrishna]

Hey @joscares

In the second part of the condition please try converting remarks column value to string,

CONVERT([Remarks],'System.String')

Hope this helps.

Thanks
#nK

[joscares (Joshua Oscares)]

I’m having error on adding that code

here is the code:
dt_Reversal.Select(“[Remarks]=‘#N/A’”).length>0 or dt_Reversal.Select(“[Remarks]=‘-2146826246’”).length>0

[Yoichi]

Hi,

FYI, it might be clearer to use LINQ for the type, as the following.

dt_Reversal.AsEnumerable().Count(Function(r) r("Remarks").ToString ="N/A" OrElse r("Remarks").ToString ="-2146826246" )>0

Regards,

[joscares (Joshua Oscares)]

It works thank you again yoichi!

[joscares (Joshua Oscares)]

Hello, Yoichi I tried this on 500k rows of data and taking a long time to process is there a way to make it faster?

[Yoichi]

Hi,

The following might be better. Can you try this?

dt_Reversal.AsEnumerable().Any(Function(r) r("Remarks").ToString ="N/A" OrElse r("Remarks").ToString ="-2146826246" )

Regards,