使用c＃的gridview中的Asp.net [英] Asp.net in gridview using c#

问题描述

在gridview中，标题模板可以在过滤器参数中设置，在gridview中的绑定值中搜索TextBox1。



例如_

In gridview Header Template can set in Filter Parameters in search for TextBox1 in bind values in gridview.

For Example_1

<HeaderTemplate>
<asp:Label ID="Label14" runat="server" Text="StatusId"></asp:Label>
<br />
 <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox>
   </HeaderTemplate>

它正在工作

It''s working

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:printapp_apr_2ConnectionString %>" SelectCommand="gridFill" FilterExpression="(fileName like '{0}%' or '{0}' ='-1') AND (fileDetails like '{1}%' or '{1}' ='-1') AND (createdOn='{2}' or '{2}'='-1') AND (statusName ='{3}' or '{3}' ='-1') " SelectCommandType="StoredProcedure">
   <FilterParameters>
   <asp:ControlParameter Name="fileName" ControlID="TextBox6" PropertyName="Text" Type="String" DefaultValue="-1" />
   <asp:ControlParameter Name="fileDetails" ControlID="TextBox7" PropertyName="Text" Type="String" DefaultValue="-1" />
     <asp:ControlParameter Name="createdOn" ControlID="TextBox8" PropertyName="Text" Type="String" DefaultValue="-1" />
     <asp:ControlParameter Name="statusName" ControlID="DropDownList1" PropertyName="SelectedValue" Type="String" DefaultValue="-1" />
   </FilterParameters>
</asp:SqlDataSource>

Can able to use in HeaderTemplate in filterParameters in gridview in textbox...

<pre><HeaderTemplate Name="fileName" ControlID="TextBox6" PropertyName="Text" Type="String" DefaultValue="-1" />

有可能在gridview中的HeaderTemplate中搜索

there any possible to search in HeaderTemplate in gridview

推荐答案

ConnectionStrings：printapp_apr_2ConnectionString < span class =code-pagedirective>％> SelectCommand = gridFill FilterExpression = （fileName类似于{0}％或{0 }'=' - 1'）AND（fileDetails如'{1}％'或'{1}'=' - 1'）AND（createdOn ='{2}'或'{2}'=' - 1' ）AND（statusName ='{3}'或'{3}'=' - 1'） SelectCommandType = StoredPr ocedure >
< FilterParameters >
< asp：ControlParameter 名称 = fileName ControlID = TextBox6 PropertyName = 文字 类型 = 字符串 De faultValue = - 1 / >
< asp：ControlParameter 名称 < span class =code-keyword> = fileDetails ControlID = TextBox7 PropertyName = 文字 类型 = 字符串 DefaultValue = - 1 / >
< asp：ControlParameter 名称 = createdOn ControlID = TextBox8 PropertyName = 文本 类型 = 字符串 DefaultValue = - 1 / >
< asp：ControlParameter 名称 = statusName ControlID = DropDownList1 PropertyName = SelectedValue 类型 = 字符串 DefaultValue = - 1 / >
< / FilterParameters >
< / asp：SqlDataSource >

能够在文本框中gridview的filterParameters中的HeaderTemplate中使用...

< pre > < HeaderTemplate 名称 = fileName ControlID = TextBox6 PropertyName = 文字 类型 < span class =code-keyword> = 字符串 DefaultValue = - 1 / >

ConnectionStrings:printapp_apr_2ConnectionString %>" SelectCommand="gridFill" FilterExpression="(fileName like '{0}%' or '{0}' ='-1') AND (fileDetails like '{1}%' or '{1}' ='-1') AND (createdOn='{2}' or '{2}'='-1') AND (statusName ='{3}' or '{3}' ='-1') " SelectCommandType="StoredProcedure"> <FilterParameters> <asp:ControlParameter Name="fileName" ControlID="TextBox6" PropertyName="Text" Type="String" DefaultValue="-1" /> <asp:ControlParameter Name="fileDetails" ControlID="TextBox7" PropertyName="Text" Type="String" DefaultValue="-1" /> <asp:ControlParameter Name="createdOn" ControlID="TextBox8" PropertyName="Text" Type="String" DefaultValue="-1" /> <asp:ControlParameter Name="statusName" ControlID="DropDownList1" PropertyName="SelectedValue" Type="String" DefaultValue="-1" /> </FilterParameters> </asp:SqlDataSource> Can able to use in HeaderTemplate in filterParameters in gridview in textbox... <pre><HeaderTemplate Name="fileName" ControlID="TextBox6" PropertyName="Text" Type="String" DefaultValue="-1" />

有可能在gridview中的HeaderTemplate中搜索

there any possible to search in HeaderTemplate in gridview

这篇关于使用c＃的gridview中的Asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！