A
Angelina
Hi,
I wanted to know how i can pass varibales from my vb.net
interface to my Access xp database??
What i want to do is use the date selected by the user
from 2 dtpickers and use these in my OLEDataAdapter query.
(I dont know what to type in in the OLEDataAdapter query
builder).
what do i write in my query to represent these variables
in my query??
what i want to write a query that selects the rooms that
are not booked withing the date period specified by the
user.
I have 3 tables that i may need to use:
Room Details (a descrption of all the rooms in the hotel):
RoomNo
RoomName
Room Booking (a link table to handle the M:N
relationship):
RoomNo
BookingNo
Booking Table (Contains details of the guest and his
booking details):
BookingNo
DateOfArrival
DateOfDeparture
Can anyone plz help me with this. Iv been stuck for
ages (
I wanted to know how i can pass varibales from my vb.net
interface to my Access xp database??
What i want to do is use the date selected by the user
from 2 dtpickers and use these in my OLEDataAdapter query.
(I dont know what to type in in the OLEDataAdapter query
builder).
what do i write in my query to represent these variables
in my query??
what i want to write a query that selects the rooms that
are not booked withing the date period specified by the
user.
I have 3 tables that i may need to use:
Room Details (a descrption of all the rooms in the hotel):
RoomNo
RoomName
Room Booking (a link table to handle the M:N
relationship):
RoomNo
BookingNo
Booking Table (Contains details of the guest and his
booking details):
BookingNo
DateOfArrival
DateOfDeparture
Can anyone plz help me with this. Iv been stuck for
ages (