How to bind grid view only button clicked

HI Mohan,

 

Use this code

 

Button_Click(object sender, EventArgs e)    
 {      
  con.open();
sqlconnection con=new sqlconnection("your connection string");
dataset ds=new dataset();
sqldataadapter sdr=new sqldataadapter("select * from tablename",con);
sdr.Fill(ds);
gridview1.datasource=ds.tables[0];
con.close();
  }

// Page On Load

page_onload()
{
gridview1.datasource=null;
}

 

Hi Mohan,

 

Bind the data source for grid view in button click event,

 

In Page load, clear the data grid view data source, which means make the data source as null