帮我看看这个
"select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb like GYSYW like '%'" + str.Trim() + "'%'"这个问题出在哪?? --------------------编程问答-------------------- like GYSYW like '%'这是什么玩意 --------------------编程问答-------------------- like GYSYW like 改成where GYSYW like --------------------编程问答-------------------- "select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb like GYSYW like '%" + str.Trim() + "%'"
这样就好了 --------------------编程问答-------------------- "select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb like GYSYW like '%" + str.Trim() + "%'"
这样就好了 --------------------编程问答-------------------- 我想查询表中 GYSYW 中含有 字符串变量str的结果 --------------------编程问答-------------------- "select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb where GYSYW like '%" + str.Trim() + "%'"
这样就好了 --------------------编程问答-------------------- "select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围
from GYSTb like GYSYW like '%'" + str.Trim() + "'%'"
"select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb where GYSYW like '%" + str.Text + "%' "; --------------------编程问答-------------------- 在表名后面加where啊 --------------------编程问答-------------------- 前面个like改成Where --------------------编程问答-------------------- 怎么又2个like --------------------编程问答-------------------- "select GYSId as 编号,GYSName as 供应商名称,GYSYW as 经营范围 from GYSTb where GYSYW like '%" + str.Trim() + "%'"
补充:.NET技术 , C#