如何在文本框选择中搜索gridview [英] how to search gridview on textbox selection

问题描述

我想在gridview中搜索字符串（下拉列表选择）并选择搜索行。



下拉列表..

I want to search string(dropdownlist selection) in gridview and search row should be selected.

dropdownlist..

<asp:TextBox ID="SearchTextBox" runat="server"
                          ></asp:TextBox>

gridview ..

gridview..

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                  onrowdatabound="GridView1_RowDataBound"
                 onselectedindexchanged="GridView1_SelectedIndexChanged1" CellPadding="4"
                 ForeColor="#333333" GridLines="None" AllowPaging="True"
                         onpageindexchanging="GridView1_PageIndexChanging" PageSize="2"
                  >
                  <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                  <Columns>

                  <asp:BoundField DataField="DesigID" HeaderText="Designation ID">
                          <ItemStyle HorizontalAlign="Center" />

                      </asp:BoundField>
                      <asp:BoundField DataField="DesigName" HeaderText="Designation Name">
                          <ItemStyle HorizontalAlign="Left" />
                      </asp:BoundField>

                  </Columns>
                  <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                  <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
           <selectedrowstyle backcolor="LightCyan" forecolor="DarkBlue" font-bold="true"/>
                  <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                  <AlternatingRowStyle BackColor="White" />
              </asp:GridView>

搜索按钮。

search button.

<asp:Button ID="SearchButton" runat="server" Text="Search"
                               onclick="SearchButton_Click" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

当我点击按钮时，DesigName应根据searchtextbox中的desigID显示在文本框中。

When I click the button, DesigName should be display on textbox according to desigID in searchtextbox.

推荐答案

HI ..



请尝试这样。

HI ..

Please try like this.

public void bindempage()


    {

        SqlConnection con = new SqlConnection(cons);

        string query = "select age from emp order by age";

        con.Open();
        SqlCommand cmd = new SqlCommand(query, con);

        SqlDataReader dr;
        dr = cmd.ExecuteReader();

        dropdown.DataSource = dr;
        dropdown.DataValueField = "age";
        dropdown.DataBind();
        if (!dropdown.Items[0].Equals("Select Id"))
            dropdown.Items.Insert(0, "Select Id");
 
    
    }

它可能对你有帮助。 。

It may be help you..

protected void SearchButton_Click(object sender, EventArgs e)
       {
           string strText = SearchTextBox.Text.Trim();
           if (strText == "")
           {
               flag = false;
               GridView1.PageIndex = 0;
               ViewButton_Click(sender, e);


           }
           else
           {
               GridViewRow row;

               //for (int i = 0; i < GridView1.Rows.Count; i++)
               for (int j = 0; j < GridView1.PageCount; j++)
               {

                   GridView1.PageIndex = j;
                   ViewButton_Click(sender, e);
                   for (int i = 0; i < GridView1.Rows.Count; i++)
                   {
                       row = GridView1.Rows[i];
                       string fl = ((row.Cells[1]).Text);
                       if (strText == ((row.Cells[1]).Text))
                       {
                           flag = false;
                           row.ForeColor = ColorTranslator.FromHtml("red");
                           break;

                       }
                   }
                   if (flag == false)
                   {
                       break;
                   }
               }
               if(flag==true)
                   {
                       GridView1.PageIndex = 0;
                       ViewButton_Click(sender, e);
                   }


           }

       }

protected void SearchButton_Click(object sender, EventArgs e)
      {
          GridViewRow row;
          string _strText = SearchTextBox.Text.Trim();
          for (int i = 0; i < GridView1.Rows.Count; i++)
          {
              row = GridView1.Rows[i];
              string fl = ((row.Cells[1]).Text);
              if (_strText == ((row.Cells[1]).Text))
              {
                row.ForeColor=ColorTranslator.FromHtml("red");


              }
          }
      }

但它不是搜索所有页面。只搜索首页，我希望所有页面都应该搜索。

But it is not searching all pages.Only front page is searched,I want all pages should be search.

这篇关于如何在文本框选择中搜索gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！