how to search from gridview

shashi reddy

hi... to all

i have created a webform in that form one gridview and above that one textbox is there.
i have connected to my database programatically..
now my question is when i type a text in the textbox and press enter button,
it should search in gridview only.. and again the data which searched had to display in sme gridview

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
If the query got resolved, then mark the post that helped you as Answer.
0
Amit Choudhary15y ago
Here is the Example of searching the datasource with Linq:
Write this code in the searchbutton click event.

            IEnumerable result = from e in dt.AsEnumerable()
                     where e["Description"].ToString().Contains(srchTxt.Text)
                     select e;
            lblMessage.Text = "Search result found: " + result.Count();
            DataTable dtSearched = dt.Clone();
            foreach(DataRow drow in result)
            {
                dtSearched.ImportRow(drow);
            }

    Bind the Grid to dtSerached datatable to show the results.

Thanks.
0
Amit Choudhary15y ago
hi friend,
I found the easiest way of doing this:

      for (int j = 0; j < GridView1.Rows.Count; j++)

      {

        for (int i = 0; i < GridView1.Columns.Count; i++)

        {



          if ( GridView1.Rows[j].Cells[i].Text.Contains("search criteria"))

          {

           GridView1.Rows[j].Cells[i].Visible = true;

            break;

          }

          else

          {

            GridView1.Rows[j].Cells[i].Visible = false;

          }

        }
      }
This will search the Grid in very efficient way..

I'll post another solution that i have mentioned to you soon..
0
shashi reddy15y ago
hai amit

give me .any example plz
0
Amit Choudhary15y ago
This quite simple.. just on pressing the search button you can search the DataSource of the filter the data using the LINQ query using Contains() function. pass the search text in it.. and then bind the results with the same grid.

Hope you got my point.
0