title: Improving search function
body: <p>I have a search btxtbox with button to search for data in the Gridview. I'm not using any code behind page but I'm using the select command and Where function and linking them to the parameters  </p>
  
  <p>How can I make the Gridview appear before making the search? 
  I mean before typing and clicking on search for the data to appear.</p>
  
  <p>aspx page :</p>
  
  <pre><code>    SelectCommand="SELECT * FROM;ALLSTAFF; WHERE (USER_NAME; = :USER_NAME)"&gt;
      &lt;SelectParameters&gt;
      &lt;asp:ControlParameter ControlID="txtSearch" Name="USER_NAME" PropertyName="Text" Type="String" /&gt;
     &lt;/SelectParameters&gt;
  </code></pre>