Program 1:

AIM: Construction of an Arithmetic Calculator (Simple).

ALGORITHM:

Step 1: Start the Process.

Step 2: Design the forms using controls.

Step 3: Using control array design the forms using command button.

Step 4: Write the coding for Arithmetic Calculator .

Step 5: Run the project.

Step 6: Stop the process.

AIM: Writing simple programs using loops and decision-making statements.

a. Generate Fibonacci series.

b. Find the sum of N numbers.

ALGORITHM:

Step 1: Start the Process

Step 2: Design the forms using controls

Step 3: Declare variables for find the Fibonacci values

Step 4: Declare variables for sum of N numbers

Step 5: Change the property in property window

Step 6: Write the coding

Step 7: Run the project

Step 8: Stop the process

AIM: Write a program to create a menu and MDI Forms.

ALGORITHM:

Step 1: Start the Process

Step 2: Create menu in MDI form using menu editor

Step 3: Add the sub forms in the project

Step 4: change MDI child as true in property window

Step 5: Change project property as MDI form to run the project

Step 6: Write the coding for each menu

Step 7: Save the project

Step 8: Run the project

Step 9: Stop the process

AIM: Write a program to display files in a directory using Drive List Box, Dir List Box and File

List Box control and open, edit and save text file using Rich textbox control.

ALGORITHM:

Step 1:Start the Process.

Step 2: Design the form using Drive List Box, Dir List Box and File List Box control.

Step 3: Add Rich textbox control for open and save the files.

Step 4: Write the coding for each control.

Step 5: Save the project.

Step 6: Run the project.

Step 7: Stop the process.

AIM: Write a program to illustrate Common Dialog Control and to open, edit and save text file.

ALGORITHM:

Step 1: Start the Process.

Step 2: Design the form using common dialog control.

Step 3: Write the coding for common dialog control .

Step 5: Open an existing file using common dialog control.

Step 6: Save the new file using common dialog control.

Step 7: Run the project.

Step 8: Stop the Process.

AIM: Write a program to implement animation using timers.

ALGORITHM:

Step 1: Start the Process.

Step 2: Design the form using image control and timer control.

Step 3: Write the coding for animation program.

Step 5: Change the properties for timer control set the time 1000 nano seconds.

Step 6: write the coding and Save the project.

Step 7: Run the project.

Step 8: Stop the Process.

AIM : Write a simple VB program to accept a number as input and convert it into

a.Binary

b.Octal

c.Hexa-decimal

ALGORITHM:

Step 1: Start the Process.

Step 2: Design the form using text box, lable box and command buttons.

Step 3: Write the coding to find binary, octal and hexa decimal values.

Step 5: Write the coding and Save the project.

Step 6: Run the project .

Step 7: Stop the Process.

AIM : Create a table for Employee details with Employee Number as primary key and following

fields: Name, Designation, Gender, Age, Date of Joining and Salary. Insert at least ten rows and

perform various queries using any one Comparison, Logical, Set, Sorting and Grouping

operators.

ALGORITHM:

Step 1: Start the process.

Step 2: Open the Database.

Step 3: Create a table for Employee.

Step 4: Set Employee Number as primary key.

Step 5: Create table using these field names Name, Designation, Gender, Age, Date of Joining

and Salary.

Step 6: Insert values for ten rows.

Step 7: Using operators to select the values.

Step 8: Stop the process.

AIM : Write a PL/SQL to update the rate field by 20% more than the current rate in inventory

table which has the following fields: Prono, ProName and Rate. After updating the table anew

field (Alter) called for Number of item and place for values for the new field with out using

PL/SQL block.

ALGORITHM:

Step 1: Start the process

Step 2: Open the Database.

Step 3: Create the inventory table using Prono, ProName and Rate , set prono as primary key.

Step 4: Insert the values for inventory table.

Step 5: Add new column as price using alter command

Step 6: using update query update the values for new column

Step 7: Run the above queries

Step 8: Stop the Process.

AIM : Write a PL/SQL program to implement the concept of Triggers.

ALGORITHM

Step 1: Start the process.

Step 2: Create student table sid as primary key, sname ,and age .

Step 3: Create trigger for insert, update and delete new rows.

Step 4: Use dbms_output.put_line for print the result on screen.

Step 5: Stop the process.

AIM: Write a PL/SQL program to implement the concept “Procedures”.

ALGORITHM

Step 1: Start the process.

Step 2: Create a procedure for Sum of two nos.

Step 3: Declare the variables.

Step 4: Pass values through the function name as sum_no.

Step 5: Result is printed on the screen.

Step 6: Stop the process.

AIM: Write a VB program to manipulate the student mark list with oracle database connectivity program

ALGORITHM

Step 1: Start the process.

Step 2: Create student mark list table in SQL database.

Step 3: Design the student mark list form in visual basic.

Step 4: Using ODBC connectivity connect front end and back end.

Step 5: Update the record source, record field and data field in property window.

Step 6: Run the Project.

Step 7: Stop the process.