allroominfo.frm

酒店课房管理系统。完成酒店的客房入住

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form AllRoomInfo 
   Caption         =   "所有房间信息"
   ClientHeight    =   6825
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   9990
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   6825
   ScaleWidth      =   9990
   StartUpPosition =   2  'CenterScreen
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "AllRoomInfo.frx":0000
      Height          =   5295
      Left            =   360
      OleObjectBlob   =   "AllRoomInfo.frx":001B
      TabIndex        =   1
      Top             =   360
      Width           =   9255
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "退出"
      Height          =   495
      Left            =   3960
      TabIndex        =   0
      Top             =   5880
      Width           =   1815
   End
   Begin VB.Data dataRoomInfo 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   1200
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   5880
      Visible         =   0   'False
      Width           =   1380
   End
End
Attribute VB_Name = "AllRoomInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private cnnHotel As New ADODB.Connection
Private rsCustReserveInfo As New ADODB.Recordset
Private rsRooms As New ADODB.Recordset

Private Sub cmdExit_Click()
    Unload AllRoomInfo
    frmRoomInfo.Show 1
End Sub

Private Sub Form_Load()
    dataRoomInfo.DatabaseName = GetDBPath   '获取数据库路径
    dataRoomInfo.RecordSource = "Rooms"
End Sub