如何写这样的sql语句???
有一个listbox,可多选。当多选时的sql语句正确的应该是:sql="select * from tbl_personnel where TrainDate='20030705' and simplename like'我%' or simplename like '你%' or......."
可结果运行时候跟踪的sql语句是:sql="select * from tbl_personnel where TrainDate='20030705' and simplename like'我%' and simplename like '你%' or......."结果一条语句也没查到。下面是代码:各位帮我看看!
string sql=" select * from tbl_personnel where TrainDate ='drpdate.SelectItem.Text'";
for(int i=0;i<listbox.Items.Count;i++)
{
if(this.lstcontrator.Items[i].Selected)
{
sql +=" and simplename like '" + this.lstcontrator.Items[i].Value .Trim()+ "%'";
}
}