title: String TextBox1 text in a search parameter in SQL statement
body: <p>I have the following Gridview which I am trying to pass a search parameter, to update the results based on that search -</p>
  
  <pre><code>&lt;ContentTemplate&gt;
  &lt;asp:TextBox ID="TextBox1" runat="server"&gt;&lt;/asp:TextBox&gt;
  &lt;asp:Button ID="Button1" runat="server" Text="Search" /&gt;
  &lt;asp:Label ID="Label1" runat="server" Text="Grid not refreshed yet."&gt;&lt;/asp:Label&gt;&lt;br /&gt;
  &lt;asp:Label ID="Label4" runat="server" Text="(Grid Will Referesh after Every Second)"Font-Bold="true"&gt;&lt;/asp:Label&gt;     
  &lt;br /&gt;&lt;br /&gt;
  &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
          ConnectionString="&lt;%$ ConnectionStrings:MyDbConn %&gt;" 
           SelectCommand="SELECT * FROM [table] WHERE BODYTEXT LIKE='"+TextBox1.text+"&gt;&lt;/asp:SqlDataSource&gt;  
  
      &lt;asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
          BackColor="Black" DataSourceID="SqlDataSource1" Font-Names="Arial Black" 
          Font-Size="Small" ForeColor="White" Height="650px" Width="930px"&gt;
      &lt;/asp:GridView&gt;
  &lt;/ContentTemplate&gt;
  </code></pre>
  
  <p>However I cant seem to get the SQL statement to accept the TextBox1 text that the user is entering, how can I resolve this?</p>