´ÓÓû§±íusersÖвé³öµÄËùÓмǼÁÐÔÚGridViewÖУ¬ÓÐÒ»¸ö×Ö¶ÎÊÇRole,ֵΪ:U W D£¬ 1¡¢ÈçºÎÔÚGridviewÖÐÏÔʾʱµ±Role='U'ʱÏÔʾ¡°Óû§¡±,'W'ʱÏÔʾ¡°´ýÉóºËÓû§¡±¡¡£¿
sql: select case ×Ö¶Î when 'u' then 'Óû§' when 'w' then '´ýÉóºËÓû§' end as ×Ö¶Î from ±í ding ÎÒÓõÄÊÇACCESSÊý¾Ý¿â. ¸öÈ˸оõ»¹ÊÇÔÚÊý¾Ý¿âÖбȽϺà select case when ×Ö¶Î='U' then 'Óû§'
when ×Ö¶Î='W' then 'ÉóºËÖÐ' ..... end ÄǾÍÖ»ÄܰÑÊý¾Ý¶Á³öÀ´ÔÚ´úÂëÖнøÐÐÅжÏÁË ACCESS²»Ö§³Ö Case when »ò DecodeÕâÀຯÊý°¡ C#