title: How to filter gridview from textbox?
body: <p>I need to filter a gridview that retreives filtered data from a table. Therefore I bound the gridview to a dataset. Now i can't seem to find a solution to filter it further.</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
  if (!IsPostBack)
      {
          DataSet ds = new DataSet();
          SqlConnection myCon = new SqlConnection(connectionstring);
          SqlDataAdapter adapter = new SqlDataAdapter(cmd, myCon);
          adapter.Fill(ds);
          GridView1.DataSource = ds;
          GridView1.DataBind();
      }
  }
  protected void Button1_Click(object sender, EventArgs e)
  {
  //need to insert code here for filtering GridView1 based on TextBox1.Text        
  }
  </code></pre>
  
  <p>Thanks for the help.</p>