还是显示全部,我的语句是这样的:
dw_1.settransobject(sqlca)
string ls
ls=string(em_1.text)
string now_n1
now_n1= 'SELECT fax.id,fax.title,fax.sendtime,fax.sender FROM fax WHERE where convert(char(10),fax.sendtime,111) ='+ls+' using sqlca;'
dw_1.SetSQLSelect(now_n1)
dw_1.Retrieve()