<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.emailstyle18
{mso-style-name:emailstyle18;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.emailstyle19
{mso-style-name:emailstyle19;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.emailstyle20
{mso-style-name:emailstyle20;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Mike,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Probably not – but I may do so
for VB.Net 2010. I am in the process of writing an XNA / C# book (I wish I had
more time on my hands!)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Cheers,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Adrian<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
sofdev-bounces@edulists.com.au [mailto:sofdev-bounces@edulists.com.au] <b>On
Behalf Of </b>Jolly, Michael D<br>
<b>Sent:</b> Friday, 31 July 2009 12:39 PM<br>
<b>To:</b> Year 12 Software Development Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Thanks, Adrian. I am
playing with all this on the weekend.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>BTW, are you bringing
out a newer version of your book soon?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> sofdev-bounces@edulists.com.au
[mailto:sofdev-bounces@edulists.com.au] <b>On Behalf Of </b>Janson, Adrian A<br>
<b>Sent:</b> Thursday, 30 July 2009 9:22 PM<br>
<b>To:</b> Year 12 Software Development Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p>
<div id=idOWAReplyText63672>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Hi Mike,</span><span lang=EN-AU style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif"'>You
may have solved this issue already - if not, I can help you out! There is
no need to place the ole adapters on the form (as you would have with previous
versions of VB.Net). Simply add a new data connection (you can find a tab
for this underneath the solution explorer) - or under the View menu. A
wizard will pop up that will guide you through the connection process and then
VB.Net will add the table adapter, etc.</span><span lang=EN-AU
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hope
this helps - and if not - let me know and I can elaborate further.</span><span
lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Cheers,</span><span
lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Adrian</span><span
lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-AU
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=EN-AU
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
lang=EN-AU style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
sofdev-bounces@edulists.com.au on behalf of Jolly, Michael D<br>
<b>Sent:</b> Thu 30/07/2009 2:14 PM<br>
<b>To:</b> Year 12 Software Development Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn</span><span
lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>I think I meant U4O1!
One of those days!</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
sofdev-bounces@edulists.com.au [mailto:sofdev-bounces@edulists.com.au] <b>On
Behalf Of </b>Jolly, Michael D<br>
<b>Sent:</b> Thursday, 30 July 2009 12:15 PM<br>
<b>To:</b> Year 12 Software Development Teachers' Mailing List<br>
<b>Subject:</b> RE: [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn</span><span
lang=EN-AU><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Adrian, (and others),
you may have some advice for me.</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>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!</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>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.</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>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.</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Help…</span><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Mike Jolly</span><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>IT Manager</span><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Kyneton Secondary
College </span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
sofdev-bounces@edulists.com.au [mailto:sofdev-bounces@edulists.com.au] <b>On
Behalf Of </b>Adrian Janson<br>
<b>Sent:</b> Friday, 24 July 2009 10:07 AM<br>
<b>To:</b> 'Year 12 Software Development Teachers' Mailing List'<br>
<b>Subject:</b> [Year 12 SofDev] U3O2 and U4O1 Janno's Paella Barn</span><span
lang=EN-AU><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal>Hi everyone,<span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal>I have posted some new items to my site that some of you
might be interested in.<span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal>My U3O2 2009 suggested solutions (Janno’s Paella Barn)<span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><a
href="http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=52&Itemid=4">http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=52&Itemid=4</a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal>My U4O1 2009 assessment criteria sheet<span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><a
href="http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=51&Itemid=4">http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=51&Itemid=4</a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal>My U4O1 Janno’s Paella Barn<span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><a
href="http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=53&Itemid=4">http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=53&Itemid=4</a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Cheers,</span><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Adrian</span><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas'>Adrian
Janson, </span></b><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas'>VITTA
President</span></b><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.5pt;font-family:Consolas'>Director
of ICT, </span></b><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Melbourne
High School, </span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Forrest
Hill, South Yarra 3141 Australia.</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Phone:
03 9826 0711 International: +61 3 9826 0711</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Fax: 03
9826 8767 International: +61 3 9826 8767</span><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>E-mail: </span><a
href="mailto:janson.adrian.a@edumail.vic.gov.au"><span style='font-size:10.5pt;
font-family:Consolas'>janson.adrian.a@edumail.vic.gov.au</span></a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>School
WWW: </span><a href="http://www.mhs.vic.edu.au/"><span style='font-size:10.5pt;
font-family:Consolas'>http://www.mhs.vic.edu.au</span></a><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>My WWW: </span><a
href="http://www.adrianjanson.com.au/"><span style='font-size:10.5pt;
font-family:Consolas'>http://www.adrianjanson.com.au</span></a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:Consolas'>Blog: </span><a
href="http://jansona.edublogs.org/"><span style='font-size:10.5pt;font-family:
Consolas'>http://jansona.edublogs.org</span></a><span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal>Delicious: <a href="http://delicious.com/adrianjanson/">http://delicious.com/adrianjanson/</a><span
lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU> <o:p></o:p></span></p>
<p><b>Important - </b>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.<span lang=EN-AU><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au/">http://www.edulists.com.au </a>IT Software
Development Mailing List kindly supported by <br>
<a
href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html</a>
- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/">http://www.vitta.org.au </a>- VITTA
Victorian Information Technology Teachers Association Inc</span><span
lang=EN-AU><o:p></o:p></span></p>
<p><b><span lang=EN-AU>Important - </span></b><span lang=EN-AU>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au/">http://www.edulists.com.au </a>IT
Software Development Mailing List kindly supported by <br>
<a
href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html</a>
- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/">http://www.vitta.org.au </a>- VITTA
Victorian Information Technology Teachers Association Inc</span><span
lang=EN-AU><o:p></o:p></span></p>
<p><b><span lang=EN-AU>Important - </span></b><span lang=EN-AU>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au/">http://www.edulists.com.au </a>IT
Software Development Mailing List kindly supported by <br>
<a href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html</a>
- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au/">http://www.vitta.org.au </a>- VITTA
Victorian Information Technology Teachers Association Inc <o:p></o:p></span></p>
</div>
<p><b><span lang=EN-AU>Important - </span></b><span lang=EN-AU>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>IT Software
Development Mailing List kindly supported by <br>
<a href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html%20%20">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html</a>
- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></p>
</div>
<p></p><p><b>Important - </b>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.</p>
</body>
</html>