！求助

Question

在gridview中加一个按钮，是排序的，请问怎么写代码

Answer 1

那sql在重新写一下？不过我写了效果好像不对

Answer 2

GridView1.Sort("ProductName", SortDirection.Ascending);

Answer 3

将gridview的数据源绑定为DataView对象，该对象的Sort属性支持排序，这样就不用写sql语句排序了，效率也高的多

Answer 4

        private void GridView_Sorting(object sender, GridViewSortEventArgs e)
        {
            //this.Sort("id", SortDirection.Ascending);
            if (ViewState["sort"] == null)
            {
                ViewState["sort"] = e.SortExpression;
            }
            else
            {
                if (e.SortExpression.ToLower().IndexOf("desc") == -1)
                {
                    if (ViewState["sort"].ToString() == e.SortExpression)
                    {
                        ViewState["sort"] = e.SortExpression + " desc";
                    }
                    else
                    {
                        ViewState["sort"] = e.SortExpression;
                    }
                }
                else
                {
                    if (ViewState["sort"].ToString() == e.SortExpression)
                    {
                        ViewState["sort"] = e.SortExpression.Substring(0, e.SortExpression.Length - 5);
                    }
                    else
                    {
                        ViewState["sort"] = e.SortExpression;
                    }
                }            }
            this.MyBind();
        }
在MyBind里面设置dataView的sort