SqlPager控件使用心得[续]

应一些朋友的邀请,我在这里写我的一些使用和修改SqlPager的详细说明:
1.要使用SqlPager首先要导入您已经修改好的SqlPager.DLL
2.在页面的前台:

<%@ Register TagPrefix="cc1" Namespace="HLSqlPager" Assembly="sqlpager" %>

<cc1:sqlpager id="SqlPager1" runat="server" ConnectionString="server=(local);database=test;uid=sa;pwd=123"
                                        ItemsPerPage="12" ControlToPaginate="dg" Width="250px" SortMode="DESC"></cc1:sqlpager>

<asp:datagrid id="dg" runat="server" Width="100%" BorderWidth="0" ShowHeader="False" AutoGenerateColumns="False">
                                        <ItemStyle BorderWidth="0"></ItemStyle>
                                        <Columns>
                                                                                    </Columns>
                                    </asp:datagrid>

<cc1:sqlpager id="SqlPager2" runat="server" ConnectionString="server=(local);database=test;uid=sa;pwd=123"
                                        ItemsPerPage="12" ControlToPaginate="dg" Width="250px"></cc1:sqlpager>

注意:ControlToPaginate="dg"  这里的dg是你要绑定数据的控件名(只能是DataGrid 或者DataList)

3.后台数据绑定函数

/**//// <summary>
        /// SqlPager数据绑定到指定控件
        /// </summary>
        /// <param name="SQL">指定查询SQL</param>
        /// <param name="sortfield">排序字段</param>
        /// <param name="sortmode">排序方法</param>
        private void BindGrid(string SQL,string sortfield,string sortmode)
        {                    
            SqlPager1.SelectCommand=SQL;
            SqlPager2.SelectCommand=SQL;
            SqlPager1.SortField=sortfield;
            SqlPager2.SortField=sortfield;
            if(sortmode=="DESC")
            {
                SqlPager1.SortMode=HLSqlPager.SortMode.DESC;
                SqlPager2.SortMode=HLSqlPager.SortMode.DESC;
            }
            else
            {
                SqlPager1.SortMode=HLSqlPager.SortMode.ASC;
                SqlPager2.SortMode=HLSqlPager.SortMode.ASC;
            }            
            HLSqlPager.SqlPager sqlp=new HLSqlPager.SqlPager();
            
            this.DataBind();
        }

4.两个SqlPager联动

private void sql1_pager(object sender, HLSqlPager.PageChangedEventArgs e)
        {
            SqlPager2.CurrentPageIndex=SqlPager1.CurrentPageIndex;
            SqlPager2.DataBind();
        }

        private void sql2_pager(object sender, HLSqlPager.PageChangedEventArgs e)
        {
            SqlPager1.CurrentPageIndex=SqlPager2.CurrentPageIndex;
            SqlPager1.DataBind();
        }

private void InitializeComponent()
        {                         this.SqlPager1.PageIndexChanged += new HLSqlPager.SqlPager.PageChangedEventHandler(this.sql1_pager);
            this.SqlPager2.PageIndexChanged += new HLSqlPager.SqlPager.PageChangedEventHandler(this.sql2_pager);
            this.Load += new System.EventHandler(this.Page_Load);

        }

5.切图

6.说明
您可以按照自己的需要对SqlPager进行修改
原版下载地址:下载本文的源代码（英文）