比如说select case 列名 when 0 then '无效' when 1 then '有效' end from 表名
SQL判断假如该列名为 IsEffective,SQL这样:select case when IsEffective=0 then '无效' else '有效' end as IsEffective from 你的表名; 在程序中判断: <%#Eval("IsEffective").ToString=="0"?"无效":"有效"%>
table定义为 opid int cando varchar查询 SELECT dbo.OP.OPID, dbo.OP.CanDo, derivedtbl_1.c2 FROM dbo.OP INNER JOIN (SELECT '0' AS c1, '有效' AS c2) AS derivedtbl_1 ON dbo.OP.CanDo = derivedtbl_1.c1
在程序中判断:
<%#Eval("IsEffective").ToString=="0"?"无效":"有效"%>
http://www.cnblogs.com/insus/articles/2055745.html
opid int
cando varchar查询
SELECT dbo.OP.OPID, dbo.OP.CanDo, derivedtbl_1.c2
FROM dbo.OP INNER JOIN
(SELECT '0' AS c1, '有效' AS c2) AS derivedtbl_1 ON dbo.OP.CanDo = derivedtbl_1.c1
public string binddate(object o){
if(o.tostring()=="1"){
return "有效";
}else{
return "无效";
}
}
怎么用就不用说了吧 设计层<%# binddate(Eval("字段名"))%>