How to use variables in



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 I want to use variables in select comparison but it couldn’t understand variables.
Just wondering how to fix the syntacs?

Thank you.


You can use in this way:

dtalluser.Select("[Column1] = ‘" +Convert.ToString(targetempid) +"’")


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


Welcome :slight_smile: