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 59 60 61 62 63 64 65 66
| Imports MySql.Data.Entity
Imports MySql.Data.MySqlClient
Imports MySql.Data.Types
Public Class Form1
Public Sub Lecture()
Dim ConnexionSql As String = "Server=197.28.178.33;Port=3306;Database=test;Uid=root@localhost;Pwd=nabeul30071986;"
Dim champs As String
Try
Dim query As String = "SELECT * FROM article" 'Requête SQL
Dim connection As New MySqlConnection(ConnexionSql)
Dim cmd As New MySqlCommand(query, connection)
connection.Open()
Dim reader As MySqlDataReader
reader = cmd.ExecuteReader()
While reader.Read()
'Les champs à recup. Les tables commencent à 0.
champs = ((reader.GetString(0)))
MsgBox(champs)
End While
reader.Close()
connection.Close()
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Sub
'Fin requête
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ok.Click
Lecture() 'Appel de la requête
End Sub
Public ile As String
Public Function connecter()
Dim Connexion As String = "Server=197.28.178.33;Database=test;Uid=root@localhost;Pwd=nabeul30071986;"
Dim conn As MySqlConnection = New MySqlConnection
conn.ConnectionString = Connexion
conn.Open()
Return conn
End Function
Private Sub form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim lecteur As MySqlDataReader
Dim Requete As String
connecter.Close()
connecter()
Requete = "select * from article"
Dim Commande As New MySqlCommand(Requete, connecter)
lecteur = Commande.ExecuteReader
Do While lecteur.Read
ComboBox1.Items.Add(lecteur.GetString("description"))
Loop
connecter.Close()
End Sub |
Partager