I currently load a static array to play several songs in a row.
On frmload I load the array with song path and then use the array to iterate through the songs.
I now have an Access database that holds the song information including file path. I also have a datagrid that displays all the records in the databse table.
What is the best way to extract the file path form the database and Play all the songs?
Is it possible to load a dynamic arraylist from a database and play all the songs in that list? if so how do I do this?
Example code:
'Load The songs into array
strSongs(1) = Application.StartupPath & "\Rufus Thomas - Walkin the Dog.mp3"
strSongs(2) = Application.StartupPath & "\Blues Legends - Slim Harpo - I'm A King Bee.mp3"
strSongs(3) = Application.StartupPath & "\Jaynettes - Sally Go Round the Roses ((Stereo)).mp3"
intSongPlaying = intSongPlaying + 1
Thank You,
Fullyii
On frmload I load the array with song path and then use the array to iterate through the songs.
I now have an Access database that holds the song information including file path. I also have a datagrid that displays all the records in the databse table.
What is the best way to extract the file path form the database and Play all the songs?
Is it possible to load a dynamic arraylist from a database and play all the songs in that list? if so how do I do this?
Example code:
'Load The songs into array
strSongs(1) = Application.StartupPath & "\Rufus Thomas - Walkin the Dog.mp3"
strSongs(2) = Application.StartupPath & "\Blues Legends - Slim Harpo - I'm A King Bee.mp3"
strSongs(3) = Application.StartupPath & "\Jaynettes - Sally Go Round the Roses ((Stereo)).mp3"
intSongPlaying = intSongPlaying + 1
Thank You,
Fullyii