linq to sql ·ÖÒ³ µÄ¼¸ÖÖ·½·¨

1.Êý¾ÝµÄ·Ö²¼Skip()ºÍtake()
Skip(100)´ú±íÌø¹ý100Ðкó.´ÓµÚ101ÐпªÊ¼·ÖÒ³;
take(10)±íʾ¶àÉÙÐзÖÒ³;
Àý:
var result=from pdt in db.Product
                 select pdt;
this.dataview.DataSource=result.Skip(10).take(10);
this dataview.DataBind();
×¢:ÕâÖÖ·½Ê½Ò»´ÎÐÔ²éѯ³öÀ´ËùÓÐÊý¾Ý,È»ºóÔÙ·ÖÒ³;
2.ÏÂÃæµÄ·½Ê½ÊÇÿ¸öÌύʱ°ó¶¨µÄ¶¼ÊÇÌض¨µÄÊý¾Ý,¶ø·ÇËùÓÐÊý¾Ý;
public overridevoid DataBind()
{
     db.log=this.response.output;
          var result=from pdt in db.product
                             select pdt;
          int skipNumber=Int.parse(this.textbox1.text)*10;
           this.dataview.DataSource=result.Skip(skipNumber).take(10);
           this dataview.DataBind();
}
protected void NextButton_Click(Object sender,EventArgs e)
{
this textbox1.text=(int.parse(this.textbox1.text)+1).ToString);
this.DataBind();
}
protected void form_Load(Object send,EventArgs e)
{
        if (!this.IsPostBack)
         {
                   this.DataBind();
       }
}
4¡¢
·Ñ»°²»¶à˵£¬Ö÷ÒªÊÇLinqÖеÄSkip¼°TakeÕâ¶þ¸öÀ©Õ¹·½·¨
int RecordCount = 0;
int PageCount = 1;
DataClassesDataContext data = new DataClassesDataContext();
int SkipIndex = 0;
private string _PageString = "";
public string PageString
{
get {
return _PageString;
}
set {
_PageString = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
RecordCount = data.Orders.Coun