ASP.NET ·ÖÒ³·½·¨
ÎÒÊÇÓÃAspNetPagerÀàÍê³ÉµÄ ¿ÉÊÇÏëʵÏÖ°´Ê±¼ä˳ÐòÅÅÁÐ. ÎÒÊÇÓÃlimit×öµÄ²éѯID×ÜÊý¸øAspNetPager È»ºóÈÃËûÉú³ÉÒ³Êý. select * from bbs limit 0,10 GROUP BY Mate ÕâôÏÂÈ¥µÄ¿ÉÊÇ,ÎÒ²»Äܽâ¾ö°´Ê±¼äÅÅÐò,ÐÂÌù²»ÔÚµÚÒ»Ò³ÏÔʾ ÏëÁË°ëÌìûºÃµÄ°ì·¨ ÎÒÏëÊÇ´Ó×îºó¿ªÊ¼È¡limit idmax-10,10 ÕÒÁË×ÊÁÏ˵ÕâÑùЧÂʲ»¸ß ´ó¼ÒÓÐûÓкð취?
µÈɱ±ÎâÆìÍÞ£¬ËûÊÇÄǿؼþµÄ×÷ÕßÒýÓà µÈɱ±ÎâÆìÍÞ£¬ËûÊÇÄǿؼþµÄ×÷Õß MYSQL·ÖҳʵÏÖÓеãÀ§ÄÑ...ËÄÜÌá¸ö½¨Òé? ÎÒ¸ÕÕÒµ½ÁËÒ»¸ö¿ÉÐеİ취 ¾ÍÊǶ¨ÒåÁ½¸ö±äÁ¿À´¼Ç¼×î´óµÄIDºÍ×îСµÄID ´ó¼Ò¿´¿´Õâ·½·¨ÔõôÑù°¡ select * from bbs limit 0,10 GROUP BY ʱ¼ä desc ²»ÄÜÕâÑùдÂð£¬ÎÒÓõÄsql µÄÊý¾Ý¿â£¬¶ÔmysqlµÄÓï¾ä²»ÊìÒýÓà select * from bbs limit 0,10 GROUP BY ʱ¼ä desc ²»ÄÜÕâÑùдÂð£¬ÎÒÓõÄsql µÄÊý¾Ý¿â£¬¶ÔmysqlµÄÓï¾ä²»Êì Õâ¸ö²»ÊÇ×ÜÊÇÈ¡Ç°10¸öÂé BBSÒªµÄÊÇ´Ó×îºóÒ»¸öµ¹ÐòÏÔʾ°¡. Æäʵ·µ»ØÁ½¸öÊý¾Ý¼¯×î¼òµ¥ÁË £¬ ¶àÉÙÌõ¼Ç¼һ¸öÊý¾Ý¼¯£¬ ÐèÒªÏÔʾµÄÊý¾ÝÒ»¸öÊý¾Ý¼¯¡£ÒýÓà Æäʵ·µ»ØÁ½¸öÊý¾Ý¼¯×î¼òµ¥ÁË £¬ ¶àÉÙÌõ¼Ç¼һ¸öÊý¾Ý¼¯£¬ ÐèÒªÏÔʾµÄÊý¾ÝÒ»¸öÊý¾Ý¼¯¡£ ÎÒÒ²ÊÇÄÇô×öµÄ°¡
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product) ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
ÔÚµ¯³ö¿òÖеã»÷Ò»¸ö°´Å¥£¬Ôõôµ÷תµ½ÁíÒ»¸öä¯ÀÀÆ÷£¬²¢ÇÒÔÚ¸Ãä¯ÀÀÆ÷´ò¿ªÁ½¸öÒ³Ãæ ÄãµÄÒâ˼Ӧ¸ÃÊÇ response.write("<script>alert('È·ÈÏ'); window.location.href('xxxx.aspx'); </script>"); ......
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆڿؼþÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C# ÎÒÓÐÕâôһ¸öÈÕÆڿؼþ£¬£¡µã»÷¿ÉÒÔÑ ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£© http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......