Open the Windows Explorer and create a new folder such as Chapter 5, and then browse to our project SelectWizard Project, copy this project to our new folder Chapter 5. Change the name of the solution and the project from SelectWizard to SQLInsertWizard,

1
5.3.1 Modify the Existing Project to a New Data
Insertion project

• Open the Windows Explorer and create a new folder
  such as Chapter 5, and then browse to our project
  SelectWizard Project, copy this project to our
  new folder Chapter 5. Change the name of the
  solution and the project from SelectWizard to
  SQLInsertWizard, and then double click the
  SQLInsertWizard Project.vbproj to open this
  project.
• Perform the following modifications to get our
  desired project
• Go to ProjectSQLInsertWizard Project Properties
  menu item to open the projects property window.
  Change the Assembly name from SelectWizard
  Project to SQLInsertWizard Project and the Root
  namespace from SelectWizard_Project to
  SQLInsertWizard_Project, respectively.
• Click the Assembly Information button to open the
  Assembly Information dialog box, change the
  Title and the Product to SQLInsertWizard
  Project. Click OK to close this dialog box.
• Go to the FileSave All to save those
  modifications.

2
  5.3.2 Create a New Form Window to Insert Data
for the Course Form

• Recall that in the project SelectWizard, the
  Course form window contains a button named
  Insert. We want to use that button to insert a
  new course record into the Course table in the
  database.
• To do that, we need to create a new form window
  named InsertCourseForm that should be triggered
  by the clicking of the Insert button from the
  Course form as the project runs.
• When the user clicks the Insert button, the
  Insert Course form window will be shown up. This
  form allows users to use two different methods to
  insert data into the database.
• The form also allows users to enter all pieces of
  new course information into the appropriate
  textboxes for the selected faculty based on the
  faculty name.
• By clicking the Insert button, a new course
  record about a faculty is inserted into the
  database.
• The Select button is used to validate this data
  insertion by retrieving back the new inserted
  data.

3
5.3.2 Create a New Form Window to Insert Data
for the Course Form - 2

• Create a new Form and add the following items
  that are shown in Table 5-3 into this form.