我想从gridview中获取多个选择的值 [英] I want a value from gridview on multiple slection
问题描述
我想在多个关键字搜索的基础上搜索值。我使用sqldatasource和gridview控件。当我从一个文本中搜索值时,它正常工作但是当我使用两个文本bxes获得更多预期的结果时它不工作
从1个文本框中搜索我正在使用 -
< asp:SqlDataSource ID =SqlDataSource1runat = serverConnectionString =<%$ ConnectionStrings:RagistrationConnectionString%> SelectCommand =SELECT [FirstName],[LastName],[State],[City],[SkillArea],[Skill],[WorkAuthorizationStatus],[ExpectedSalary] FROM [Resumeview] WHERE Skill Like'%'+ @ Skill +'% '>
< SelectParameters>
< asp:ControlParameter ControlID =TextBoxSName =SkillPropertyName =TextType =StringDefaultValue =%/>
< / SelectParameters>
哪个工作正常但是什么时候我正在从2个文本框中进行搜索,我正在使用 -
< asp:SqlDataSource ID =SqlDataSource1runat =serverConnectionString =< %$ ConnectionStrings:RagistrationConnectionString%> SelectCommand =SELECT [FirstName],[LastName],[State],[City],[SkillArea],[Skill],[WorkAuthorizationStatus],[ExpectedSalary] FROM [Resumeview] WHERE Skill Like'%'+ @ Skill +'% '>
< SelectParameters>
< asp:ControlParameter ControlID =TextBoxSName =SkillPropertyName =TextType =StringDefaultValue =%/>
< asp:ControlParameter ControlID =TextBoxSAName =SkillAreaPropertyName =TextType =StringDefaultValue =%/>
< / SelectParameters>
无效
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
推荐答案
ConnectionStrings:RagistrationConnectionString%>SelectCommand =SELECT [FirstName],[LastName],[State],[City],[SkillArea],[Skill],[WorkAuthorizationStatus],[ExpectedSalary] FROM [Resumeview ]技能如'%'+ @技能+'%'>
< SelectParameters>
< asp:ControlParameter ControlID =TextBoxSName =SkillPropertyName =TextType =StringDefaultValue =%/>
< / SelectParameters>
哪个工作正常,但当我从2个文本框中搜索并且我正在使用 -
< asp:SqlDataSource ID =SqlDataSource1runat =serverConnectionString =<%
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 =TextBoxSName =SkillPropertyName =TextType =StringDefaultValue =%/ >
< asp:ControlParameter ControlID =TextBoxSAName =SkillAreaPropertyName =TextType =String默认值值=%/>
< / SelectParameters>
无法正常工作
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
即使您将值传递给Control参数,您的Select命令也会相同,并尝试将其更改为
SELECT [FirstName] ,[LastName],[State],[City],[SkillArea],[Skill],[WorkAuthorizationStatus],[ExpectedSalary] FROM [Resumeview] WHERE Skill like'%'+ @ Skill +'%'或SkillArea Like'%' + @ SkillArea +'%'
Even though you are passing value to Control parameter your Select command is same in both try to change it as
SELECT [FirstName], [LastName], [State], [City], [SkillArea], [Skill], [WorkAuthorizationStatus], [ExpectedSalary] FROM [Resumeview] WHERE Skill Like '%' +@Skill+ '%' or SkillArea Like '%' +@SkillArea+ '%'
这篇关于我想从gridview中获取多个选择的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!