how to bind the gridview on textchanged event in asp.net

See more:

ASP.NET

Hi

We have created the functionality when we search on a text-changed occur grid-view should bind on this event ,
I am able to do it for first search but , i have bind as many user search the result should bind in the grid

bind code:

SqlDataAdapter adp = new SqlDataAdapter("select  Countryid ,countryname from tblcountry where Countryid=" + HiddenField1.Value, con);
      DataSet dt = new DataSet();
      adp.Fill(dt);
      gdview.DataSource = dt;
      gdview.DataBind();