VB.NET – SQL statement “LIKE”

Input box

Please enter customer first or last name:

<asp:RequiredFieldValidator ID="ReqSearchfor" runat="server" 
    ErrorMessage="<font color='red'>Input box can not be empty!
</font>" 
    ControlToValidate="SearchFor" >
<asp:TextBox ID="SearchFor" runat="server">
<asp:Button ID="SearchBtn" runat="server" Text="Search" />

SQL DataSource Design

<asp:SqlDataSource ID="SearchResults" 
        runat="server" ConnectionString="< %$ myConString %>" 
        SelectCommand="SELECT * FROM [CustomerTbl] WHERE 
                      ([customer_name] LIKE '%' + @customer_name + '%')" 
        <SelectParameters>
             <asp:ControlParameter ControlID="SearchFor" Name="customer_name" 
                 PropertyName="Text" Type="String" />
        </SelectParameters>  
</asp:SqlDataSource>