¹ØÓÚsql×Ö¶ÎÌáÈ¡

ÔÚsqlÖÐÓиö×Ö¶ÎIsDealËüµÄÖµÖ»ÓÐ0»ò1Á½¸öÖµ£¬0´ú±íû´¦Àí£¬1´ú±íÒÑ´¦Àí¡£ÎÒÏëÔÚasp.netǰ̨°ó¶¨ÌáÈ¡Êý¾Ýʱºò°Ñ0»»³É·ñ£¬1»»³ÉÊÇ¡£¡£¡£¡£Çë´óÏÀÖ¸½Ì

---

C# code:

//ºǫ́д¸ö·½·¨
public string Con2Str(int i)
{
return i==0?"ÊÇ":"·ñ";
}


ǰ̨°ó¶¨µÄʱºòµ÷Ó÷½·¨£¡

---

SQL code:
case when IsDeal=0 then '·ñ' else 'ÊÇ' end

---

SQL code:
isnull(nullif(isnull(nullif(IsDeal,0),'·ñ'),1),'ÊÇ')

---

SQL code:
case IsDeal when 0 then '·ñ' else 'ÊÇ' end

---

½áÌù°É ºÇºÇºÇ

---

ÒýÓÃ

<%#Eval("×Ö¶Î").ToString()=="1"?"ÊÇ":"·ñ"%>

........