Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Need some major VB.Net help

YoshiYoshi Member Posts: 1
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, and how to I check to see if a guest is already in the database?(I do know SQL, i just don't know how to do it from VB.net)

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.

Comments

  • Initial_KInitial_K Member Posts: 3
    : 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, and how to I check to see if a guest is already in the database?(I do know SQL, i just don't know how to do it from VB.net)
    :
    : 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.
    :
    :

  • Initial_KInitial_K Member Posts: 3
    : 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, and how to I check to see if a guest is already in the database?(I do know SQL, i just don't know how to do it from VB.net)
    :
    : 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.
    :
    :
    Sup Yoshi,
    I think if you were to open the toolbox and click the Data Tab and drag that OleDbDataAdapter control and drop it in your form, a wizard will pop up and then you choose the connection. Hope that helps you out man....Laterz
  • Shawn CarterShawn Carter Member Posts: 0

    _____ [ http://forcoder.org ] free ebooks and video tutorials about || Perl C++ Delphi JavaScript MATLAB Python Assembly Java Objective-C C# Swift Visual Basic Scratch R C PHP Go PL/SQL Visual Basic .NET Ruby Alice Logo COBOL ML FoxPro Prolog Awk SAS VBScript ABAP Kotlin Hack LabVIEW Apex D Julia Scheme Clojure Scala Fortran Lisp Erlang Dart Transact-SQL Ada Rust Lua Crystal Bash F# || ______

Sign In or Register to comment.