frmdelbanji.frm

班主任考核管理系统

VERSION 5.00
Begin VB.Form frmdelbanji 
   Caption         =   "删除班级"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   Begin VB.CommandButton Command2 
      Caption         =   "取消"
      Height          =   495
      Left            =   2760
      TabIndex        =   3
      Top             =   1920
      Width           =   975
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定"
      Height          =   495
      Left            =   1080
      TabIndex        =   2
      Top             =   1920
      Width           =   975
   End
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   2400
      TabIndex        =   1
      Text            =   "选择"
      Top             =   720
      Width           =   1575
   End
   Begin VB.Label Label1 
      Caption         =   "请选择您要删除的班级名称"
      Height          =   375
      Left            =   840
      TabIndex        =   0
      Top             =   720
      Width           =   1215
   End
End
Attribute VB_Name = "frmdelbanji"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
   Dim mr As ADODB.Recordset
  Dim msgtext As String
    If Trim(Combo1) = "选择" Then
    MsgBox "请选择要修改的班级名称！", vbOKOnly + vbExclamation, "警告"
     Exit Sub
  End If
  txtSQL = "delete from class where id='" & Trim(Combo1) & "'"
  Set mr = ExecuteSQL(txtSQL, msgtext)
  Combo1 = "选择"
  MsgBox "纪录删除成功！", vbOKOnly + vbExclamation, "提示"
End Sub

Private Sub Command2_Click()
  Unload Me
End Sub

Private Sub Form_Load()
Me.Height = 3600
  Me.Width = 4800
  Me.Top = frmmdi.Height / 2 - 2400
  Me.Left = frmmdi.Width / 2 - 2400
  Dim mrccc1 As ADODB.Recordset
  Dim msgtext1 As String
  Dim txtSQL As String
  txtSQL = "select id from class"
  Set mrccc1 = ExecuteSQL(txtSQL, msgtext1)

   Do While Not mrccc1.EOF
    Combo1.AddItem mrccc1.Fields(0)
    mrccc1.MoveNext
   Loop
   mrccc1.Close
  
End Sub