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
| Call ConnexionMotDePasse()
'Création de la requête sql
Dim varIdReeduc As String = mdtIdentifiant.Text
Dim varMpReeduc As String = mdtMotDePasse.Text
sql = "select noReeduc, nomReeduc, idReeduc, mpReeduc from reeducateur where idReeduc ='" & varIdReeduc & "and mpReeduc =" & varMpReeduc & "'"
cmd = New OleDbCommand(sql)
dta = New OleDbDataAdapter(cmd)
cmd.Connection() = con
dta.Fill(dts, "reeducateur")
dtt = dts.Tables("reeducateur")
Try
If varIdReeduc = dtt.Rows(rownum).Item("idReeduc") And
varMpReeduc = dtt.Rows(rownum).Item("mpReeduc") Then
frmBReeducateur.Show()
frmBReeducateur.lblAfficherReeducConnecter.Text = "Bonjour ! " & dtt.Rows(rownum).Item("nomReeduc")
lblNoReeducateur.Text = dtt.Rows(rownum).Item("noReeduc")
Else
mdtIdentifiant.Text = ""
mdtMotDePasse.Text = ""
lblAvertissement.Visible = True
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try |
Partager