[Year 12 SofDev] How did u go Mr Jolly?

Tue Aug 4 14:32:33 EST 2009

Hi guys,

Agree that database code from first principles is scary (even for me - who
deals with database connections a lot).  Anyway, I thought I would give you
a quick explanation of data sets, table adapters and binding sources.

When you create a connection to a database, VB.Net creates a table adapter.
A table adapter is an object that is used to connect to the database.  Any
time that you want to perform a query on the database - whether this be
extracting or saving data - you must use the table adapter to do this.  The
table adapter knows what type of database you are using and translates
between the database and VB.Net

When you command the table adapter to retrieve data from the database, it
places that data into a dataset.  A dataset is a soft copy of the database
(or part of it).  It resides only in memory and any operations that you
perform on the 'database' are in fact happening only to the dataset.  That
is, you only physically access the database each time you call the table
adapter command to resample (and create another dataset) or save the data.
The good part of this is that it makes the program quite fast - and it
protects the database in the event of a program crash.  The down side is
that if you do not call the table adapter command to save the dataset back
to the database before the program ends, you will not save your data.

There is also another object called a binding source which is a pointer into
the dataset and can be used to move backwards, forwards, etc.

Hope this makes sense -- if not let me know and I can elaborate some more!

Cheers,
Adrian

-----Original Message-----
From: sofdev-bounces at edulists.com.au [mailto:sofdev-bounces at edulists.com.au]
On Behalf Of Jolly, Michael D
Sent: Tuesday, 4 August 2009 1:43 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] How did u go Mr Jolly?

Still trying to get it to work, Brett.
I went down the Janson route by using the adapter wizard thingy in VB
.NET, cos I thought the UK web advice you showed me was good but was
very much from first principles and looked a bit scary! Anyway I almost
have it working except my understanding is low and I am still sorting
out adapters from connectors and correct names to use, I keep getting
various errors - I am trying to get Adrian J's Movies exercise working.
I plan to attack it again tonite, maybe I will finally crack it!? Thanx
4 asking.

-----Original Message-----
From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of Davies, Brett
Sent: Saturday, 1 August 2009 8:22 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] How did u go Mr Jolly?

Hey Mike..just wondered how you got on with homeandlearn.co.uk?

I think its a very good VB course for our students, it covers almost
everyting at the right level, very few cover database connections as
well as he does

I hope you got it covered. If not give me a call at school next week and
Ill try and help you out.

Cheers
Brett
0359716100
________________________________________
From: sofdev-bounces at edulists.com.au [sofdev-bounces at edulists.com.au] On
Behalf Of Jolly, Michael D [Jolly.Michael.D at edumail.vic.gov.au]
Sent: Thursday, July 30, 2009 3:07 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn

Thanx Brett, I have had a quick look and it looks like exactly what I
need. Will play with it tonight.
Mike J.

From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of Davies, Brett
Sent: Thursday, 30 July 2009 2:35 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn

Mike

I use this excellent website to teach VB.NET. I purchased the pdf but
the entire thing is published online and can be accessed for free

Here is the link to the databases section

http://homeandlearn.co.uk/NET/nets12p1.html

Let us know how you get on

Cheers
Brett
From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of Jolly, Michael D
Sent: Thursday, 30 July 2009 2:14 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn

I think I meant U4O1! One of those days!

From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of Jolly, Michael D
Sent: Thursday, 30 July 2009 12:15 PM
To: Year 12 Software Development Teachers' Mailing List
Subject: RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn

Adrian, (and others), you may have some advice for me.
I am coming to the business end of U4O2 and wanted to get the kids up to
speed on using VB .NET to access Access!
I was looking at the  instructions in your book(Chap.13) and I am stuck.
We are using VB 2005 Express Edition and when I or my students look in
the Toolbox under the Data section, we do not get the ole adapters.
I was wondering if anyone out there has a script for calling DB's from
VB .NET without using the adapters as clearly 'Express' means you don't
get everything, but there must be a way to do these database calls.
Help...
Mike Jolly
IT Manager
Kyneton Secondary College

From: sofdev-bounces at edulists.com.au
[mailto:sofdev-bounces at edulists.com.au] On Behalf Of Adrian Janson
Sent: Friday, 24 July 2009 10:07 AM
To: 'Year 12 Software Development Teachers' Mailing List'
Subject: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn

Hi everyone,

I have posted some new items to my site that some of you might be
interested in.

My U3O2 2009 suggested solutions (Janno's Paella Barn)
http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_down
load&gid=52&Itemid=4

My U4O1 2009 assessment criteria sheet
http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_down
load&gid=51&Itemid=4

My U4O1 Janno's Paella Barn
http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_down
load&gid=53&Itemid=4

Cheers,
Adrian

Adrian Janson,
VITTA President
Director of ICT,
Melbourne High School,
Forrest Hill, South Yarra 3141 Australia.
Phone: 03 9826 0711 International: +61 3 9826 0711
Fax: 03 9826 8767 International: +61 3 9826 8767
E-mail:
janson.adrian.a at edumail.vic.gov.au<mailto:janson.adrian.a at edumail.vic.go
v.au>
School WWW: http://www.mhs.vic.edu.au<http://www.mhs.vic.edu.au/>
My WWW: http://www.adrianjanson.com.au<http://www.adrianjanson.com.au/>
Blog: http://jansona.edublogs.org<http://jansona.edublogs.org/>
Delicious: http://delicious.com/adrianjanson/

Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education and Early Childhood Development.
_______________________________________________
http://www.edulists.com.au IT Software Development Mailing List kindly
supported by
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html<http:
//www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20> -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education and Early Childhood Development.
_______________________________________________
http://www.edulists.com.au IT Software Development Mailing List kindly
supported by
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html<http:
//www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20> -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc
_______________________________________________
http://www.edulists.com.au IT Software Development Mailing List kindly
supported by
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html<http:
//www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20> -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education and Early Childhood Development.

_______________________________________________
http://www.edulists.com.au IT Software Development Mailing List kindly
supported by
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

_______________________________________________
http://www.edulists.com.au
IT Software Development Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  -
VITTA Victorian Information Technology Teachers Association Inc

Important - This email and any attachments may be confidential. If received
in error, please contact us and delete all copies. Before opening or using
attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or
not, resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education and Early Childhood
Development.

_______________________________________________
http://www.edulists.com.au
IT Software Development Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  - VITTA
Victorian Information Technology Teachers Association Inc

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.