the story so far system split into layers – maintainability & re-use database – stored...

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