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
|
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim MyConnexion As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\vb.net\ajouter\personne.mdb;")
Dim Mycommand As OleDbCommand = MyConnexion.CreateCommand()
Private Sub ComboBox1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.Click
Mycommand.CommandText = "select nom from personne where id = "form1.textbox1.text" "
MyConnexion.Open()
inputbox("","", Mycommand.CommandText) 'permet de recuperer la requete et de trouver l'erreur :)
Dim myReader As OleDbDataReader = Mycommand.ExecuteReader()
if myReader.HasRow then
Do While (myReader.Read())
ComboBox1.Items.Add(myReader.GetString(0)) 'ajoute tous les éléments de ta table
Loop
else
MessageBox.Show("aucune ligne dans le reader")
End If
MyConnexion.Close()
End Sub
End Class |