ACCESS µÄÓï¾ä
string strSQL = "select top 9 wj_ID, if len(wj_CompanyName)>13 then left(wj_CompanyName,13) else wj_CompanyName as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";
ÕâÑùµÄÓï¾äÕýÈ·Âð£¿
ÔÚACCESS£¿
tring strSQL = "select top 9 wj_ID, iIf(len(wj_CompanyName)>13,left(wj_CompanyName,13), wj_CompanyName) as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";
ÕâÑùºÃÏóûÓÃ
ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ
Õâ¸öÊÇÏÔʾ´íÎó
¶÷¡£ÎÒµÄÊÇACCESSµÄ
string strSQL = "select top 9 wj_ID, iif(len(wj_CompanyName)>13 ,left(wj_CompanyName,13) ,wj_CompanyName as wj_CompanyName ) from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";
ÔÚACCESSÖÐÖ±½ÓÔËÐУ¬²âÊÔ£¬SQLÓ﷨ûÓÐÎÊÌâ
C# code:
string strSQL = "select top 9 wj_ID, iif(len(wj_CompanyName)>13 ,left(wj_CompanyName,13) ,wj_CompanyName) as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";
À¨ºÅµÄλÖò»¶Ô¸ÄÁËһϡ£
Èç¹û»¹±¨´í£¬½¨ÒéÄãÖ±½ÓÔÚACCESSÖÐÖ´ÐÐÒ»ÏÂÕâ¸öÓï¾äÒÔÅж¨¹ÊÕÏλÖá£
SQL code:
select top 9 wj_ID, iif(len(wj_Compan
Ïà¹ØÎÊ´ð£º
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
ÎÒĿǰ±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º
ÎÒÏ£Íûµ÷Õû³É£º
ÈçºÎ×öÄØ£¿
¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ
PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ
Ö÷²Ëµ¥£¬ ÊÓͼ ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......