Bethesda Car Rental - Documents

 

 


 
Customers
CustomerID DrvLicNbr FullName Address City State ZIPCode Country
1 W-240-573-885 John Wattson 4024 Locktar Drive Silver Spring MD 20904 USA
2 264-72-6663 Charles Calhoun 10630 Leila Rd #D4 Alexandria VA 22231 USA
3 802-46-4006 Jeannine Pons 802 Mimosa Road NW Washington DC 20006 USA

 

CarID TagNumber Make Model Year Category DVDPlayer CDPlayer Available
1 335-168 Chevrolet Malibou 2008 Full Size Unchecked Checked Checked
2 475075 Hyundai Accent 2007 Economy Unchecked Unchecked Unchecked
3 M247957 Dodge Caravan 2007 Mini Van Checked Checked Checked
4 M466086 Ford Escape 2008 SUV Checked Checked Checked
5 GLL-944 Ford Focus 2007 Compact Unchecked Checked Unchecked
6 M648368 Lincoln Navigator 2007 SUV Checked Unchecked Checked
7 924759 Kia Rio 2008 Economy Unchecked Unchecked Checked
8 M270049 Mazda MPV 2007 Mini Van Checked Checked Unchecked

Control DataBinding -> Text DataSource DisplayMember ValueMember (DataBindings) -> Value (DataBindings) -> Selected Value
cboEmployeeID   bsEmployees EmployeeNumber EmployeeID   bsRentalOrders - EmployeeID
cboCustomerID   bsCustomers DrvLicNumber CustomerID   bsRentalOrders - CustomerID
cboCarID   bsCars TagNumber CarID   bsRentalOrders - CarID
cbxCarConditions bsRentalOrders - CarCondition          
cbxTankLevels bsRentalOrders - TankLevel          
cbxOrderStatus bsRentalOrders - OrderStatus          
  

Control DataBindings -> Text DataBindings - Checked
txtCarID bsCars - CarID  
txtTagNumber bsCars - TagNumber  
txtMake bsCars - Make  
txtModel bsCars - Model  
txtYear bsCars - CarYear  
txtMileage bsCars - Mileage  
cboCategories bsCars - Category  
chkK7Player   bsCars - K7Player
chkCDPlayer   bsCars - CDPlayer
chkDVDPlayer   bsCars - DVDPlayer
chkAvailable   bsCars - Available
txtPictureName bsCars - PictureName  
 

Return Copyright © 2008-2010 FunctionX, Inc.