UNIVERSITY EXAMINATIONS: 2010/2011
THIRD YEAR STAGE EXAMINATION FOR THE DEGREE OF BACHELOR
OF SCIENCE IN INFORMATION TECHNOLOGY
BIT 4202: ADVANCED APPLICATION PROGRAMMING
DATE: JUNE 2011 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
Question One
a) Differentiate the following terms as used in VB.Net
i. Textbox and masked textbox (2 Marks)
ii. Checkbox and Radiobutton (2 Marks)
iii. Intellisense and VB code window (2 Marks)
iv. A solution and a project (2 Marks)
b) Describe two mandatory Visual Studio Components (4 Marks)
c) Parameters can receive an argument value using either ByVal or ByRef explain using example
code to illustrate. (6 Marks)
d) Declare private string array with 6 elements numbered 0 through to 5 using VB.NET 5 marks
e) Define a Product structure that might be used to track products sold by retail stores.Each
product has a product identifier, product description, quantity on hand, and price. The
ProductIDString, DescriptionString, QuantityInteger, and PriceDecimal properties. (7 Marks)
Question Two
a) The following Visual BASIC code segment is incorrect identify and correct the mistake (4 Marks)
If HoursDecimal <= 40D Then
RegularPayCheckBox.Checked = True
Else RegularPayCheckBox.Checked = False
End If
b) Using an example explain the XOR logical operator as applied in Visual Basic (7 Marks)
c) i) Define the term binding as used in visual basic. (3 Marks)
ii) Explain the two types of binding in visual basic (6 Marks)
Question Three
The pseudo code shown below includes parsing TextBox values and computing gross pay:
‘Convert TextBox values for hours worked and pay rate to memory
‘If hours worked <= 40 Then
‘ pay only regular time
‘Else
‘ pay regular time + overtime
‘End If
This computation uses a standard block If statement with both True and False branches.
a) Draw a flowchart diagram for this logic. (6 Marks)
b) Write VB.net code to implement this logic (8 Marks)
c) Describe two advantages of producing an executable version of your project (6 Marks)
Question Four
a) Describe three roles played by ADO.NET in application development today. (6 Marks)
b) Describe four types of database connections availed to application developers by ADO.NET
(8 Marks)
c) Explain the use of the following inbuilt functions as used in visual basic
i) IsNumeric (3 Marks)
ii) isDate (3 Marks)
Question Five
a) i) Explain two differences between general procedure and functions in visual basic (4 Marks)
ii) The time required to call a procedure depends on two factors. Explain. (4 Marks)
b) Based on variable scope, variables in visual basic can be grouped into three. Explain (6 Marks)
c) Explain the components of client server architecture. (6 Marks)
