1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged
TextBox1.Text = ListBox1.SelectedItem
ListBox1.Visible = False
conn()
Dim cd As New SqlCommand("select * from tatable where nom=@Nom", con)
Dim rd As SqlDataReader
cd.Parameters.Add(New SqlParameter("@Nom", SqlDbType.VarChar, 50))
cd.Parameters("@Nom").Value = (TextBox1.Text)
rd = cd.ExecuteReader
While rd.Read
TextBox1.Text = rd(1)
End While
rd.Close()
disconn()
end sub |
Partager