Update small VB Application

Develop a small window application in Visual Studio 2005 that connects to Oracle to read and display data into grid.

Objects should be created: => 2 Forms, 1 Drop Down List, 2 edit box, 2 buttons, 2 Data Grids, 3 Labels

Requirement for Form 1:

Name the form: frmValidateMissingURLs

Create Drop Down List that should have database connection strings (Studen1, Student2).

Name the Drop Down List: cmbDBConnection

Create a Text Box and give a name: txtUserId

Create a Text Box and give a name: txtPassword

Create a Button and give a name: btnValidate

Create a Button and give a name: Exit

Form should be displayed in the middle of the screen.

Default selection of Drop Down List should be blank.

Set focus should be on User Id text box.

When user clicks Validate button, check Value is selected in Drop Down List. Check user id and password are not empty.

When user clicks Exit button, Confirm message should be displayed. If User clicks OK then exit the application.

When user clicks Validate button and for some reason DB connection did not establish then display proper message.

When user clicks Validate button and ALL validations passed then connect to Oracle to fetch and display data into grid in Form 2.

For each DB Connection string in Drop Down List should have hardcoded data as shown below.

If user selects Student1 from a Drop Down List then check following data exist in the table by executing:

select URL_ID, URLS_String from orders where URL_ID=FromBelowList and URLS_String=FromBelowList;

URL_ID and URLS_String

1001, [url removed, login to view]

745, [url removed, login to view]

9, [url removed, login to view]

21, [url removed, login to view]

If user selects Student2 from a Drop Down List then check following data exist in the table by executing:

select URL_ID, URLS_String from orders where URL_ID=FromBelowList and URLS_String=FromBelowList;

URL_ID and URLS_String

65, [url removed, login to view]

32, [url removed, login to view]

701, [url removed, login to view]

891, [url removed, login to view]

1, [url removed, login to view]

23, [url removed, login to view]

90, [url removed, login to view]

Program should be flexible to add or Delete database connection strings.

Requirement for Form 2:

Name the form: frmDisplayURLs

Form should be displayed in the middle of the screen.

Database connection string should be displayed in the form.

Create two data grids.

First grid should display data that are found data in the database.

Second grid should display data that are not found data in the database.

Font size should be 13.

Need source codes.

The build executable (.exe) can be run from windows PC.

Additional Req: Create two dimensional array with URL_ID and URLS_String.

Visual Basic for Apps Windows Desktop

Project ID: #5876843

About the project