strsql="select * from PUB where CHARINDEX(关键词1,branchname)>0 or CHARINDEX(关键词,itemname )>0 "; 这样应该能行的,
sql="select * from rsbt_auditingstation_file where ORGANIZATION='"+keyword+"'"; sql+=" or ORGANIZATION_CODE='"+keyword+"'"; sql+=" or RECEPTNO='"+keyword+"'"; sql+=" order by receptno desc"; break;上面的是精确查询的语句,下面的是模糊的查询,sql="select * from rsbt_auditingstation_file where ORGANIZATION like '%"+keyword+"%'"; sql+=" or ORGANIZATION_CODE like '%"+keyword+"%'"; sql+=" or RECEPTNO like '%"+keyword+"%'"; sql+=" order by receptno desc"; break;这里都能行呀,不知道楼主哪里出错了
sql = "SELECT Symbol,stockname FROM MT_Stocks WHERE Symbol LIKE'" + key + "%'";
模糊查询不就是where语句中使用like %"所要查询的数据"%
错误 2 运算符“+”无法应用于“string”和“方法组”类型的操作数 G:\asp.net\App_Code\DB.cs 46 16 G:\asp.net\
where CHARINDEX(关键词1,branchname)>0 or CHARINDEX(关键词,itemname )>0 ";
这样应该能行的,
sql+=" or ORGANIZATION_CODE='"+keyword+"'";
sql+=" or RECEPTNO='"+keyword+"'";
sql+=" order by receptno desc";
break;上面的是精确查询的语句,下面的是模糊的查询,sql="select * from rsbt_auditingstation_file where ORGANIZATION like '%"+keyword+"%'";
sql+=" or ORGANIZATION_CODE like '%"+keyword+"%'";
sql+=" or RECEPTNO like '%"+keyword+"%'";
sql+=" order by receptno desc";
break;这里都能行呀,不知道楼主哪里出错了