1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
Public Class Frmajoutab
Private Sub Btnvalider_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btnvalider.Click
'Dim mg As String
Dim cn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
Dim cmd As New OleDb.OleDbCommand
Dim OledbDataAdapter As New OleDb.OleDbDataAdapter
sql = "insert into Abonnement (Num_abonnement, Lib_abonnement, Date_debut_ab, Date_fin_ab, Montant_ab, Num_frs, Nom_frs) values (" & Me.Txtnumab.Text & ", " & Me.Txtlibab.Text & ", " & Me.Dates.Text & ", " & Me.Datef.Text & ", " & Me.Txtmontantab.Text & ", " & Me.Txtnumfrs.Text & ", " & Me.Cbxfrs.Text & ") "
If Txtnumab.Text = "" Or Txtlibab.Text = "" Or Txtmontantab.Text = "" Or Txtnumfrs.Text = "" Then
MsgBox("Vous devez saisir des valeurs non nulles.", MsgBoxStyle.Critical + MsgBoxStyle.OkOnly)
Exit Sub
End If
sql1 = "select count * from Abonnement where Num_abonnement ='" & Txtnumab.Text & "'"
'mg = "Etes vous sûre de vouloir créer cet abonnement?"
'If mg = vbNo Then Exit Sub
'If mg = vbYes Then
Try
cn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=C:\Marches.mdb"
cn.Open()
cmd.Connection = cn
cmd.CommandText = sql
OledbDataAdapter.SelectCommand = cmd
OledbDataAdapter.Fill(MarchesDataSet.Marche)
cmd.ExecuteNonQuery()
If Me.AbonnementTableAdapter.Fill(Me.MarchesDataSet.Abonnement) <> 0 Then
MsgBox("Cet abonnement existe déjà", MsgBoxStyle.Critical + MsgBoxStyle.OkOnly)
Exit Sub
Else
sql = "insert into Abonnement (Num_abonnement, Lib_abonnement, Date_debut_ab, Date_fin_ab, Montant_ab, Num_frs, Nom_frs) values (" & Me.Txtnumab.Text & ", " & Me.Txtlibab.Text & ", " & Me.Dates.Text & ", " & Me.Datef.Text & ", " & Me.Txtmontantab.Text & ", " & Me.Txtnumfrs.Text & ", " & Me.Cbxfrs.Text & ") "
MsgBox("Votre opération a été effectuée avec succès.", MsgBoxStyle.Information + MsgBoxStyle.OkOnly)
End If
cn.Close()
Catch ex As Exception
MsgBox(ex.Message)
cn.Close()
Finally
cn.Close()
End Try
Me.Close()
Frmprincipale.Show()
End Sub
End Class |
Partager