CSC 430 - Lab 5 - Database Project

Build a small database for simple maintenance of a phone book:

Assume you download the phone directory database first ; it contains only 2 columns in 1 table called Phone and Name respectively.

What functions you need to design & build:

• Search by Name

• Search by Phone #

• Adding a new person & phone #

• Deleting the current name/phone record displayed

• Updating either the name or phone # displayed for the record displayed

• A simple menu-ing system that provides these functions without having to use a mouse

• Ending the program (quit)

• An about box to give you credit for writing it.

What you likely need to understand:

• ADO data control (ActiveX Data Control)

  • Connection String

  • RecordSource

• Binding Textboxes to the Data Control

  • DataSource

  • DataField

• Hierarchical FlexGrid Control

  • flexResizeColumns

  • DataSource

• Simple SQL for Select

• Recordset Methods

  • .MoveFirst

  • .MoveLast

  • .MoveNext

  • .Update

  • .AddNew

  • .Delete

Extra Credit: If you can get the textbox for the phone number to be formatted for  display purposes and still be used to input a phone number without the formatting characters.

Due: the last day of classes BEFORE the final exam!!

Created and maintained by DrB
Last Updated on Wednesday, February 18, 2009