How to use variables in datatable.select

[Kn.opp (KN)]

Hello,

I have two csv files (csvA and csvB). and trying to retrieve the row from csvA which column1 contains value listed in csvB.
I’m sturgling with datatable.select. I want to use variables in select comparison but it couldn’t understand variables.
Just wondering how to fix the syntacs?

Thank you.
KN

[palindrome (Nitin Safaya)]

You can use in this way:

dtalluser.Select(“[Column1] = '” +Convert.ToString(targetempid) +“'”)

[Kn.opp (KN)]

Thanks Palindrome, it works perfectly for me! Thank you very much!

[palindrome (Nitin Safaya)]

Welcome

[Manish_Talele]

i have a Doubt If column1 Contains alphanumeric values that what datatype should i Convert to

[Elizabeth_Beaver]

you should still convert to string. Strings support alphanumeric values without complaint (and .Select expects a string to compare against anyway.

[madrattz]

You saved my life! Thanks!!

[ran.an]

I just wasted 3 hours on this one. You saved my day.