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 Õâ¸öÊ
Ïà¹ØÎÊ´ð£º
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡ Ô´ÂëºÜ³¤µÄ¡£ ²Î¿¼ C# code: HttpFileCollection files = HttpContext.Current.Request.Files; if (files.Count <= 1) { ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼· ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ 2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ лл ÓÃjs·½·¨À´¿ØÖÆ »Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£ js ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
asp ·Ò³ÔõôʵÏÖ£¿ ·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡ µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads ²»Óÿؼþ Ôõô×ö°¡£¡ hehe ²» ......