ASP.NET实现增删改查等功能(Access版)系统之三-分页及排序

/// <summary>

    /// 分页技术,触发事件

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void gridViewPublishers_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

       

        GridView1.DataSource = SortDataTable(GridView1.DataSource as DataTable, true);

        GridView1.PageIndex = e.NewPageIndex;

        GridView1.DataBind();

       

    }

    /// <summary>

    /// 分页实现

    /// </summary>

    /// <param name="dataTable"></param>

    /// <param name="isPageIndexChanging"></param>

    /// <returns></returns>

    protected DataView SortDataTable(DataTable dataTable, bool isPageIndexChanging)

    {

        if (dataTable != null)

        {

 

            DataView dataView = new DataView(dataTable);

 

            if (GridViewSortExpression != string.Empty)

            {

 

                if (isPageIndexChanging)

                {

 

                    dataView.Sort = string.Format("{0} {1}", GridViewSortExpression, GridViewSortDirection);

 

                }

 

                else

                {

 

                    dataView.Sort = string.Format("{0} {1}", GridViewSortExpression, GetSortDirection());

 

                }

 

            }

 

            return dataView;

 

        }

 

        else

        {

 

            return new DataView();

 

        }

 

    }

    private string GridViewSortExpression

    {

        get { return ViewState["SortExpression"] as string ?? string.Empty; }

        set { ViewState["SortExpression"] = value; }

    }

    private string GridViewSortDirection

    {

        get { return ViewState["SortDirection"] as string ?? "ASC"; }

        set { ViewState["SortDirection"] = value; }

    }

    private string GetSortDirection()

    {

        switch (GridViewSortDirection)

        {

            case "ASC":

                GridViewSortDirection = "DESC";

                break;

 

            case "DESC":

                GridViewSortDirection = "ASC";

                break;

        }

 

        return GridViewSortDirection;

    }

 

    protected void gridViewPublishers_Sorting(object sender, GridViewSortEventArgs e)

    {

       

         GridViewSortExpression = e.SortExpression;

         int pageIndex = GridView1.PageIndex;

         GridView1.DataSource = SortDataTable(GridView1.DataSource as DataTable, false);

         GridView1.DataBind();

         GridView1.PageIndex = pageIndex;

       

    }

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值