VISUAL BASIC

18.5 (Baseball Database Application) Build an application that executes a query against the Players table of the Baseball database included in the Databases folder with this chapters examples. Display the table in a DataGridView, and add a TextBox and Button to allow the user to search for a specific player by last name. Use a Label to identify the TextBox. Clicking the Button should execute the appropriate query.

Modify Exercise 18.5 to allow the user to locate players with batting averages in a specific range. Add a minimumTextBox for the minimum batting average (0.000 by default) and a maximumTextBox for the maximum batting average (1.000 by default). Use a Label to identify each TextBox. Add a Button for executing a query that selects rows from the Players table in which the BattingAverage column is greater than or equal to the specified minimum value and less than or equal to the specified maximum value.