ASP.NET GridView分页及排序 源代码

//.cs 文件部分代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

 

public partial class BasicInfo_Product : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

{

//绑定数据

  strQuery = "SELECT * FROM JXNF_PRODUCT ";

  DataView dv = PlatForm.NamedObjects.NonTransactionDatabaseAgent.ExecuteDataView(strQuery);

            dv.Sort = "PRODUCTID DESC";

            GridViewMain.PageIndex = Convert.ToInt32(this.Session["page"]);

            GridViewMain.DataSource = dv;

            GridViewMain.DataBind();

        

            this.ViewState["sort"] = "PRODUCTID";

            this.ViewState["sortDerect"] = "DESC";

            this.ViewState["strSql"] = strQuery;

           

          

        }

    }

  

    protected void LinkButtongo_Click(object sender, EventArgs e)

    {

        //跳转

        String strQuery = this.ViewState["strSql"].ToString();

        TextBox textBoxpage = (TextBox)GridViewMain.BottomPagerRow.Cells[0].FindControl("TextBoxpage");

        if (textBoxpage.Text == "")

        {

            GridViewMain.PageIndex = 0;

        }

        else