Using entered data as criteria to limit results returned

Using entered data as criteria to limit results returned

I have created a data grid that is returning the complete table. Now I'm looking for an example of how I could use the data a user would type in a Web form field as the criteria to limit what is returned. I'm not using a dataset. Thanks in advance for your help.

    Requires Free Membership to View

    Login

    When you register, you'll begin receiving targeted emails from my team of award-winning writers. Our goal is to provide a unique online resource for developers, architects and development managers tasked with building and maintaining enterprise applications using Visual Basic, C# and the Microsoft .NET platform.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchWinDevelopment.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchWinDevelopment.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

I would transform the data from the grid into a memory resident DataTable. Then I would filter the data with the value from the form field by setting the RowFilter property of the DefaultView object of the DataTable and repopulate the grid with the results.

Another approach would be to iterate the rows of the grid and based on the form field value hide those rows that do not meet the filter criteria.

This was first published in October 2004

Back to top