Screen Development -- 2

Develop a screen at a time for a program that connects to an SQL Server database. 1 screen = 1 project The Screen Layout is already designed. We need this layout to be used for all screens that we ask for (See the Screen Design pictures). The Database Structure that each screen connects to is already designed. We need the screen actions to be successful on the screen and interacting with the database whenever necessary (See the Database Design pictures). The code should be done in Visual Basic .NET 2005 only and the database should be in SQL Server 2000, 2005 or 2008 only. Get the screen to perform the following actions: 1. Screen loads as blank (No retrieval of data from the database as it loads) 2. Refresh retrieves the data from the view and displays it in the grid 3. New prepares the controls in the Form Tab for data capture by clearing them or putting in default values 4. Search involved selection of a search criteria, typing out a search value and clicking the Search button. This should select an existing record from the table and display the results of the search on the grid 5. User can select any record from the Grid by double clicking the entry on the grid. This should display the selected record's details on the controls in the Form Tab 6. User can edit the details of the selected record and Save the changes 7. Confirm that the changes made on the record have been saved successfully by displaying the saved record on the Grid 8. User can delete the selected record by clicking Delete and choosing Yes in the confirmation message that comes up 9. Confirm the deletion of the selected record by automatically searching for it and displaying the results on the Grid