你这是Vb 同C#全成的,在c#中
只能这样:
if (qry.casevalue <> "") sql1=sql1+ " and case_info like '%" + qry.casevalue
只能这样:
if (qry.casevalue <> "") sql1=sql1+ " and case_info like '%" + qry.casevalue
调试欢乐多
现在的这部分语句如下: if (qry.casevalue != "") sql1=sql1+ " and case_info like '%" + qry.casevalue;
if (qry.countyvalue != "") sql1=sql1+ " and case_info like '%" + qry.countyvalue;
string sqlvalue = "select * from case_info";
sqlvalue=sqlvalue + " where id != 0 " + sql1 +"";现在还是有错误。我的目的是想把这几段拼成一个完整的查询语句。这里的几个if和sqlvalue
怎么写才正确?
在线等回答。 thanks!
<>应该是正确的 if (qry.casevalue != "") sql1=sql1+ " and case_info like '%" + qry.casevalue +"%'";
if (qry.countyvalue != "") sql1=sql1+ " and case_info like '%" + qry.countyvalue + "%'";
string sqlvalue = "select * from case_info";
sqlvalue=sqlvalue + " where id <> 0 " + sql1;
只能这样:
if (qry.casevalue <> "") sql1=sql1+ " and case_info like '%" + qry.casevalue
--》
你这是Vb 同C#全成的,在c#中
只能这样:
if (qry.casevalue != "") sql1=sql1+ " and case_info like '%" + qry.casevalue