关于GRIDVIEW里的ONSORTING事件，我点了他只是刷新，不排序

[灬上海爽爷]

各位大大，大家好，小弟刚从ASP转向ASP.NET,现在把代码贴上
aspx里：

    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"  
            AutoGenerateColumns="False" PageSize="10" 
            AllowSorting="true" DataKeyNames="Id" 
            onrowdatabound="GridView1_RowDataBound" 
            onrowupdating="GridView1_RowUpdating" 
            onrowcancelingedit="GridView1_RowCancelingEdit" 
            onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
            onpageindexchanging="GridView1_PageIndexChanging" 
            onsorting="gvsort">
            <Columns>
                <asp:TemplateField HeaderText="Id" SortExpression="Id" ItemStyle-Width="170px">
                    <ItemTemplate>
                        <asp:label runat="server" ID="lblId" Text='<%# Eval("Id") %>'></asp:label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:label runat="server" ID="txtId" Text='<%# Bind("Id") %>'></asp:label>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="姓名" SortExpression="Name" ItemStyle-Width="170px">
                    <ItemTemplate>
                        <asp:label runat="server" ID="lblName" Text='<%# Eval("Name") %>'></asp:label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox runat="server" ID="txtName" Text='<%# Bind("Name") %>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="密码" SortExpression="Password" ItemStyle-Width="170px">
                    <ItemTemplate>
                        <asp:label runat="server" ID="lblPassword" Text='<%# Eval("Password") %>'></asp:label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox runat="server" ID="txtPassword" Text='<%# Bind("Password") %>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="电话" SortExpression="Tel" ItemStyle-Width="170px">
                    <ItemTemplate>
                        <asp:label runat="server" ID="lblTel" Text='<%# Eval("Tel") %>'></asp:label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox runat="server" ID="txtTel" Text='<%# Bind("Tel") %>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="介绍" SortExpression="Intro" ItemStyle-Width="170px">
                    <ItemTemplate>
                        <asp:label runat="server" ID="lblIntro" Text='<%# Eval("Intro") %>'></asp:label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox runat="server" ID="txtIntro" Text='<%# Bind("Intro") %>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                 <asp:TemplateField HeaderText="操作" ItemStyle-Width="170px">        
                    <ItemTemplate>                                            
                        <asp:LinkButton ID="btnEdit"  runat="server" CommandName="Edit">编辑</asp:LinkButton>
                        <asp:LinkButton ID="btnDelete"  runat="server" CommandName="Delete" OnClientClick="return confirm('您确定要删除吗？')">删除</asp:LinkButton>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:LinkButton ID="btnUpdate"  runat="server" CommandName="Update">更新</asp:LinkButton>
                        <asp:LinkButton ID="btnCancel"  runat="server" CommandName="Cancel">取消</asp:LinkButton>
                    </EditItemTemplate>                          
                </asp:TemplateField>
            </Columns>
            <PagerSettings Mode="NextPreviousFirstLast" FirstPageText="首页" LastPageText="末页" NextPageText="下一页" PreviousPageText="上一页" />
        </asp:GridView>
        <a href="UserAdd.aspx" target="_blank">添加人员</a>      
    </div>
    </form>

.cs里：

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Bind();//绑定gridview的方法
            }
        }

        private void Bind() 
        {
        SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyTestConnectionString"].ConnectionString);
 string sql = "select * FROM [User] order by " + ViewState["SortExpression"]; //这边报错说by附近语法错误
        SqlDataAdapter adapter = new SqlDataAdapter(sql, Conn);
        Conn.Open();
        DataSet ds = new DataSet();
        adapter.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
        Conn.Close();
        }
        protected void gvsort(object sender, GridViewSortEventArgs e)
        {
            if (ViewState["Order "] == null)
            {
                ViewState["Order "] = "ASC ";
            }
            else
            {
                if (ViewState["Order "].ToString() == "ASC ")
                {
                    ViewState["Order "] = "DESC ";
                }
                else
                {
                    ViewState["Order "] = "ASC ";
                }
            }
            Bind();
        } 

没关系的我就不贴了，报错的地方在CS里，我注释了

[灬上海爽爷]

怎么没有人呀，好像是ORDER BY 后面的东西传不过来，谁知道怎么写呀

[fengyunshier]

如果像你所说的话，那可能是ViewState["SortExpression"]的值有问题。你调试看一下，看它的值是否是排序字段

[LeonXLee]

方法已PM，请注意查收

[灬上海爽爷]

已收到，非常感谢