the story so far system split into layers – maintainability & re-use database – stored...
DESCRIPTION
Overview of Driving Test 2TRANSCRIPT
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
Overview of Driving Test 2
How do we Manipulate a List of Data?
Array Lists Our list of data…
Fred Wilma Barney Betty
The code…
The Count Property
Index NumbersRather like house numbersBUT ---- Zero bound
Value IndexFred 0Wilma 1Barney 2Betty 3
RemoveAt MethodValue IndexFred 0Wilma 1Barney 2Betty 3
Which record will be removed?
Changing a List EntryWhat will the following do?
Data TablesWe said all of that to introduce this…
sproc_tblAddress_SelectAll
SELECT *FROM tblAddress
Middle Layer Code
How do we get at the results of the query?
Data Table Contents
The Address Page ClassclsAddressPageAddressNoHouseNoTownStreetPostCodeCountyCodeDateAddedBoolean Active
Copying Data From Data Table to Array
Encapsulation and Data HidingWhy do we do this?
clsDataConnection
Count
AddParameterExecute
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