sqlserver order byÅÅÐòÎÊÌâ - .NET¼¼Êõ / ASP.NET
Order by ʱ¼ä×Ö¶Î desc ÅŲ»ÁË˳ÐòÁË Ç°ÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿ ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡ ¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡ Õâ¾ä»°ÎÒ¿´²»¶®ÒýÓà ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡ Õâ¾ä»°ÎÒ¿´²»¶® replace ÊÔͼ with ÊÓͼ Ö´ÐÐsqlÓï¾äºó³öÀ´µÄÊý¾Ý¼¯Ó¦¸ÃÊÇÅÅÐòµÄѽ£¬ÊÓͼ±¾ÉíÊDz»»á±äµÄ ¿àÄÕ¡£¡£ Ôõô¾õµÃÄã˵µÄ¶¼ÊÇÕý³£ÏÖÏ󡣡£ ¹û¶ÏÌù³ö´úÂë ºÃµÄ£¡£¡ÉÔµÈ SELECT TOP (100) PERCENT dbo.LBsiT_¿Í·þ¼Ç¼.ID, dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÖд¿Í»§ÐÕÃû, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§µç»°ºÅÂë, dbo.lbsit_¿Í»§.µØÇø, dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø¶©µ¥±àºÅ, dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø²úÆ·±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.ÏêÇé¼Ç¼, dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí·½°¸, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í·þרԱ, dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí½á¹û, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÛºóרԱ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉID from dbo.LBsiT_¿Í·þ¼Ç¼ LEFT OUTER JOIN dbo.lbsit_¿Í»§ ON dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë = dbo.lbsit_¿Í»§.¿¨ºÅ ORDER BY dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä DESC Õâ¸öÊ
Ïà¹ØÎÊ´ð£º
µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£ ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿ ÕÒ¸öרÃÅ×öÒ³ÃæµÄ ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë ȷʵʹ¿à ¸ÐͬÉíÊÜѽ ¹þ¹þ ¼á¾ö·¹ý¡£ ÓÃDW°É£¬VS¸ãÉè¼Æ ......
´úÂëÈçÏ Çë¸ßÊÖ Ö¸µãÏ лл ajax_http.js ------------- function getXMLHTTP() { var xmlhttp; if (window.ActiveXObject) { //IE try { ......
asp ·Ò³ÔõôʵÏÖ£¿ ·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡ µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads ²»Óÿؼþ Ôõô×ö°¡£¡ hehe ²» ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂ𣿠Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 3Q´ó¼Ò htmlÒ³Ãæ. Õâ¸ö,¼ÈÈ»Ö÷Ò ......