[AndrewStellman]

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.

http://forums.oreill..._6685#entry6685

[digitalfriction]

AndrewStellman, on 03 September 2010 - 11:41 AM, said:

<a href="http://forums.oreilly.com/content/Head-First-C-/2267/Chapter-1-Project-Question/" target="_blank">http://forums.oreilly.com/content/Head-Fir...oject-Question/</a>

Having only started the book, this topic is relevant to me, but the link is dead?

Anyone have a copy of the instructions?

[AndrewStellman]

It looks like the link changed when the forum software was upgraded. I updated the post with the correct link.

[ranand12]

AndrewStellman, on 02 April 2011 - 07:46 AM, said:

It looks like the link changed when the forum software was upgraded. I updated the post with the correct link.

Is there a way to use the search text box with an autocomplete functionality (querying from the Name's table)?

[MSP005]

AndrewStellman, on 03 September 2010 - 11:41 AM, said:

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.

http://forums.oreill..._6685#entry6685

Attached File(s)

•  headfirst doubt.txt (483bytes)
  Number of downloads: 171