´ÓÓû§±í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#
ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺 Response.Write(Test.GetDate()); TestÀàÈçÏ£º public class Test { static string dt=""; public static s ......