![Page 1: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/1.jpg)
![Page 2: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/2.jpg)
The Story so farSystem split into layers – maintainability & re-useDatabase – stored procedures, tables, rows,
columns & parametersRange of objects allowing us to control different
parts of the computer using their methods & propertiesVariables – RAMControls – InterfaceDataConnection class – database
Introduced a lot of coding concepts, assignment, sequence, selection, validation, functions, parameters to name a few
![Page 3: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/3.jpg)
Overview of Driving Test 2
![Page 4: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/4.jpg)
How do we Manipulate a List of Data?
![Page 5: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/5.jpg)
Array Lists Our list of data…
Fred Wilma Barney Betty
The code…
![Page 6: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/6.jpg)
The Count Property
![Page 7: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/7.jpg)
Index NumbersRather like house numbersBUT ---- Zero bound
Value IndexFred 0Wilma 1Barney 2Betty 3
![Page 8: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/8.jpg)
RemoveAt MethodValue IndexFred 0Wilma 1Barney 2Betty 3
Which record will be removed?
![Page 9: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/9.jpg)
Changing a List EntryWhat will the following do?
![Page 10: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/10.jpg)
Data TablesWe said all of that to introduce this…
sproc_tblAddress_SelectAll
SELECT *FROM tblAddress
![Page 11: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/11.jpg)
Middle Layer Code
How do we get at the results of the query?
![Page 12: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/12.jpg)
Data Table Contents
![Page 13: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/13.jpg)
The Address Page ClassclsAddressPageAddressNoHouseNoTownStreetPostCodeCountyCodeDateAddedBoolean Active
![Page 14: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/14.jpg)
Copying Data From Data Table to Array
![Page 15: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/15.jpg)
Encapsulation and Data HidingWhy do we do this?
clsDataConnection
Count
AddParameterExecute
![Page 16: The Story so far System split into layers – maintainability & re-use Database – stored procedures, tables, rows, columns & parameters Range of objects](https://reader036.vdocuments.us/reader036/viewer/2022070605/5a4d1aef7f8b9ab05997d1eb/html5/thumbnails/16.jpg)
New to studying in a UK university week
Sign up at: www.library.dmu.ac.uk/Home/Calendar
Monday 11th November
Tuesday 12th
November
Wednesday 13th
November
Thursday 14th
NovemberFriday 15th November
New styles of Learning10-11am
How to get the most out of
your lectures and seminars
12-1pm
Avoiding Plagiarism workshop 110-12noon
An introduction to resources to help you with your use of
English Language
12-2pm
Avoiding Plagiarism workshop 2
12-2pm
How to cite and reference using
Harvard12-1pm
Taking a critical
approach to your work
1-2pm
Polishing your assignment
5:30-6:30pm
New styles of assessment
1-2pm