Update Record Code: Dim line, data(1) As String Dim updateJag As String = txtJagNumber. Text Dim jagNumber As String Dim average As Decimal GetInput(jagNumber, average) Dim record As String NewCSV(jagNumber, average) Dim sr As IO.StreamReader = I0.File.0penText("Average.txt") Dim sw As IO.StreamWriter = 10.File.CreateText("Temp.txt") Do Until sr.EndofStream line = sr.ReadLine data = line.Split(","c) If data(0) = updateJag Then sw.WriteLine(record) Else sw.Writeline(line) End If Loop sr.Close() sw.Close() File. Delete("Average.txt") File.Move("Temp.txt", "Average.txt") Sub GetInput reads values in from textboxes into variables. The inputted value for jagNumber is J00123565. The inputted value for average is 90.20. Function NewCSV created a comma separated value record using the two inputted fields. Walk through the code and show the values for the variables and location pointer as the code is executed. Average.txt Temp.txt J00768567,98.54 J00546344,72.35 J00123565,89.20 J00998877,92.50 updateJag average record line data

Update Record Code: Dim line, data(1) As String Dim updateJag As String = txtJagNumber. Text Dim jagNumber As String Dim average As Decimal GetInput(jagNumber, average) Dim record As String NewCSV(jagNumber, average) Dim sr As IO.StreamReader = I0.File.0penText("Average.txt") Dim sw As IO.StreamWriter = 10.File.CreateText("Temp.txt") Do Until sr.EndofStream line = sr.ReadLine data = line.Split(","c) If data(0) = updateJag Then sw.WriteLine(record) Else sw.Writeline(line) End If Loop sr.Close() sw.Close() File. Delete("Average.txt") File.Move("Temp.txt", "Average.txt") Sub GetInput reads values in from textboxes into variables. The inputted value for jagNumber is J00123565. The inputted value for average is 90.20. Function NewCSV created a comma separated value record using the two inputted fields. Walk through the code and show the values for the variables and location pointer as the code is executed. Average.txt Temp.txt J00768567,98.54 J00546344,72.35 J00123565,89.20 J00998877,92.50 updateJag average record line data

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Disciple-the uniform application of rightful behavior Explanation; Ex;
Software Engernning Question: (JUST NEED DIAGRAMS) Consider a Vehicle Maintenance System where a customer can come for inspecting his/her vehicle. The mechanic will inspect the vehicle and be paid for it. They will store the inspection result in the inspection record. Based on the record, the mechanics can repair the vehicle too if the customer wants and be paid for it. The owner can order parts to the vendor if there is any shortage in the inventory. The customer will pay bill for inspection and repair. Draw a Data Flow Diagram (Level 0 and 1) for the system. Then for any one of the process, show the level 2 data flow diagram.
Explain the importance of virtual methods for object closures.
Explain CASE tools and the concept of a CASE environment
44. What does a use case diagram do? A.Connects several use cases to class diagrams B.Lists use case goals C.Diagrams a single use case D.Provides an overview of several use cases
In the process of developing software, a number of different models are used, and the usefulness of each model varies depending on the application. Check to see that the automobiles are parked in the appropriate spots.
Explain what "high cohesion" means.
Class and object adapters provide different functions. These concepts are also significant for what they signify to you.
Explain or describe where issues can arise if a student doesn’t pre-plan when asked to simplify an expression using the order of operations. Create a problem in which pre-planning would be useful, then show how it might be done incorrectly due to lack of pre-planning.
There are three methods for doing user testing.
Explain the concept of method overriding in object-oriented programming. Provide an example of a base class and a derived class where method overriding is used.