vs2008DataGrid排序要点

如果自定义列，而不是自动产生的列，就需要用户自动定义：sortingExpression="属性名"

AllowSorting="True" onsorting="GridView1_Sorting"

 

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
            sortingstring = e.SortExpression;
            loadgrid();
        }

 

 

void loadgrid()
        {                   
            DataSet ds = new DataSet();
            string strSQL = "select * from  products where categoryid="+DropDownList1.SelectedValue;
            OracleDataAdapter da = new OracleDataAdapter(strSQL, constr);
            da.Fill(ds, producttablename);
            DataTable dt = ds.Tables[producttablename];
            DataView dv = new DataView(dt);
            dv.Sort = sortingstring;
            GridView1.DataSource = dv;
            GridView1.DataBind();
        }