I've been trying to figure out how I can Filter a DataView according to the beginning letter of the value in either the 1st, 2nd or 3rd column.
I've found that this is the proper format:
dv.RowFilter = "City = 'Berlin'"
dv being the Dataview. My Value represented by 'Berlin' is a variable so I can't hard code this although I can hardcode the 'City' part.
Can anyone think of a way for me to indicate that I want the filtering to be done on any rows that begin with my variable value or is this even possible?