I am trying to use a Select in my DataTable.
It originally worked with two constants
SchedDT.Select("[Job Level] = ‘11’ AND [Work Location] = ‘London’")
I now need to amend the select to use variables.
After scanning the forum I found the syntax to use variables
but I am struggling to work out the syntax for
- one variable and one constant
- two variables
My current attempt is at
SchedDT.Select( “[Job Level] = '”+convert.ToString(intLevel)+"’" )
This works fine:grinning:
However when I try to add in the constant it errorrs:frowning_face:
SchedDT.Select( “[Job Level] = '”+convert.ToString(intLevel)+"’ " AND [Work Location] = ‘London’)
Any ideas on the correct syntax to use for variable+contstant and variable+variable for these Selects?
thanks in advance