GridView pagging not working

See more:

C#3.0

C#

I have a image button which when clicked executes the gridview codes as shown below:

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
        {
            //SiteMaster master = (SiteMaster)this.Master;
            if (PageMaster.CheckErrors())
            {
                GridView2.Visible = false;
                gvsearch.Visible = true;
                txtsearch.Dispose();
                string search = txtsearch.Text.ToString();
                gvsearch.Columns[6].Visible = true;
                gvsearch.Columns[7].Visible = true;
                gvsearch.Columns[8].Visible = true;

                gvsearch.DataSource = DataBase2.myProcedureName(search,username);
                gvsearch.DataBind();
                gvsearch.Columns[6].Visible = false;
                gvsearch.Columns[7].Visible = false;
                gvsearch.Columns[8].Visible = false;


            }
        }

However though i have set the pagging properties in visual studio 2010 the pagging feature is not working and always stays on the 1st page with out giving any errors;
for pagging i have tried this way:

protected void gvsearch_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
           //SiteMaster master = (SiteMaster)this.Master;
            if (PageMaster.CheckErrors())
            {
                GridView2.Visible = false;
                gvsearch.Visible = true;
                txtsearch.Dispose();
                string search = txtsearch.Text.ToString();
                gvsearch.Columns[6].Visible = true;
                gvsearch.Columns[7].Visible = true;
                gvsearch.Columns[8].Visible = true;

                gvsearch.DataSource = DataBase2.myProcedureName(search, username);
                gvsearch.DataBind();
                gvsearch.Columns[6].Visible = false;
                gvsearch.Columns[7].Visible = false;
                gvsearch.Columns[8].Visible = false;
            }

        }

thanks