c#一个分页控件的例子

一、首先下载一个dll,地址:http://pan.baidu.com/share/link?shareid=1628211605&uk=1342867987

二、添加到项目中

三、添加引用

四、前台页面写法如下:

 

复制代码
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h3 style="color:Green;">品牌列表</h3>
        <div style="text-align:right;margin-bottom:5px;margin-right:35px;">
            <asp:Button ID="btnAdd" runat="server" Text="添加品牌" οnclick="btnAdd_Click" />
        </div>
        <asp:DataGrid ID="DgBM" runat="server" HorizontalAlign="Center" Width="100%" AllowSorting="True"
                        AutoGenerateColumns="False" BorderStyle="None" GridLines="None" PageSize="2"
                        DataKeyField="id" OnItemCommand="DgBM_ItemCommand" OnItemDataBound="DgBM_ItemDataBound">
                        <AlternatingItemStyle ></AlternatingItemStyle>
                        <ItemStyle ></ItemStyle>
                        <HeaderStyle ></HeaderStyle>
                        <Columns>
                            <asp:BoundColumn DataField="BTitle" HeaderText="标题"></asp:BoundColumn>
                            <asp:BoundColumn DataField="Gtype" HeaderText="类型"></asp:BoundColumn>
                            <asp:BoundColumn DataField="createTime" HeaderText="创建时间"></asp:BoundColumn>
                            <asp:BoundColumn DataField="Description" HeaderText="描述"></asp:BoundColumn>
                            <asp:TemplateColumn HeaderText="编辑" HeaderStyle-Width="60px">
                                <ItemTemplate>
                                    <asp:ImageButton ID="Editimg" runat="server" CommandName="edit"
                                        ImageUrl="~/Images/work/edit.gif" AlternateText="编辑"></asp:ImageButton>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:ImageButton ID="Saveimg" runat="server"  CommandName="save"
                                         AlternateText="保存"></asp:ImageButton>
                                    <asp:ImageButton ID="Closeimg" runat="server"  CommandName="close"
                                         AlternateText="取消"></asp:ImageButton>
                                </EditItemTemplate>
                            </asp:TemplateColumn>
                            <asp:TemplateColumn HeaderText="删除" HeaderStyle-Width="60px">
                                <ItemTemplate>
                                    <asp:ImageButton ID="Delimg" runat="server" CssClass="btn_op" CommandName="del" ImageUrl="~/images/work/del.gif">
                                    </asp:ImageButton>
                                </ItemTemplate>
                            </asp:TemplateColumn>
                        </Columns>
                    </asp:DataGrid>
     <table cellspacing="0" cellpadding="0" width="95%">
            <tr>
                <td>
                    <cc1:SqlPager ID="SqlPager1" runat="server" ControlToPaginate="DgBM" Height="30px"
                        BorderWidth="0px" BackColor="#FFFFFF" PagerStyle="ImageButtonNumericPageItems"
                        firstImg="../../images/work/first.gif" lastImg="../../images/work/last.gif" nextImg="../../images/work/next.gif"
                        prevImg="../../images/work/previous.gif" Width="100%" />
                    <br />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
复制代码

 

后台代码如下:

复制代码
 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            PageBind();
        }
    }
    #region 分页绑定列表
    /// <summary>
    /// 绑定通知公告列表
    /// </summary>
    public void PageBind()
    {
        string connStr = ConfigurationManager.AppSettings["DataConn"].ToString();
        string strCmd = "SELECT id,BTitle,(SELECT BTitle FROM BrandType WHERE id=Brand.BTID ) AS Gtype,createTime,imgURL,Description,sort FROM Brand";
        try
        {
            // 清除缓存      
            SqlPager1.ClearCache();
            // 绑定数据.
            SqlPager1.ConnectionString = connStr;
            SqlPager1.SelectCommand = strCmd;
            SqlPager1.SortField = "sort ASC";
            SqlPager1.ItemsPerPage = 20;
            SqlPager1.DataBind();
        }
        catch { }
    }
    #endregion
    protected void DgBM_ItemCommand(object source, DataGridCommandEventArgs e)
    {

    }
    protected void DgBM_ItemDataBound(object sender, DataGridItemEventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {

    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值