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 Õâ¸öÊ
Ïà¹ØÎÊ´ð£º
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ? ÕÒ¸öÈ«²Å·Òë¡£ ÊÖ¶¯È¥Ð´ ¸Ð¾õд¹ýaspµÄ£¬À´Ð´asp.net£¬ÉÏÊÖÓ¦¸Ã¿ìµã¡£ ¸üÄÜÀí½âasp.netµÄһЩÄÚ²¿¼¼Êõ asp.net¶¼±»·â×°ÁË ÎÒÊÇ×ö.NetµÄ£¬¶ÔASPһֱû½Ó´¥µ½£¬ºÜÄ°Éú¡£ ¹« ......
ʹÓõÄÊÇ¿ò¼Ü×Ô´øµÄtreeview °ó¶¨ÏÔʾ£¬Äܹ»°´ÕÕÕýÈ·µÄÐÎʽÏÔʾ³öÀ´ µ«Ò»µã»÷¾Í»á±¨´í ³ÌÐò¼¯¡°System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a¡±ÖеÄÀàÐÍ¡°System.Web.UI.WebCo ......
asp ·Ò³ÔõôʵÏÖ£¿ ·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡ µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads ²»Óÿؼþ Ôõô×ö°¡£¡ hehe ²» ......
ÀàËÆÌÔ±¦Ò³ÃæÉ쵀 http://www.taobao.com/ ×îºÃÓÐÔ´Âë »òÕß˵µÄÏêϸµã лл ~ ʲô½Ð¶¯Ì¬¹ã¸æ£¿ ²»Ã÷°× µ¯³öÒ»¸ö¿ò£¿ ÀûÓÃJsÎļþ°É£¬°Ñ¹ã¸æÉú³Éjs aspx: <%@ Page Language="C#" AutoEventWi ......