GridView字段排序

一原代码 

   public SortDirection GridViewSortDirection
        {//属性设置
            get
            {
                if (ViewState["sortDirection"] == null)
                {
                    ViewState["sortDirection"] = SortDirection.Ascending;
                }
                return (SortDirection)ViewState["sortDirection"];
            }
            set
            {
                ViewState["sortDirection"] = value;
            }
        }
        protected void GridView2_Sorting(object sender, GridViewSortEventArgs e)
        {//GridView的sorting事件
            string sortExpression = e.SortExpression;
            if (GridViewSortDirection == SortDirection.Ascending)
            {
                GridViewSortDirection = SortDirection.Descending;
                SortGridView(sortExpression, "DESC");
            }
            else
            {
                GridViewSortDirection = SortDirection.Ascending;
                SortGridView(sortExpression, "ASC");
            }
        }

        private void SortGridView(string sortExpression, string sortdirection)
        {//自定义一个函数，
            sql = string.Format("SELECT [order].ordering_time, [order].order_id, dealer.dealer_name, [order].num, [order].TotalPrice, [order].TotalVolume, [order].TotalWeight, [order].sendMoney, [order].order_state, [order].order_compele_time FROM [order] INNER JOIN dealer ON [order].dealer_id = dealer.dealer_id where [order].order_state!='" + orderState + "' and dealer.dealer_id in(select dealer_id from dealer where dealer_eare='{4}') and [order].order_id LIKE '%{0}%' and dealer.dealer_name like '%{1}%'and [order].order_state like '%{2}%' and dealer.dealer_eare like '%{3}%' ", papaValue[0], papaValue[1], papaValue[2], papaValue[5],Eare);
            OrderList OL = new OrderList();
            DataView dv = OL.getOrderListBySQL(sql);

            this.GridView1.DataSource = dv;

            dv.Sort = sortExpression + " " + sortdirection;

            GridView1.DataSource = dv;
            this.GridView1.DataBind();
        }
        protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {//翻页功能实现
            GridView1.PageIndex = e.NewPageIndex;
            // this.backdatast();
            ViewBind(papaValue);
        }

二、AllSorting设成True

三、把排序字段转成TemplateField