如何使用单个搜索框（文本框）搜索应该位于gridview的一行或两行中的值列表？ [英] how can I search list of values that should be either in one or both rows from gridview by using single search box(text box)?

问题描述

我有一个搜索框，我想要搜索一个或两个（Skill和SkillArea）行中的值。我正在使用sqldatasource和gridview，我也尝试了一个代码，但它不工作 -

< asp：SqlDataSource ID =SqlDataSource1runat =serverConnectionString =<％$ ConnectionStrings：RagistrationConnectionString％> SelectCommand =SELECT * FROM [RUPLOAD] WHERE（（[Skill] LIKE'％'+ @ Skill +'％'）+（[SkillArea] LIKE'％'+ @ SkillArea +'％'））>

< SelectParameters>

< asp：ControlParameter ControlID =TextBox1Name =SkillPropertyName =TextType =StringDefaultValue =％/>

< asp：ControlParameter ControlID =TextBox1Name =SkillAreaPropertyName =TextType =StringDefaultValue =％/>

< / SelectParameters>

解决方案

ConnectionStrings：RagistrationConnectionString％>SelectCommand =SELECT * FROM [RUPLOAD] WHERE（（[Skill] LIKE'％'+ @ Skill +' ％'）+（[SkillArea] LIKE'％'+ @ SkillArea +'％'））>

< SelectParameters>

< asp：ControlParameter ControlID = TextBox1Name =SkillPropertyName =TextType =StringDefaultValue =％/>

< asp：ControlParameter ControlID =TextBox1Name =SkillAreaPropertyName =TextType =StringDefaultValue =％/>

< / SelectParameters>

尝试将答案中的代码复制到你之前的这个问题的副本 [ ^ ]正确。



您之间已经替换了 OR 条件 + ：

  SELECT  *  FROM  [RUPLOAD]  WHERE （（[Skill]  LIKE  ' ％' + @ Skill + ' ％'） 或 （[SkillArea]  LIKE  ' ％' + @ SkillArea + ' ％））

I have a one search box and i want to search a value which should be either in one or both(Skill and SkillArea)rows.I'm using sqldatasource with gridview and i also tried a code as well but its not working-
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RagistrationConnectionString %>" SelectCommand="SELECT * FROM [RUPLOAD] WHERE (([Skill] LIKE '%' +@Skill+ '%') + ([SkillArea] LIKE '%' +@SkillArea+ '%'))">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="Skill" PropertyName="Text" Type="String" DefaultValue="%" />
<asp:ControlParameter ControlID="TextBox1" Name="SkillArea" PropertyName="Text" Type="String" DefaultValue="%"/>
</SelectParameters>

解决方案

ConnectionStrings:RagistrationConnectionString %>" SelectCommand="SELECT * FROM [RUPLOAD] WHERE (([Skill] LIKE '%' +@Skill+ '%') + ([SkillArea] LIKE '%' +@SkillArea+ '%'))">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="Skill" PropertyName="Text" Type="String" DefaultValue="%" />
<asp:ControlParameter ControlID="TextBox1" Name="SkillArea" PropertyName="Text" Type="String" DefaultValue="%"/>
</SelectParameters>

Try copying the code from the answer to your previous copy of this question[^] correctly.

You've replaced OR between the conditions with a +:

SELECT * FROM [RUPLOAD] WHERE (([Skill] LIKE '%' +@Skill+ '%') OR ([SkillArea] LIKE '%' +@SkillArea+ '%'))

这篇关于如何使用单个搜索框（文本框）搜索应该位于gridview的一行或两行中的值列表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！