frmdelstuent_class.vb

通用学籍管理软件 vb开发access数据库的实例

Public Class FrmDelStuent_Class

    Private Sub FrmDelStuent_Class_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.ComboClass.DataSource = DBClass.LoadClass
        Me.ComboClass.DisplayMember = "班级名称"
        Me.ComboClass.SelectedIndex = 0
    End Sub

    Private Sub BtnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnOK.Click
        DGVResult.DataSource = DBStudent.LoadStudent("ClassName", ComboClass.Text, "")
    End Sub



    Private Sub DGVResult_CellDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGVResult.CellDoubleClick
        If User.Mod2 = "可读" Then
            MsgBox("您无权写入记录！", MsgBoxStyle.Exclamation, "信息框")
            Exit Sub
        End If
        Dim DR As DialogResult
        DR = MsgBox("请确认是否删除 " & DGVResult.Rows(e.RowIndex).Cells(1).Value & " 这条记录", MsgBoxStyle.YesNo, "信息框")
        If DR = Windows.Forms.DialogResult.Yes Then
            DBStudent.DelStudent(DGVResult.Rows(e.RowIndex).Cells(0).Value)
        Else
            Exit Sub
        End If
        DGVResult.DataSource = DBStudent.LoadStudent("ClassName", ComboClass.Text, "")
    End Sub
End Class