A while back, one of our readers posted a question about adding a search button to the project in chapter 1. I've gotten that question a few times, and while we don't cover it in the book, I thought it was worth coming up with an answer. And luckily, the instructions in that post still work for the second edition, even though we switched from SQL Server Express to SQL Server Compact Edition.
So here are step-by-step instructions for adding a button to your form to filter the results based on search criteria. It does this by setting the RowFilter for the dataset that holds the data retrieved from the database, and then updating the binding source's DataSource to tell it to reload the data from the dataset.
Note that this is a "quick and dirty" solution, but it should work just fine for a straightforward application.