一个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;
using System.Data.SqlClient;

public partial class search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
        string a=Request["f"];//参数接受f代表选择类型，t代表参数值
        string flog = Request["t"]; 
        string db="//lovewall//#HX33LoveWall.asp";
        string  conn="server=localhost;database=xuyuan;uid=sa;pwd=sa";
        //string conn = "Provider=Microsoft.Jet.Sql.4.0;Data Source="+Server.MapPath(db);
       //Order By HX33_WishID DESC
        string sql;
        if("r"==a)
            sql = "Select * From [HX33_LoveWallPosts] where HX33_Picker like  '%" + flog + "%'";
        else if ("s" == a)
            sql = "Select * From [HX33_LoveWallPosts]  where HX33_Sender like  '%" + flog + "%'";
        else
            sql = "Select * From [HX33_LoveWallPosts]  where HX33_WishContent like '%"+flog+"%'";

         SqlConnection mycon = new SqlConnection(conn);
         SqlCommand cmd = new SqlCommand(sql,mycon);
        try
        {
           mycon.Open();
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           DataSet ds = new DataSet();
           da.Fill(ds);
      
           GridView1.DataSource = ds.Tables[0].DefaultView;
           GridView1.DataBind();  
          
           mycon.Close();
       }
        catch(Exception ex)
       {
           Response.Write(ex);
        }
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
            //GridView1.PageIndex = e.NewPageIndex;
            //GridView1.DataBind();  //重新绑定GridView数据的函数
        //if (e.NewPageIndex < 0)
        //{
        //    TextBox pageNum = (TextBox)GridView1.BottomPagerRow.FindControl("txtNewPageIndex");
        //    int Pa = int.Parse(pageNum.Text);
        //    if (Pa <= 0)
        //    { GridView1.PageIndex = 0; }
        //    else { GridView1.PageIndex = Pa - 1;
      
        //    }
        //}
        //else { GridView1.PageIndex = e.NewPageIndex; }
        //DataBind();//此处重新绑定
        GridView gvw = (GridView)sender;
        if (e.NewPageIndex < 0)
        {
            TextBox pageNum = (TextBox)gvw.BottomPagerRow.FindControl("txtNewPageIndex");
            int Pa = int.Parse(pageNum.Text);
            if (Pa <= 0)
            { gvw.PageIndex = 0; }
            else { gvw.PageIndex = Pa - 1; }
        }
        else { gvw.PageIndex = e.NewPageIndex;
            DataBind();//此处重新绑定
        }
       
    }

}