I have two homework questions in Visual Basic 2017 that I need help with- we are studying ADO.NET with VB and I am stuck. The first question if based off of a database created in Access. The database table is named SouthernStates. It has a total of 11 records. Each row (record) has the State Name, the State Capital, and the Population (in that order). Record/Row 6 is the state of Alabama, in which the capital is Montgomery. The homework question is write a statement that references the capital of Alabama and assign the value to the strCapital variable.
The second question is not related to the database; it's write a line of code to initialize a String variable named strCafe to a Select SQL statement that would select all the fields from a table named Java.