Database

SELECT * FROM Article, Member, Album 
LEFT JOIN
  ( SELECT * 
    FROM
       linkArticleAlbum, Photo, Album
    WHERE
       linkArticleAlbum.Album = Photo.Album AND
       linkArticleAlbum.Album = Album.ID AND
       Photo.IsIcon = true ) As AlbumLink
   ON AlbumLink.linkArticleAlbum.Article = Article.ID
WHERE
   Article.Author = Member.ID AND
   Article.Team = 1
ORDER BY Article.DateCreated DESC, Article.Title

Dim b As Binding = New Binding("Image", dsComics, "comiclist.ComicCover")<br />
AddHandler b.Format, AddressOf ConvertPicture<br />
Me.picCover.DataBindings.Add(b)<br />
<br />
<br />
<br />
Public Sub ConvertPicture(ByVal Sender As Object, ByVal e As ConvertEventArgs)<br />
Dim b() As Byte = e.Value<br />
Dim ms As MemoryStream = New MemoryStream<br />
ms.Write(b, 0, b.Length)<br />
Dim bmp As Bitmap = New Bitmap(ms)<br />
ms.Close()<br />
e.Value = bmp<br />
<br />
<br />
End Sub