Форум программистов [Powered by Invision Power Board]

Код


    Private Sub addsert_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        query = "select * from fio order by fam"
        sql_zapros(query, True)
        While myDataReader.Read
            NameBox.Items.Add(myDataReader("fam"))
            IDCombo.Items.Add(myDataReader("ID"))
            CategoryCombo.Items.Add(myDataReader("fid"))
        End While
        myConn.Close()
    End Sub

    Private Sub NameBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NameBox.SelectedIndexChanged
        IDCombo.SelectedIndex = NameBox.SelectedIndex
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim newID As Integer
        If (IsDate(DM1Masked.Text) And IsDate(DM2Masked.Text)) Then
            If Not (NUmberBox.Text = "" Or IDCombo.Text = "" Or CategoryCombo.Text = "" Or KursIDCombo.Text = "") Then

                query = "select max(id) as maxid from sertificates"
                sql_zapros(query, True)
                While myDataReader.Read
                    newID = myDataReader("maxid")
                End While
                myConn.Close()

                newID = newID + 1
                query = "insert into sertificates values(" & newID & ",'" & NUmberBox.Text & "'," & IDCombo.Text & "," & CategoryCombo.Text & "," & KursIDCombo.Text & ",'" & DM1Masked.Text & "','" & DM2Masked.Text & "');"
                sql_zapros(query, False)
                myConn.Close()
                StatusLabel.Text = "Запись успешно добавлена!"
            Else
                MessageBox.Show("Не заполнено одно из полей!")
            End If
        Else
            MessageBox.Show("Неверно введена дата!")
        End If
    End Sub