gridview sort


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
           GridView1.DataSource= getDate();
           GridView1.DataBind();
        }
    }

    public DataTable getDate()
    {
        DataTable dt;
         string conString="server=server01;database=test;uid=sa;pwd=sql";
         using (SqlConnection con = new SqlConnection(conString))
         {
             con.Open();
             using(SqlCommand cmd = new SqlCommand("select * from tab",con))
             {
                using(SqlDataReader reader=cmd.ExecuteReader())
                {
                    dt = new DataTable();
                    //填充数据
                    dt.Load(reader, LoadOption.OverwriteChanges);
                }
             }
         }
         return dt;
        
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        if ((string)this.ViewState["Sort"]!= e.SortExpression)
        {
            this.ViewState["Sort"] = e.SortExpression;
        }
        else
        {
            this.ViewState["Sort"] = e.SortExpression + " " + "DESC";
        }

        DataTable dt = new DataTable();
        dt = getDate();
        dt.DefaultView.Sort = ViewState["Sort"].ToString();
        GridView1.DataSource = dt.DefaultView;
        GridView1.DataBind();
        
    }
}

posted on 2009-01-19 10:48  小灰熊  阅读(255)  评论(0编辑  收藏  举报

导航