Searching Records from GRIDVIEW using TEXTBOX

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have Millions of Records in My GRIDVIEW.

I need to Search the Records using Textbox on key press (just like Google)

Please Please Please Can any one suggest me how to do this ?

Trying from almost 15 days but unable to comeup with this problem.

I need Exact Google Like SEARCH.( To search the Records from GRIDVIEW)

Thanks,

Posted 8-May-12 21:35pm

Ranjith Reddy CSE

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ganesan Senthilvel · Answer 1 · 2012-05-08T22:10:00

Solution 1

SQL Server 2008 has the technology support for 'Full Text search', which is similar to google like search for millions of records. You can find the step by step learning process at CodeProject SQL Full Text Search Programming[^]

Posted 8-May-12 22:10pm

Ganesan Senthilvel

Comments

Ranjith Reddy CSE 9-May-12 4:26am

ya, i understood this, BUT how can we search records from GRIDVIEW by using Textbox on key press.

Prasad_Kulkarni · Answer 2 · 2012-05-08T22:44:00

Please refer following threads:

This thread will show you how to search through all columns of ASP.NET GridView Data and show only those data which satisfies the search text: How to search through GridView records[^]

This example describes how to use GridView Filtering or Filter Gridview with DropDownList: GridView Filter Expression with DropDownList ASP.NET[^]

ASP.NET GridView Filtering[^]

[EDIT]
Also have a look on this CP Article, this will give you a Custom control derived from GridView, implements filtering, custom Top pager, and custom Bottom pager.
Custom GridView with Paging and Filtering[^]