ต้องการ sort ข้อมูลใน gridview อะค่ะ คือคลิกตรงหัวคอลัมน์ แล้วมันจะ sort ตาม คอลัมน์นั้น

AllowSorting="True" OnSorting="SortCommand"

private void BindData2()
        {
            string strSQL = "SELECT AnimalID, AnName, AnType FROM Animal ORDER BY " + strFields + " ASC";
            DataSet ds;
            ds = DB.QueryDataSet(strSQL);

            myGridView.DataSource = ds.Tables[0];
            myGridView.DataBind();
            DB.Close();
        }

        void SortCommand(Object s, GridViewSortEventArgs e)
        {
            strFields = e.SortExpression;
            BindData2();
        }

        void myGridView_RowDataBound(Object s, GridViewRowEventArgs e)
        {
            //*** AnimalID ***//
            Label lblAnimalID = (Label)(e.Row.FindControl("lblAnimalID"));
            if (lblAnimalID != null)
            {
                lblAnimalID.Text = (string)DataBinder.Eval(e.Row.DataItem, "AnimalID");
            }

            //*** AnName ***//
            Label lblAnName = (Label)(e.Row.FindControl("lblAnName"));
            if (lblAnName != null)
            {
                lblAnName.Text = (string)DataBinder.Eval(e.Row.DataItem, "AnName");
            }

            //*** AnType ***//
            Label lblAnType = (Label)(e.Row.FindControl("lblAnType"));
            if (lblAnType != null)
            {
                lblAnType.Text = (string)DataBinder.Eval(e.Row.DataItem, "AnType");
            }
       }


<asp:GridView id="myGridView" runat="server"   
	AllowSorting="True" OnSorting="SortCommand"
	AutoGenerateColumns="False" onRowDataBound="myGridView_RowDataBound">
	<Columns>

	<asp:TemplateField SortExpression="AnimalID"  HeaderText="AnimalID">
		<ItemTemplate>
			<asp:Label id="lblAnimalID" runat="server"></asp:Label>
		</ItemTemplate>
	</asp:TemplateField>
    
    <asp:TemplateField SortExpression="AnName"  HeaderText="AnName">
		<ItemTemplate>
			<asp:Label id="lblAnName" runat="server"></asp:Label>
		</ItemTemplate>
	</asp:TemplateField>

	<asp:TemplateField SortExpression="AnType" HeaderText="AnType">
		<ItemTemplate>
			<asp:Label id="lblAnType" runat="server"></asp:Label>
		</ItemTemplate>
	</asp:TemplateField>

	</Columns>
</asp:GridView>