[RESOLVED] This Code searches Strings HOW to make it search Integer?

[jmcilhinney]

You can't use the LIKE operator or wildcards with anything but text columns, plain and simple. Also, single quotes are only for string values, not numbers. If you want all records where a numerical value is within a range you can do something like this:

myView.RowFilter = String.Format("myNumberColumn >= {0} AND myNumberColumn <= {1}", minVal, maxVal)

I suggest that you read the help topic for the DataView.RowFilter property, which will point you to the DataColumn.Expression property for information on allowable values. It is very similar to standard SQL but not the same.