does anybody have sample code that shows me how to load Album Art of any list into a C# pictureBox ?
I'm having trouble converting the SDBImage to the pictureBox...

In case no code in C# is available, VB will do too...
Kind regards,
Cooled Spirit
Moderator: Gurus
Code: Select all
switch (command)
{
[...]
case "albumartext":
item = item.Split('.')[0];
SDBIter = (SDBDBIterator)SDB.Database.OpenSQL("SELECT * FROM Covers WHERE ID=" + item);
SDBSongIter = (SDBSongIterator)SDB.Database.QuerySongs("Songs.ID = " + SDBIter.get_StringByName("IDSONG"));
String path = SDBSongIter.Item.Path;
path = path.Substring(0, path.LastIndexOf('\\') + 1);
filename = path + SDBIter.get_StringByName("COVERPATH");
MIMEtype = "image/jpeg";
break;
case "albumartemb":
item = item.Split('.')[0];
SDBIter = (SDBDBIterator)SDB.Database.OpenSQL("SELECT * FROM Covers WHERE ID=" + item);
// So from the COVERS pick up the COVERORDER, and hope that this works
SDBSongIter = (SongsDB.SDBSongIterator)SDB.Database.QuerySongs("Songs.ID = " + SDBIter.get_StringByName("IDSONG"));
SongsDB.SDBImage image = SDBSongIter.Item.AlbumArt.get_Item(Convert.ToInt32(SDBIter.get_ValueByName("COVERORDER"))).Image;
// Following switch is unneccesary, just for debug in case something goes wrong
switch (image.ImageFormat)
{
case "image/jpg":
case "image/jpeg":
filename = SDB.TemporaryFolder + "\\" + item + ".jpg";
MIMEtype = "image/jpg";
break;
case "image/png":
filename = SDB.TemporaryFolder + "\\" + item + ".png";
MIMEtype = "image/png";
break;
case "image/gif":
filename = SDB.TemporaryFolder + "\\" + item + ".gif";
MIMEtype = "image/gif";
break;
default:
filename = SDB.TemporaryFolder + "\\" + item + ".jpg";
MIMEtype = "image/jpg";
break;
}
if (image.ImageDataLen>0)
{
filename = SDB.TemporaryFolder + "\\" + item + ".jpg";
// Following code has been taken out from the Wiki
outputfile = FS.CreateTextFile(filename, true);
outputfile.WriteData(image.ImageData, image.ImageDataLen);
outputfile.Close();
temporaryfile = true;
}
[...]