Click here to Skip to main content
15,878,970 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hy
I want to Search data in gridview using textbox, I retrieve data in gridview like this

Here the Code
XML
<asp:HiddenField ID="Employee_Id_Hidden_Field" runat="server" />

   <div class="row">

      <div class="col-lg-12">

          <div class="panel panel-default">

              <div class="panel-heading">

                  <h4>
                      <span class="icon16 icomoon-icon-equalizer-2"></span>
                      <span>Search Employee</span>
                  </h4>
                  <a href="#" class="minimize">Minimize</a>
              </div>
              <div class="panel-body">



                  <div class="col-lg-3">
                      <div class="input-group">

                          <asp:TextBox ID="Employee_Id_TextBox" runat="server" placeholder="Enter Employee Id" CssClass="form-control"></asp:TextBox>
                      </div>
                      <!-- input-group -->
                  </div>


                  <div class="col-lg-3">
                      <div class="input-group">
                          <asp:TextBox ID="Employee_Name_TextBox" runat="server" placeholder="Enter Employee 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" />
                  </div>
              </div>

          </div>
          <!-- End .panel -->

      </div>
      <!-- End .col-lg-12 -->

  </div>

  <!-- End .row -->
  <div class="col-lg-12">
      <div class="panel panel-default">
          <div class="panel-heading">
              <h4>
                  <span class="icon16 icomoon-icon-equalizer-2"></span>
                  <span>List Of Employees </span>
              </h4>
              <a href="#" class="minimize">Minimize</a>
          </div>
          <div class="panel-body noPad">
              <asp:GridView ID="GridView1" Width="100%" PageSize="10" runat="server" AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Employee_Id" DataSourceID="List_Employee" ForeColor="#333333" GridLines="None">
                  <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                  <Columns>
                      <asp:BoundField DataField="Employee_Id" HeaderText="Id" ReadOnly="True" SortExpression="Employee_Id" />
                      <asp:BoundField DataField="Employee_Full_Name" HeaderText="Name" SortExpression="Employee_Full_Name" />
                      <asp:BoundField DataField="Employee_Fathers_Name" HeaderText="Fathers Name" SortExpression="Employee_Fathers_Name" />
                      <asp:BoundField DataField="Employee_Phone_Number" HeaderText="Phone Number" SortExpression="Employee_Phone_Number" />
                      <asp:BoundField DataField="Employee_Designation_ID" HeaderText="Designation ID" SortExpression="Employee_Designation_ID" />
                      <asp:BoundField DataField="Created_by_Employee_Id" HeaderText="Added By" SortExpression="Created_by_Employee_Id" />
                  <asp:TemplateField HeaderText="View">
                          <ItemTemplate>
                              <asp:LinkButton runat="server" ID="View_Detail" CommandArgument='<%#Eval("Employee_Id") %>' CommandName="View" OnClick="View_Detail_Click">View Detail</asp:LinkButton>
                          </ItemTemplate>
                      </asp:TemplateField>
                        </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="List_Employee" runat="server" ConnectionString="<%$ ConnectionStrings:CMMS_Standard %>" ProviderName="<%$ ConnectionStrings:CMMS_Standard.ProviderName %>" SelectCommand="SELECT [Employee_Id], [Employee_Full_Name], [Employee_Fathers_Name], [Employee_Phone_Number], [Employee_Designation_ID], [Created_by_Employee_Id] FROM [Employee_Details]"></asp:SqlDataSource>
               </div>
          <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
      </div>

  </div>



now How i code to search data in gridview .
Posted
Updated 10-Apr-15 19:53pm
v3

1 solution

 
Share this answer
 
Comments
Gurpreet Arora Malhotra 11-Apr-15 4:08am    
Not working
King Fisher 11-Apr-15 5:03am    
What do you mean not working ?
Gurpreet Arora Malhotra 11-Apr-15 6:18am    
Hi
I try http://www.c-sharpcorner.com/UploadFile/47548d/filter-gridview-with-textbox-using-control-parameter-in-asp/[^] it doesnot show any data in gridview
Gurpreet Arora Malhotra 13-Apr-15 14:39pm    
Hi I try this When i use control parameter it shows data when i search , it doesnot show any data when textbox is blank , I want to show all data in gridview , but when i enter value in textbox it shows textbox data when textbox is blank gridview have to show all data

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900