formcoursetab.frm

基于Visual Basic 6.0 与Access 2003的学籍管理系统,可以实现许多功能

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form frmCourseTab 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "课程表"
   ClientHeight    =   3870
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   8580
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3870
   ScaleWidth      =   8580
   StartUpPosition =   1  '所有者中心
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "FormCourseTab.frx":0000
      Height          =   1815
      Left            =   360
      OleObjectBlob   =   "FormCourseTab.frx":001C
      TabIndex        =   7
      Top             =   1800
      Width           =   7935
   End
   Begin VB.Data dataStudent 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   "C:\Program Files\StudentMIS\StudentMIS.mdb"
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   6600
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "Student"
      Top             =   1320
      Visible         =   0   'False
      Width           =   1215
   End
   Begin VB.Data dataCourseTab 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   "C:\Program Files\StudentMIS\StudentMIS.mdb"
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   6720
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "CourseTab"
      Top             =   960
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.CommandButton cmdQuit 
      Caption         =   "退出"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   5520
      TabIndex        =   6
      Top             =   960
      Width           =   735
   End
   Begin VB.CommandButton cmdOK 
      Caption         =   "查询"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   2400
      TabIndex        =   5
      Top             =   960
      Width           =   735
   End
   Begin VB.TextBox txtName 
      DataField       =   "Name"
      DataSource      =   "dataStudent"
      Height          =   375
      Left            =   5400
      MaxLength       =   10
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   360
      Width           =   2055
   End
   Begin VB.TextBox txtStudentID 
      DataField       =   "StudentID"
      DataSource      =   "dataStudent"
      Height          =   375
      Left            =   2280
      MaxLength       =   8
      TabIndex        =   1
      Text            =   "Text1"
      Top             =   360
      Width           =   2055
   End
   Begin VB.Label Label3 
      Caption         =   "你的课程表为"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   840
      TabIndex        =   4
      Top             =   1440
      Width           =   1335
   End
   Begin VB.Label Label2 
      Caption         =   "姓名"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   4680
      TabIndex        =   2
      Top             =   360
      Width           =   495
   End
   Begin VB.Label Label1 
      Caption         =   "请输入学号"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   960
      TabIndex        =   0
      Top             =   360
      Width           =   1095
   End
End
Attribute VB_Name = "frmCourseTab"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub cmdOK_Click()

'strSQL = "SELECT * FROM Student , Class ,Department "

'txtStudentID.Text = " SELECT * FROM Student WHERE StudentID = '" & txtStudent.Text & "'"

strSQL = "SELECT * FROM Student WHERE StudentID ='" & txtStudentID.Text & "'"

dataStudent.RecordSource = strSQL
 
dataCourseTab.RecordSource = "SELECT CourseSelect.ClassRoom, CourseSelect.ClassDate,CourseSelect.StudentID,Course.Teacher, Course.Credit, Course.CourseName,Student.Name FROM CourseSelect,Course,Student WHERE CourseSelect.StudentID = '" & txtStudentID.Text & "' AND Course.CourseID = CourseSelect.CourseID AND Student.StudentID='" & txtStudentID.Text & "'"

'strSQL = "SELECT * FROM Student WHERE

dataStudent.Refresh

dataCourseTab.Refresh

End Sub

Private Sub cmdQuit_Click()

Unload Me

End Sub

Private Sub Form_Load()

dataStudent.DatabaseName = App.Path & "\StudentMIS.mdb"

dataCourseTab.DatabaseName = App.Path & "\StudentMIS.mdb"

dataStudent.Visible = False

txtStudentID.Text = ""

End Sub