GridView进行Sort

最新推荐文章于 2021-01-26 23:57:34 发布

oushine

最新推荐文章于 2021-01-26 23:57:34 发布

阅读量245

点赞数

分类专栏： ASP.NET 文章标签： string sorting object

本文链接：https://blog.csdn.net/oushine/article/details/5855202

版权

ASP.NET 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

GridView进行排序
1、设置AllowSort= true;
2、然后
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["SortOrder"] = "EmpID";
            ViewState["OrderDire"] = "ASC";
            bind();
        }

    }
    public void bind()
    {
        string sqlStr = "select * from Employee";
        DataView myView = Common.dataView(sqlStr);
        string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
        myView.Sort = sort;
        GridView1.DataSource = myView;
        GridView1.DataKeyNames = new string[] { "ID" };
        GridView1.DataBind();
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string sPage = e.SortExpression;
        if (ViewState["SortOrder"].ToString() == sPage)
        {
            if (ViewState["OrderDire"].ToString() == "DESC")
                ViewState["OrderDire"] = "ASC";
            else
                ViewState["OrderDire"] = "DESC";
        }
        else
        {
            ViewState["SortOrder"] = e.SortExpression;
        }
        bind();
    }