I want to search values on bases of multiple keyword search.I used sqldatasource and gridview control.When I'm searching value from one text bo its working properly but when I'm using two text bxes to get more expected reasult than its not working
For searching from 1 text box i'm using-
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RagistrationConnectionString %>" SelectCommand="SELECT [FirstName], [LastName], [State], [City], [SkillArea], [Skill], [WorkAuthorizationStatus], [ExpectedSalary] FROM [Resumeview] WHERE Skill Like '%' +@Skill+ '%' ">
<SelectParameters>
<asp:ControlParameter ControlID="TextBoxS" Name="Skill" PropertyName="Text" Type="String" DefaultValue="%"/>
</SelectParameters>
Which is working fine but when i'm searcching from 2 text boxes and I'm using-
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RagistrationConnectionString %>" SelectCommand="SELECT [FirstName], [LastName], [State], [City], [SkillArea], [Skill], [WorkAuthorizationStatus], [ExpectedSalary] FROM [Resumeview] WHERE Skill Like '%' +@Skill+ '%' ">
<SelectParameters>
<asp:ControlParameter ControlID="TextBoxS" Name="Skill" PropertyName="Text" Type="String" DefaultValue="%"/>
<asp:ControlParameter ControlID="TextBoxSA" Name="SkillArea" PropertyName="Text" Type="String" DefaultValue="%"/>
</SelectParameters>
its not working