Visual Basic and ADO Database Assignment
You can create your own database or use one of mine - there are a variety of databases available at this site and at the CIS61 site. However, your projects have to use different tables and different displays then the examples I went over in class or have on the Web. The problems can be done on separate forms in one project or separate projects - your choice.
- Connect to a table on a database and display information in text boxes on the form. The connection code should be done with code in your program.
- Use custom (remember I should be able to run from the root of the A drive) and use SQL text to extract specific fields from a group of records that meet a specific criteria. The data should be displayed in text boxes on the form.
- Take in a field and use it in someway to retrieve one or more records based on SQL selection coded in your program.
- Set up two ADOs with the information from two different tables in the database on the same form. Set up two grids and relate the information in some way.