ROWFILTER

1. private string RowFilter(string field, string keywords)
2. {
3. string output = String.Empty;
5. String[] straKeywords = keywords.Split(' ');
6. int arrayLength = straKeywords.Length - 1;
8. int i = 0;
9. foreach (string keyword in straKeywords)
10. {
11. output += String.Format("([{0}] LIKE '%{1}%')", field, keyword);
13. if (i++ < arrayLength)
14. output += " OR ";
15. }
17. return output;
18. }