form6.vb

学生成绩管理系统

Public Class Form6

    Private Sub Form6_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Module1.db()
        conn.Open()
        ds.Clear()


        cmd.CommandText = "select * from course"
        da.SelectCommand = cmd
        da.Fill(ds, "tab61")

        Dim i As Integer
        Dim j As Integer

        For i = 0 To ds.Tables("tab61").Rows.Count - 1
            ListView1.Items.Add("")
            For j = 0 To 2

                ListView1.Items(i).SubItems.Add(ds.Tables("tab61").Rows(i).Item(j))

            Next
        Next


        conn.Close()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Me.Close()
    End Sub

    Private Sub ListView1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListView1.SelectedIndexChanged

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim i As Integer, j As Integer

        Module1.db()
        conn.Open()
        
        cmd.CommandText = "select sno,cno from sc"
        da.SelectCommand = cmd
        da.Fill(ds, "tab62")
        For i = 0 To ds.Tables("tab62").Rows.Count - 1
            If TextBox1.Text = ds.Tables("tab62").Rows(i).Item(0) Then
                For j = 0 To ds.Tables("tab61").Rows.Count - 1
                    If ListView1.Items(j).Checked = True Then
                        If ds.Tables("tab61").Rows(j).Item(0) = ds.Tables("tab62").Rows(i).Item(1) Then
                            MsgBox("此课程已选,请重新选择!")
                            conn.Close()
                            Exit Sub
                        End If
                    End If
                Next
            End If

        Next
           

        For i = 0 To ds.Tables("tab61").Rows.Count - 1

            If ListView1.Items(i).Checked = True Then
                cmd.CommandText = " insert into sc(sno,cno) values('" & TextBox1.Text & "','" & ds.Tables("tab61").Rows(i).Item(0) & "')"
                cmd.ExecuteNonQuery()
                MsgBox("成功!")


            End If
        Next
        conn.Close()



    End Sub
End Class