Hello guys. I’m trying to use the select method and it works in the following format:
in_dtDataCID.Select(“Department = '”+row(“Department”).tostring +"’").CopyToDataTable
As i will use this method in other processes (Subdepartments and Functions) i want to create a variable to replace the Department column and take the value of Subdepartments and also Functions:
new variable: in_Type
in_dtDataCID.Select("’" +in_Type+ “’ = '”+row(in_type).tostring +"’").CopyToDataTable
but it throws error that no rows found.
I’m guessing the problem is with this part here: ‘"+row(in_type).tostring +"’.
Much appreciated for your help!