<HTML dir=ltr><HEAD><TITLE>VB.NET help needed</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText99110 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Hafoka,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>To search the database just set the .CommandText with a SELECT query that has a criterion. You can first setup and run this query in Access to test. Then copy the SQL from the Access SQL window and paste it in the VB.net code. Have a look at my SAC project as I've done precisely this.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Have a try and if you still have trouble, feel free to send me the project + database to <A href="mailto:harryS@ozonline.com.au">harryS@ozonline.com.au</A> and I'll fix it for you.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Note, your email did not get to the list so I'm replying to the list. You need to type in: sofdev@edulists.com.au</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV id=idSignature16256 dir=ltr>
<DIV><FONT face=Arial color=#000000 size=2>Harry Schlanger</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Belmont HS</FONT></DIV>
<DIV><FONT face=Arial size=2>Phone: 5243 5355</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Hafoka Ross [mailto:hafr@jpc.vic.edu.au]<BR><B>Sent:</B> Fri 7/6/2007 1:43 PM<BR><B>To:</B> Schlanger, Harry P; Year 12 Software Development Teachers' Mailing List<BR><B>Subject:</B> VB.NET help needed<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hi all,<BR><BR>I am preparing my SAC I for Unit 4 and I am now "stuck" with one<BR>functionality that I just can't work out. I am trying to implement a<BR>'search routine' to search a database created in Access with VB.NET<BR>interface as a 'front-end'. To save me time and headaches, I wonder if<BR>someone out there has written a search routine that I may be able to<BR>use. If anyone out there can help then please let me know.<BR><BR>To Harry Schlanger, thank you so much for your codes - I have used some<BR>of your codes in my Outcome too. Originally I used the Server Explorer<BR>to make the connection, DataAdater to create Dataset and the Databidings<BR>Property for Navigation around the database and it worked but after<BR>looking at your codes, I redesigned the whole thing and it is working<BR>perfectly. All I need now is a search routine and I will be done with my<BR>SAC 1.<BR><BR>Cheers to you all and happy working with VB.NET<BR><BR><BR>++++++++++++++++++++++++++++++++++++<BR>Mr Ross Loseli Ma'ukie Hafoka<BR>Head of Information Technology Department<BR>John Paul College<BR>FRANKSTON VIC 3199<BR>++++++++++++++++++++++++++++++++++++<BR>"What I hear, I forget<BR>"What I teach to another, I master"<BR></FONT></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.</p></BODY></HTML>