This gives you a Query Builder dialog where you can change the Select statement.

Or, another way is to change the DataAdapter by executing the wizard again by clicking Configure DataAdapter on the context menu (right-click OleDbDataAdapter1 to display the context menu) and enter a new SQL statement at the appropriate place in the wizard. (See Part 3 for more detailed instructions on this wizard.) We're going to do it this way because we also want to add change instructions using the wizard.

When you reach the Generate the SQL Instructions panel in the wizard, add this text to the end: WHERE (artTitle LIKE ? + '%'). The entire SQL Statement should now read:

SELECT artDate, artDescription, artKey, artTitle, artURL, artVB6, artVBNET FROM Articles WHERE (artTitle LIKE ? + '%')

The "?" in the WHERE clause is a parameter that is replaced by an actual value when the SQL is executed. We'll do more with that in just a little while. Note that the way you code this in Access and SQL Server is quite different. With SQL Server, you would use something that looks like: @parTitle rather than a question mark.

When the wizard has completed, modify your program by adding this statement above statement that executes the Fill method for the DataAdapter:

Me.OleDbDataAdapter1.SelectCommand.Parameters(0).Value = "VBA"

Now run the program again. This time only the titles starting with VBA are selected. These are the About Visual Basic VBA Tutorial Series articles. Since finding the correct properties to change is the key to doing things right, notice that the names of properties in the program, such as SelectCommand above, are the same ones that you saw when you opened the properties window for the DataAdapter component. The zero index parameter is the one (actually, the only one in this simple example) referenced by the question mark in the SQL statement.

Next page > Binding and Changes > Page 1, 2, 3, 4