How to bind grid view only button clicked

Question

i want to display grid view only when button is clickedif i refresh the page should not display the grid view display only button...how to do this?

Ramesh Palanivel · Answer

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 tablenamecon); sdr.Fill(ds); gridview1.datasource=ds.tables[0]; con.close(); } // Page On Load page_onload() { gridview1.datasource=null; }

Mohan Srinivas · Answer

can you say some example?

Ramesh Palanivel · Answer

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