我想在gridview中使用TextBox搜索数据 [英] I want to Search Data Using TextBox In gridview
本文介绍了我想在gridview中使用TextBox搜索数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
嗨
在Gridview中我绑定数据库中的所有数据，现在我想使用TextBox搜索数据在gridview中请帮帮我
这里的GridView代码
Hi
In Gridview I bind all data from database , Now I want Search Data using TextBox In gridview Please Help me out
Here the GridView Code
<asp:GridView ID="GridView1" Width="100%" PageSize="10" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Employee_Designation_ID" DataSourceID="View_Designation" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="Employee_Designation_ID" HeaderText="Designation Id" ReadOnly="True" SortExpression="Employee_Designation_ID" />
<asp:BoundField DataField="Employee_Designation_Name" HeaderText="Designation Name" SortExpression="Employee_Designation_Name" />
<asp:BoundField DataField="Per_year_Leave" HeaderText="Paid Leave / Year" SortExpression="Per_year_Leave" />
<asp:BoundField DataField="Charge_per_leave" HeaderText="Charge / Leave" SortExpression="Charge_per_leave" />
<asp:BoundField DataField="Designation_Detail" HeaderText="Detail" SortExpression="Designation_Detail" />
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
<asp:SqlDataSource ID="View_Designation" runat="server" ConnectionString="<%$ ConnectionStrings:CMMS_Standard %>" DeleteCommand="DELETE FROM [Employee_Designation] WHERE [Employee_Designation_ID] = @Employee_Designation_ID" InsertCommand="INSERT INTO [Employee_Designation] ([Employee_Designation_ID], [Employee_Designation_Name], [Per_year_Leave], [Charge_per_leave], [Designation_Detail]) VALUES (@Employee_Designation_ID, @Employee_Designation_Name, @Per_year_Leave, @Charge_per_leave, @Designation_Detail)" ProviderName="<%$ ConnectionStrings:CMMS_Standard.ProviderName %>" SelectCommand="SELECT [Employee_Designation_ID], [Employee_Designation_Name], [Per_year_Leave], [Charge_per_leave], [Designation_Detail] FROM [Employee_Designation]" UpdateCommand="UPDATE [Employee_Designation] SET [Employee_Designation_Name] = @Employee_Designation_Name, [Per_year_Leave] = @Per_year_Leave, [Charge_per_leave] = @Charge_per_leave, [Designation_Detail] = @Designation_Detail WHERE [Employee_Designation_ID] = @Employee_Designation_ID">
<DeleteParameters>
<asp:Parameter Name="Employee_Designation_ID" Type="Byte" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Employee_Designation_ID" Type="Byte" />
<asp:Parameter Name="Employee_Designation_Name" Type="String" />
<asp:Parameter Name="Per_year_Leave" Type="Byte" />
<asp:Parameter Name="Charge_per_leave" Type="Int16" />
<asp:Parameter Name="Designation_Detail" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Employee_Designation_Name" Type="String" />
<asp:Parameter Name="Per_year_Leave" Type="Byte" />
<asp:Parameter Name="Charge_per_leave" Type="Int16" />
<asp:Parameter Name="Designation_Detail" Type="String" />
<asp:Parameter Name="Employee_Designation_ID" Type="Byte" />
</UpdateParameters>
</asp:SqlDataSource>
这里的两个文本框
And Here the Two Textbox
<div class="col-lg-3">
<div class="input-group">
<asp:TextBox ID="Designation_Id_TextBox" runat="server" placeholder="Enter Designation Id" CssClass="form-control"></asp:TextBox>
</div>
<!-- /input-group -->
</div>
<div class="col-lg-3">
<div class="input-group">
<asp:TextBox ID="Designation_Name_TextBox" runat="server" placeholder="Enter Designation Name" CssClass="form-control"></asp:TextBox>
</div>
<!-- /input-group -->
</div>
<div class="col-lg-2">
<asp:Button ID="Search_Button" CssClass="btn btn-default" runat="server" Text="Search" OnClick="Search_Button_Click" />
</div>
我想要当我输入Id时它只显示该Id
I want When i enter Id it show only data of that Id
推荐答案
ConnectionStrings：CMMS_Standard ％> DeleteCommand = DELETE FROM [Employee_Designation] WHERE [Employee_Designation_ID] = @Employee_Designation_ID InsertCommand = INSERT INTO [Employee_Designation]（[Employee_Designation_ID]，[Employee_Designation_Na我，[Per_year_Leave]，[Charge_per_leave]，[Designation_Detail]）VALUES（@ Employee_Designation_ID，@ Employee_Designation_Name，@ Peryeye_Leave，@ Char_per_leave，@ Design_etail） ProviderName = <％
ConnectionStrings:CMMS_Standard %>" DeleteCommand="DELETE FROM [Employee_Designation] WHERE [Employee_Designation_ID] = @Employee_Designation_ID" InsertCommand="INSERT INTO [Employee_Designation] ([Employee_Designation_ID], [Employee_Designation_Name], [Per_year_Leave], [Charge_per_leave], [Designation_Detail]) VALUES (@Employee_Designation_ID, @Employee_Designation_Name, @Per_year_Leave, @Charge_per_leave, @Designation_Detail)" ProviderName="<%
ConnectionStrings：CMMS_Standard.ProviderName ％> SelectCommand = SELECT [Employee_Designation_ID]，[Employee_Designation_Name]，[Per_year_Leave]，[Charge_per_leave]，[Designation_Detail] FROM [Employee_Designation] UpdateCommand = 更新[Employee_Designation] SET [Employee_Designation_Name] = @Employee_Designation_Name，[Per_year_Leave] = @Per_year_Leave，[Charge_per_leave] = @Charge_per_leave，[Designation_Detail] = @Designation_Detail WHERE [Employee_Designation_ID] = @Employee_Designation_ID > ;
< DeleteParameters >
< asp：参数 名称 = Employee_Designation_ID Type=\"< span class=\"code-keyword\">Byte\" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name=\"Employee_Designation_ID\" Type=\"Byte\" />
<asp:Parameter Name=\"Employee_Designation_Name\" Type=\"String\" />
<asp:Parameter Name=\"Per_year_Leave\" Type=\"Byte\" />
<asp:Parameter Name=\"Charge_per_leave\" Type=\"Int16\" />
<asp:Parameter Name=\"Designation_Detail\" Type=\"String\" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name=\"Employee_Designation_Name\" Type=\"String\" />
<asp:Parameter Name=\"Per_year_Leave\" Type=\"Byte\" />
<asp:Parameter Name=\"Charge_per_leave\" Type=\"Int16\" />
<asp:Parameter Name=\"Designation_Detail\" Type=\"String\" />
<asp:Parameter Name=\"Employee_Designation_ID\" Type=\"Byte\" />
</UpdateParameters>
</asp:SqlDataSource>
ConnectionStrings:CMMS_Standard.ProviderName %>" SelectCommand="SELECT [Employee_Designation_ID], [Employee_Designation_Name], [Per_year_Leave], [Charge_per_leave], [Designation_Detail] FROM [Employee_Designation]" UpdateCommand="UPDATE [Employee_Designation] SET [Employee_Designation_Name] = @Employee_Designation_Name, [Per_year_Leave] = @Per_year_Leave, [Charge_per_leave] = @Charge_per_leave, [Designation_Detail] = @Designation_Detail WHERE [Employee_Designation_ID] = @Employee_Designation_ID"> <DeleteParameters> <asp:Parameter Name="Employee_Designation_ID" Type="Byte" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Employee_Designation_ID" Type="Byte" /> <asp:Parameter Name="Employee_Designation_Name" Type="String" /> <asp:Parameter Name="Per_year_Leave" Type="Byte" /> <asp:Parameter Name="Charge_per_leave" Type="Int16" /> <asp:Parameter Name="Designation_Detail" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Employee_Designation_Name" Type="String" /> <asp:Parameter Name="Per_year_Leave" Type="Byte" /> <asp:Parameter Name="Charge_per_leave" Type="Int16" /> <asp:Parameter Name="Designation_Detail" Type="String" /> <asp:Parameter Name="Employee_Designation_ID" Type="Byte" /> </UpdateParameters> </asp:SqlDataSource>
And Here the Two Textbox
And Here the Two Textbox
<div class="col-lg-3">
<div class="input-group">
<asp:TextBox ID="Designation_Id_TextBox" runat="server" placeholder="Enter Designation Id" CssClass="form-control"></asp:TextBox>
</div>
<!-- /input-group -->
</div>
<div class="col-lg-3">
<div class="input-group">
<asp:TextBox ID="Designation_Name_TextBox" runat="server" placeholder="Enter Designation Name" CssClass="form-control"></asp:TextBox>
</div>
<!-- /input-group -->
</div>
<div class="col-lg-2">
<asp:Button ID="Search_Button" CssClass="btn btn-default" runat="server" Text="Search" OnClick="Search_Button_Click" />
</div>
I want When i enter Id it show only data of that Id
I want When i enter Id it show only data of that Id
Check this out: ASP.NET GridView with search option (SearchableGridView)[^]
Check this out: ASP.NET GridView with search option (SearchableGridView)[^]
这篇关于我想在gridview中使用TextBox搜索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
