matt helpe me !

[tenvick]

I want to run sql \"select * from news where keyword like '&key1&' or keyword like '%key2%' or keyword like '%key3%' ... \"

how can I do ?

I write like this

CateNewsView obj = new CateNewsView();
foreach (string key in keywords)
{
if (key != string.Empty)
{
obj.Where.KeyWords.Value = \"%\" + key + \"%\";
obj.Where.KeyWords.Operator = NCI.EasyObjects.WhereParameter.Operand.Like;
obj.Where.KeyWords.Conjunction = NCI.EasyObjects.WhereParameter.Conj.Or;

}
}

obj.Query.Load();
return obj.DefaultView;
but it doesnt right .it only one KeyWords

[mgnoonan]

Hi Tenvick,

You need to use TearOffs when using the same column more than once. See this example from dOOdads:

http://www.mygenerationsoftware.com/phpbb3/viewtopic.php?t=107