Microsoft Visual C++ .NET Professional Projects - Premier Press
.pdf190 Project 1 DATABASE PROGRAMMING USING VC++.NET
|
|
Y |
|
L |
|
|
F |
|
FIGURE 8-15 The Create New Data Source to SQL Server dialog box |
||
|
M |
|
A |
|
|
8. Click on the Next button. On the next screen, select the type of authen- |
||
tication that youEwant the SQL server to perform. (I have used NT |
||
authentication.) |
|
|
T |
|
|
9. Click on the Next button. On the next screen, change the default database from master to Banking, as shown in Figure 8-16.
FIGURE 8-16 The default database
Team-Fly®
IMPLEMENTING DATA ACCESS TECHNOLOGIES |
Chapter 8 |
191 |
|
|
|
10.Click on the Next button and then the Finish button. The ODBC Microsoft SQL Server Setup dialog box appears with the settings specified by you. Figure 8-17 displays this dialog box.
FIGURE 8-17 The ODBC Microsoft SQL Server Setup dialog box
11.Click on the Test Data Source button to check the validity of the connection settings. The SQL Server ODBC Data Source Test dialog box appears, shown in Figure 8-18, indicating the success or failure status of the connection.
12.Click on the OK button three times to close all open dialog boxes and complete the ODBC setup. Close the Control Panel.
Next, you will have to create the front-end MFC-based application in Visual C++.NET.
Creating the SaveMyMoney Application
As listed earlier, you have to create an MFC-based application with ODBC support, and then design the various screens and classes required for providing the required functionality. Here’s what you will do:
1. Create an MFC-based application using the MFC Application template.
192 Project 1 DATABASE PROGRAMMING USING VC++.NET
FIGURE 8-18 The SQL Server ODBC Data Source Test dialog box
2.Design the application’s main form and edit the menu.
3.Add classes to handle the login, deposit/withdrawal, and transfer operations, and design the appropriate forms.
4.Add the appropriate code required to integrate all classes and to implement the required functionality.
5.Build and execute the project.
I will guide you through these steps in the subsequent sections.
Creating an MFC-based Application
As per the design specifications, you need to create an MFC-based SDI application. Additionally, you need to avail back-end support through the ODBC data source that you configured earlier. You can achieve all of this by using the MFC Application template. The steps to perform are as follows:
1.In the Microsoft Development Environment [design] window, choose File, New Project. (Alternatively, if the Start page is active, you can click on the New Project button.)
2.In the New Project dialog box, choose Visual C++ Project as the project type, choose MFC Application as the template, and then, in the Name
IMPLEMENTING DATA ACCESS TECHNOLOGIES |
Chapter 8 |
193 |
|
|
|
text box, type BankOperation as the name of your project. Figure 8-19 depicts these settings.
FIGURE 8-19 The New Project dialog box
3.Click on the OK button to invoke the MFC Application Wizard.
4.Click on Application Type to view the settings specifying your application type.
5.Under Application Type, select Single document to create an SDI application. Accept all other default values on this page.
6.Click on Database Support to view the options for setting the database connectivity for your application.
7.Under Database Support, select Database view without file support, and under Client type, select ODBC. Figure 8-20 illustrates the specified settings.
NOTE
Remember that the Database view with file support option is available only for an MDI application.
194 Project 1 DATABASE PROGRAMMING USING VC++.NET
FIGURE 8-20 The Database Support page
8.On the Database Support page, under Data source, click on the Data Source button. The Select Data Source dialog box appears. Click the Machine Data Source tab, and from the list of data sources, select Bank, as shown in Figure 8-21.
FIGURE 8-21 The Machine Data Source tab of the Select Data Source dialog box
IMPLEMENTING DATA ACCESS TECHNOLOGIES |
Chapter 8 |
195 |
|
|
|
9.Click on OK. If a SQL Server login box appears, log in using the appropriate login ID and password.
10.Click on OK. The Select Database Object dialog box appears, shown in Figure 8-22.
FIGURE 8-22 The Select Database Object dialog box
11.Expand Tables, as shown in Figure 8-23. The four tables in the Banking database appear.
12.Select the table Account_Detail. You will be creating the main application based on the Account_Detail table. Later, you can add the required classes to handle the other three tables.
13.Click on Finish to create the project named BankingOperation. By default, a solution by the same name is created and this project is added to the solution. The Solution Explorer, shown in Figure 8-24, displays all files created by the wizard in this project.
NOTE
Notice that when you select Database Support, the wizard automatically adds classes based on the CRecordSet and CRecordView classes. Recall that these are the MFC ODBC classes that provide the database connectivity.
196 Project 1 DATABASE PROGRAMMING USING VC++.NET
FIGURE 8-23 The tables in the Banking database
FIGURE 8-24 The Solution Explorer displaying the BankingOperation project
Designing the Main Form
When the user executes the application, the very first screen that appears is the Login screen. (You’ll design the Login screen next.) Once the user enters his or her username and password and clicks on Submit, the main form is displayed (if
IMPLEMENTING DATA ACCESS TECHNOLOGIES |
Chapter 8 |
197 |
|
|
|
the provided logon details are valid). This form, as shown in Figure 8-25, is based on the Account_Detail table. You’ll now design this form.
FIGURE 8-25 The design of the application’s main form
To design the form, switch to the Resource View. From the Dialog resources, select IDD_BANKOPERATION_FORM. This is the default form provided by the wizard for designing the main view of your application. Refer to Figure 8-25 and design the main form.
When you design the form, you need to set the various properties for the controls so that you create a replica of the form shown in Figure 8-25.
Table 8-1 lists the properties to be set for the main form, IDD_BANKOPERATION_FORM:
Table 8-1 Properties to be Set for the Main Form
Property |
Category |
Value |
Caption |
Appearance |
Banking |
Font(Size) |
Font |
MS Sans Serif(10) |
Use System Font |
Font |
False |
|
|
|
This will set the font size of the controls on the form to MS Sans Serif(10).
198 Project 1 DATABASE PROGRAMMING USING VC++.NET
For all Static Text controls (labels), place them and type the name given in Figure 8-26. The value that you type here is assigned to the Caption property of the respective control. The IDs for these labels are the default IDs, and therefore you need not edit them.
Besides editing some of the controls, you need to edit the default ID assigned to the controls. Table 8-2 lists the controls for which you need to edit the default ID. The controls that are not listed in this table will have the default ID.
Table 8-2 IDs of Controls of the Main Form
Control |
Type |
ID Property Value |
Control next to the control |
Edit Box |
IDC_CURRDT |
displaying the form’s caption |
|
|
Account Number |
Combo Box |
IDC_ACCNO |
First Name |
Edit Box |
IDC_FNAME |
Last Name |
Edit Box |
IDC_LNAME |
Date of Birth |
Edit Box |
IDC_DOB |
Permanent Address |
Edit Box |
IDC_PADD |
Mailing Address |
Edit Box |
IDC_MADD |
Phone Number |
Edit Box |
IDC_PHONE |
Email ID |
Edit Box |
IDC_EMAIL |
Referral Account No |
Edit Box |
IDC_REFACCNO |
Amount |
Edit Box |
IDC_AMOUNT |
Control below the check box |
Edit Box |
IDC_VALID |
Add |
Command Button |
IDC_ADD |
Modify |
Command Button |
IDC_MOD |
Update |
Command Button |
IDC_UPD |
Cancel |
Command Button |
IDC_CANCEL1 |
DeActivate |
Command Button |
IDC_DELETE |
ReActivate |
Command Button |
IDC_REACTIVATE |
Dep/Wdrl |
Command Button |
IDC_DEPOSIT |
IMPLEMENTING DATA ACCESS TECHNOLOGIES |
Chapter 8 |
199 |
|||
|
|
|
|
|
|
|
|
|
|
|
|
Control |
Type |
ID Property Value |
|||
|
|
|
|
|
|
Transfer |
Command Button |
IDC_TRANSFER |
|
|
|
Commit |
Command Button |
IDC_COMMIT |
|
|
|
|
|
|
|
|
|
You will next design the Login form.
Designing the Login Form
Recall that when you created the application, you selected the Account_Detail table as the base. As a result, the wizard created a CRecordView-based class and provided a dialog resource. Now, to add the functionality for logging on, you need to add another class. Following are the steps that you need to perform to create a class:
1.Choose Project, Add Class to open the Add Class dialog box. (Alternatively, you can right-click the project in the Solution Explorer and choose Add Class.)
2.From the Templates list, select MFC Class.
3.Click on Open to invoke the MFC Class Wizard.
4.In the Class name box, enter LoginDlg and choose CDialog as the base class, as shown in Figure 8-26.
FIGURE 8-26 The MFC Class Wizard