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 67 68 69
|
Imports System.Data.SqlClient
Imports System.IO
Public Class Form3
Private strCon As String = My.Settings.BDPHOTOSConnectionString
Private Sub Form3_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
ListView1.View = View.Details
ListView1.FullRowSelect = True
ListView1.GridLines = True
ListView1.Columns.Add("Column0", -2, HorizontalAlignment.Left)
ListView1.Columns.Add("Column1", -2, HorizontalAlignment.Left)
ListView1.Columns.Add("Column2", -2, HorizontalAlignment.Left)
'----------AJOUTER ----------
PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage
End Sub
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
ImageList1.Images.Clear()
'----------AJOUTER ----------
ImageList1.ImageSize = New Size(256, 256)
Using conn As New SqlConnection(strCon)
conn.Open()
Using cmd As New SqlCommand("SELECT NUM_LIGNE,NOM ,PHOTO FROM ALBUM", conn)
Using rd As SqlDataReader = cmd.ExecuteReader()
Dim ndxImage As Integer = 0
While rd.Read()
Dim Num_Ligne As String = rd("NUM_lIGNE").ToString()
Dim Nom As String = rd("NOM").ToString()
Dim Photo_Bytes() As Byte = New Byte(0) {}
Photo_Bytes = CType(rd("PHOTO"), Byte())
Dim pic As Image
Using ms As New MemoryStream(Photo_Bytes)
pic = Image.FromStream(ms)
End Using
ImageList1.Images.Add(pic)
Dim lvitem As New ListViewItem()
lvitem.ImageIndex = ndxImage ' commente cette ligne si tu ne veux pas voir la photo dans ListView
lvitem.SubItems.Add(rd("NUM_LIGNE").ToString)
lvitem.SubItems.Add(rd("NOM"))
Me.ListView1.Items.Add(lvitem)
ndxImage += 1
End While
End Using ' close reader
End Using ' close cmd
End Using ' close conn
ListView1.SmallImageList = ImageList1
End Sub
Private Sub ListView1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ListView1.SelectedIndexChanged
If (ListView1.SelectedItems.Count > 0) Then
Dim lvitem As ListViewItem = ListView1.SelectedItems(0)
PictureBox1.Image = ImageList1.Images(lvitem.Index)
End If
End Sub
End Class |
Partager