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>