<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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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-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-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-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Thanks, Adrian. I am playing
with all this on the weekend.<o:p></o:p></span></p>
<p class=MsoNormal><span 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 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 lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><o:p> </o:p></p>
<div id=idOWAReplyText63672>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Hi Mike,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span 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 style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span 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
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Cheers,</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Adrian</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><span 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
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 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 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
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='color:#1F497D'>I think I meant U4O1! One of
those days!</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Adrian, (and others), you may
have some advice for me.</span><o:p></o:p></p>
<p class=MsoNormal><span 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><o:p></o:p></p>
<p class=MsoNormal><span 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><o:p></o:p></p>
<p class=MsoNormal><span 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><o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Help…</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Mike Jolly</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>IT Manager</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Kyneton Secondary College </span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>Hi everyone,</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>I have posted some new items to my site
that some of you might be interested in.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>My U3O2 2009 suggested solutions (Janno’s
Paella Barn)</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US><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><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>My U4O1 2009 assessment criteria sheet</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US><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><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>My U4O1 Janno’s Paella Barn</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US><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><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Cheers,</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Adrian</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.5pt;font-family:
Consolas'>Adrian Janson, </span></b><o:p></o:p></p>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.5pt;font-family:
Consolas'>VITTA President</span></b><o:p></o:p></p>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.5pt;font-family:
Consolas'>Director of ICT, </span></b><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Melbourne
High School, </span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Forrest
Hill, South Yarra 3141 Australia.</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Phone:
03 9826 0711 International: +61 3 9826 0711</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Fax:
03 9826 8767 International: +61 3 9826 8767</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>E-mail:
</span><span lang=EN-US><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><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>School
WWW: </span><span lang=EN-US><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><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>My
WWW: </span><span lang=EN-US><a href="http://www.adrianjanson.com.au/"><span
style='font-size:10.5pt;font-family:Consolas'>http://www.adrianjanson.com.au</span></a></span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.5pt;font-family:Consolas'>Blog:
</span><span lang=EN-US><a href="http://jansona.edublogs.org/"><span
style='font-size:10.5pt;font-family:Consolas'>http://jansona.edublogs.org</span></a></span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>Delicious: <a
href="http://delicious.com/adrianjanson/">http://delicious.com/adrianjanson/</a></span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p><b><span lang=EN-US>Important - </span></b><span lang=EN-US>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><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US 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><o:p></o: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.<o:p></o:p></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><o:p></o: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.<o:p></o:p></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">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>
</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>