Visual Basic® .NET Database Programming

Programming the RecordList Form

The frmRecordList form implements the query-by-example tool. This section explains how a program can use this form to allow the user to select records. Most of the work is done in initializing the form. After it is initialized, the form does most of its work automatically.

Example program CustomerGrid creates the form when you select the Windows menu’s Customer List command. When you invoke this command, the program executes the mnuWinCustomerList_Click event handler shown in Listing 12.1.

The first thing the event handler does is create a new instance of the frmRecordList form. It defines a database connect string and changes its cursor to the hourglass cursor. It sets the new form’s MdiParent property to the ...