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 45 46 47 48 49 50 51 52 53 54 55 56 57 58
| Imports MySql.Data.Entity
Imports MySql.Data.MySqlClient
Imports MySql.Data.Types
Public Class Expediteur
Public ile As String
Public Function connecter()
Dim Connexion As String = "Server=localhost;Database=gestransfert;Uid=pierrengb;Pwd=pierrengb2014;"
Dim conn As MySqlConnection = New MySqlConnection
conn.ConnectionString = Connexion
conn.Open()
Return conn
End Function
Private Sub Fonds_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim lecteur As MySqlDataReader
Dim Requete As String
connecter.Close()
connecter()
Requete = "select Code_agence from agence"
Dim Commande As New MySqlCommand(Requete, connecter)
lecteur = Commande.ExecuteReader
Do While lecteur.Read
ComboBox2.Items.Add(lecteur.GetString("Code_agence"))
Loop
connecter.Close()
End Sub
'Ensuite il est meêm possible de faire une insertion
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim code, nom, postnom, tel, adr, email, sexe As MySqlParameter
connecter()
Dim sql As String
sql = "INSERT INTO expediteur VALUES (@code, @nom, @postnom, @tel, @adr, @email, @sexe)"
Dim query As New MySqlCommand(sql, connecter)
code = New MySqlParameter("@code", txt_code.Text)
nom = New MySqlParameter("@nom", txt_nom.Text)
postnom = New MySqlParameter("@postnom", txt_postnom.Text)
tel = New MySqlParameter("@tel", txt_phone.Text)
adr = New MySqlParameter("@adr", txt_adresse.Text)
email = New MySqlParameter("@email", txt_email.Text)
sexe = New MySqlParameter("@sexe", cmb_sexe.Text)
query.Parameters.Add(code)
query.Parameters.Add(nom)
query.Parameters.Add(postnom)
query.Parameters.Add(tel)
query.Parameters.Add(adr)
query.Parameters.Add(email)
query.Parameters.Add(sexe)
query.ExecuteNonQuery()
connecter.close()
End Sub
EndClass |
Partager