I've got this uni assessment where I've got to integrate a visual basic .net program with an access database and although I sort of know what I'm doing, I keep hitting brick walls. Anyone mind giving me a hand?
[QUOTE]
The company ‘PHONES-R-US’ is a small local outlet selling a limited range of ‘smart’ phones. Note the company ONLY sells the latest ‘SMART’ phones.
The company wishes to develop a management information retrieval system.
The application should start up with a splash screen. Management should be able to log onto the system and display information held in the stored database. You should also demonstrate that you have used a range of data validation techniques in the application.
As a minimum the management will require.
1. Display ALL smart phones in stock, by item number and by manufacturer and by model and by price - FOUR lists are required. (Use a Data Grid or number of Data Grid controls)
2. Display TWO lists of smart phones for a fixed criteria. i.e smart phones with ‘touch screen’, or smart phones with ‘keyboard’. (Use a list control or a number of list controls)
3. Display the details of a smart phone based upon the model of the phone. i.e ‘5800 XpressMusic’. (use a text box to input the name of the phone).
4. Display details of smart phones for at least three criteria. i.e ‘screen size’, ‘WiFi’, ‘price range £200 - £250’, etc. (use a combo control to hold the criteria and display the results in a list control)
5. Update the cost of a smart phone (use a text box to input the new cost of the phone.)
6. Delete all details of a selected phone.
7. Delete all phones for a selected manufacturer
8. Add a new phone to the database (use text boxes, not a Data Grid control)
9. You are free to add other sensible management facilities.
[/QUOTE]
[url]http://www.daniweb.com/code/snippet216920.html[/url] looks promising, I haven't use VB.Net in a year, so I can't really help.
Thanks, that helped me realise I had incorrectly formatted my SQL query in the code! haha
Sorry, you need to Log In to post a reply to this thread.