Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¡¾·ÖÏíASP.net¡¿linq to sql¶¯Ì¬ÅÅÐò ½â¾ö·½°¸

*********
·ÖÊý²»¹»£¬Ö»ÄÜ·¢Õâ¶ùÁË¡£
*********

Ò»°ãÎÒÃÇʹÓÃÕâÑùµÄÅÅÐò·½Ê½£º
var DS = from a in DB.news where a.XXX == '1' orderby a.SSS,a.SSS2 descending select a;

Èç¹û¶¯Ì¬ÅÅÐòµÄ»°£¬Ê¹ÓÃswitchÒ²¿ÉÒÔÂú×ãÐèÇ󣬵«µ±ÅÅÐòÒÀ¾ÝºÜ¶àʱ£¬ÕâÏÔÈ»²»ÊÇÃ÷ÖÇÖ®¾Ù¡£

ÎÒÃÇ¿ÉÒÔÕâÑù×ö£º

var DS = from a in DB.news where a.XXX == '1' select a;
DS = LinqSort.OrderBy(DS, SortOrder.Value + " " + OrderDire.Value);
if (XXX)
DS = LinqSort.ThenBy(DS,SortOrder2.Value + " " + OrderDire.Value);
XXX.DataSource = DS.Skip(I).Take(PageSize);

·Ï»°²»¶à˵£¬LinqSortÀàÈçÏ£º

C# code:

using System;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;

namespace Name
{
public static class LinqSort
{
/// <summary>
/// Linq¶¯Ì¬ÅÅÐò
/// </summary>
/// <typeparam name="T">T</typeparam>
/// <param name="source">ÒªÅÅÐòµÄÊý¾ÝÔ´</param>
/// <param name="value">ÅÅÐòÒÀ¾Ý£¨¼Ó¿Õ¸ñ£©ÅÅÐò·½Ê½</param>
/// <returns>IOrderedQueryable</returns>
public static IOrderedQueryable<T> OrderBy<T>(this IQueryable<T> source, string value)
{
string[] arr = value.Split(' ');
string Name = arr[1].ToUpper() == "DESC" ? "OrderByDescending" : "Order


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ