Exforsys.com
 
Home Tutorials ASP.NET 2.0
 

ASP.NET 2.0 Tutorials : GridView Filtering

 

ASP.NET 2.0 Tutorials : GridView Filtering - Page 2

Page 2 of 2


.


.




14. The WHERE clause that was created is displayed in a box at the bottom of the page.


15. Click OK to close the Add WHERE Clause page.


16. The Configure Data Source < Datasourcename > wizard again appears.


17. Click Next.


18. On the Test Query page, click Test Query.


19. The wizard displays the Parameter Values Editor page, which prompts for a value to use in the WHERE clause.



20. In the Value box, type Higgins, James and then click OK.


21. The record for Higgins, James is displayed.




22. Click Finish to close the wizard.


23. The filtering can now be tested.


To test filtering

1. Press CTRL+F5 to run the page.


2. In the text box, type Marple, Jane and then click Button.


3. The record for Marple, Jane is displayed in the GridView control.





First Page: ASP.NET 2.0 Tutorials : GridView Filtering


Read Next: ASP.NET 2.0 : Adding Sorting and Paging in GridView



 

 

Comments


Abbad said:

  Thanks for this article. Helped :)
August 4, 2006, 3:52 am

JUSTIN said:

  You Rule
November 11, 2006, 8:28 pm

DYim said:

  Very nice tutorial! =) Thanks!
May 16, 2007, 9:13 am

sadjoker said:

  hi. good working but something is missing. If we want to show all data when the page is load, what can we do? this is the one of I am searching..!!!
June 26, 2007, 9:42 am

Chamindra said:

  Thank you so much for this tutorial !
I learned a lot :)


November 22, 2007, 2:21 am

Red said:

  outstanding!!!
January 13, 2008, 10:45 am

Thia said:

  Hi :) Very useful tuto! But I have a little request... How can I filter my gridview by the column I select in a dropDownList?
February 7, 2008, 9:42 am

Shela said:

  That was nice , Thanks.
Is there is a way that the search could be on text change not after submitting button, also one that can be done using javascript to avoid the post back that will cause performance problems in the application.

Please advice .
Thanks in advance.
August 26, 2008, 11:59 am

dhiraj said:

  nice tutorial dear.It helps me a lot.
January 9, 2009, 5:19 am

Lipi said:

  hi ,
thanks for this tutorial.....
But I am unable to show this GridView Filtered data in the Model popup extender(AJAX Toolkit).
I could not understand the problem.... Please give any suggestion for this.
June 11, 2009, 3:05 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape