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