博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

aspnetpager控件+Linqtoentity使用例子

Posted on 2010-03-22 21:41  一刻  阅读(288)  评论(0编辑  收藏  举报

aspnetpager第三方控件,使用方法说难就难,说简单就多简单

1.设定AspNetPager1的每页显示条数,pagesize

2.数据绑定之后给 AspNetPager1.RecordCount(数据的总条数)赋值

3.设置AspNetPager1_pagechanging事件,这个事件里面,你要告诉AspNetPager1你当前的页面为你正选择的页面,然后再把这个当前页面传递给数据控件

以下为aspnetpager控件+Linqtoentity使用例子

---前台代码

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server"
            onpagechanging="AspNetPager1_PageChanging" PageSize="10"
            PageIndexBoxType="DropDownList" ShowPageIndexBox="Always" >
</webdiyer:AspNetPager>
    </div>
    </form>
</body>

</html>

后台代码

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using NorthwindModel;

public partial class _Default : System.Web.UI.Page
{
    NorthwindEntities MyDb=new NorthwindEntities();
    protected void Page_Load(object sender, EventArgs e)
    {
        BindGridView(1);
    }
    private void BindGridView(int pagesize)
    {
        var customers = from c in MyDb.Customers
                        orderby c.CustomerID
                        select new
                        {
                            c.Address,
                            c.City,
                            c.Country
                        };
        var sourse = customers.Skip((pagesize - 1) * 10).Take(10);
        AspNetPager1.RecordCount = customers.Count();
      
        GridView1.DataSource = sourse;
        GridView1.DataBind();
       
    }

    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        BindGridView(AspNetPager1.CurrentPageIndex);

    }
}