[Year 12 SofDev] RE: VB.NET help needed - Hafoka Ross

[Schlanger, Harry P]

Hi Hafoka,
 
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.
 
Have a try and if you still have trouble, feel free to send me the project + database to harryS at ozonline.com.au and I'll fix it for you.
 
Note, your email did not get to the list so I'm replying to the list. You need to type in: sofdev at edulists.com.au
 
Regards,
 
Harry Schlanger
 
Belmont HS
Phone: 5243 5355

________________________________

From: Hafoka Ross [mailto:hafr at jpc.vic.edu.au]
Sent: Fri 7/6/2007 1:43 PM
To: Schlanger, Harry P; Year 12 Software Development Teachers' Mailing List
Subject: VB.NET help needed



Hi all,

I am preparing my SAC I for Unit 4 and I am now "stuck" with one
functionality that I just can't work out. I am trying to implement a
'search routine' to search a database created in Access with VB.NET
interface as a 'front-end'. To save me time and headaches, I wonder if
someone out there has written a search routine that I may be able to
use. If anyone out there can help then please let me know.

To Harry Schlanger, thank you so much for your codes - I have used some
of your codes in my Outcome too. Originally I used the Server Explorer
to make the connection, DataAdater to create Dataset and the Databidings
Property for Navigation around the database and it worked but after
looking at your codes, I redesigned the whole thing and it is working
perfectly. All I need now is a search routine and I will be done with my
SAC 1.

Cheers to you all and happy working with VB.NET


++++++++++++++++++++++++++++++++++++
Mr Ross Loseli Ma'ukie Hafoka
Head of Information Technology Department
John Paul College
FRANKSTON VIC 3199
++++++++++++++++++++++++++++++++++++
"What I hear, I forget
"What I teach to another, I master"



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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/sofdev/attachments/20070706/ad38d3a4/attachment-0001.html