protected string keywords(string keyWord)
...{
if (keyWord != null & keyWord != "")
...{
string strKeyword = keyWord.Replace("'", "''");
string strTemp = "";
string strSubQuery = " and";
string[] KeyWordArray;
KeywordArray = strKeyWord.Split(null);
if (KeyWordArray.Length < 2)
...{
strSubQuery += " ProductName like '%" + strKeyWord + "%'";
}
else
...{
strTemp = "";

...{
strTemp += " ProductName like '%" + KeyWordArray[i] + "%' or";
}
strTemp = strTemp.TrimEnd(new char[] ...{ 'o', 'r' });
strSubQuery += strTemp;
}
return strSubQuery;
}
return null;
} 搜索關鍵字生成模糊查詢條件 以空格分隔2個關鍵字