I have this project to do in my VB.net class The project is write a vb.net program that makes reservations for a hotel storing the reservations in a Orcale 8 database Database schema Table Guests(GuestID,Fname,Lname,Address,City,State,Zip, Phone,CC) Table Reservations(ConfirmationNo,HotelID,GuestID,ArivalDate, DeparteDate,CC) There is a sequence for GuestID(GuestNo_sequence and ConfirmationNO_sequence) My problem is HOW DO I have VB.Net connect to the oracle database, how do I add records to the database? I have a VB form with text boxes for all the guest info and for the ArrivalDate and DepatureDate. I have a command button to save the info to the database(no code yet) a cancel button and a button to search to see if the guest is a repeat guest(no code yet) Please help!! We have only 2 days to work on this(no .Net at home) and our teacher never clearly went over this stuff. If anymore info is needed let me know.

You just need to focus your search appropriately. VB.Net, like VB before it, is just the language syntax you are using; you need to work with the particular library that supports databases. For the .Net languages, ADO.Net is the latest version of ADO for connectivity. Although M$ are just about to release a custom extension for Oracle (like they currently have for SQL Server), you can still use the generic OleDb provider. The web is swarming with ADO.Net info on how to do exactly what you want, just search Google with a search set like [oracle "ado.net" oledb or "ole db" provider] (without the brackets). You will get more info than you will ever need. Cheers

Go to : http://www.gotdotnet.com or http://www.dotnetjunkies.com There is plenty of info and tutorials there. Good Luck !!!

Thanks folks, Lots of good information.