110,533
社区成员
发帖
与我相关
我的任务
分享
[quote=引用 2 楼 woainixinxin521 的回复:] IF ((XXX IS NOT NULL AND LEN(XXX) >= 1) AND XXX IS NOT NULL AND LEN(XXX) >= 1) ELSE
就要messagebox.show
IF ((XXX IS NOT NULL AND LEN(XXX) >= 1) AND XXX IS NOT NULL AND LEN(XXX) >= 1) ELSE
string condition1="条件1"; string condition2="条件2"; string sql="select * from table where 1=1 " if(condition1!="") sql+= " and 字段1="+condition1; if(condition2!="") sql+= " and 字段2="+condition2;
select target,no from task t where no='" + grv_CntrPlanDetail.GetDataRow(i)["NO"].ToString() + "' and code='LT' and isfinished='N'"
我想查出来之后 target跟no 两者若有一个为空 则执行存储语句
target跟no 两者都不为空的时候 就要messagebox.show