• Anyone good with VB.NET or SQL?
    2 replies, posted
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.