Book Finder Using Quick Search in Visual Basic.Net

This tutorial is a continuation of “Book Finder Using Visual Basic.Net and MS Access 2007”. At this time, we’re going to learn how to put a Quick search. By using a quick search, we can save more time by specifying the title of a specific book, author, Dewey number and subject. To start with this tutorial, add a new textbox and name it as “txtquick” and a label, and change the text property to “Quick Search”. Then add two buttons and the first one name it as “btnquick” and change the text property into “Use Quick Search” and the second one name it as “btntxtbox”, and change the text property to “Use Text Box Filter”. And the user interface after designing will look like as shown below. This time, we are now going to add functionality to our program. To do this double click the main form. And the following code below our “con.ConnectionString”. This code will only disable the “Use Quick Search” button and hide the “txtquick” textbox. Then double click the “btnquick” button and add the following code: The purpose of this code it will on show the “txtquick” and disable other textbox and change the back color into aqua color. And it looks like as shown below. Then to do the opposite, double click the “Use Text box Filter”, and add the following code: And it looks like as shown below: And finally double click the “txtquick” textbox and add the following code: When the text is changed, it will automatically populate the datagridview and the user can view a result easily. You can now press “F5” to test your program.