Access a file from a link stored in the database in visual basic application

04-26-2012, 08:01 AM

user23

Newcomer

Join Date: Apr 2012

Posts: 1

Access a file from a link stored in the database in visual basic application

I am making a media player application using Visual Basic. Until now I have made a listbox in my application which shows the media library. I am using MS Access database for library.

Now my listbox is showing all the songs from the database field but i cant play the song from it. Can anyone give a method so that following objectives are completed -:

1) Database has all the "links" to the files in the user hard drive.
2) The user should be able play the song from the listbox by double clicking the songname in the listbox.

Now i want user to be able to open the mp3 file from the mediaplayer plugin

04-26-2012, 09:22 AM

Gruff

Bald Mountain Survivor

Super Moderator
* Expert *

Join Date: Aug 2003

Location: Oregon, USA

Posts: 5,882

I am somewhat out of my depth here as I have had zero interest in playing media from my apps, However...

If you double click one of your mp3 files manually does the correct player load?

If so then you could use the Shell() command or the API Execute command to launch your program with the selected file path and name.
Note: Any path or filename that contains a space must be bracketed by the double quote character.

Shell Execute Example:

Code:

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
    (ByVal hwnd As Long, _
    ByVal lpOperation As String, _
    ByVal lpFile As String, _
    ByVal lpParameters As String, _
    ByVal lpDirectory As String, _
    ByVal nShowCmd As Long) As Long

Const SW_SHOWNORMAL = 1

Private Sub Button1_Click()
    Dim sFile as string
    sFile = "C:\Documents and Settings\My Documents\My Music\Cool Tunes.mpg"
    sFile = Chr(34) & sFile & Chr(34)
    ShellExecute Me.hwnd, vbNullString, sFile, vbNullString, "C:\", SW_SHOWNORMAL
End Sub

If your "Addin" is for your IE browser you might look into the WebBrowser Control.

__________________
Burn the land and boil the sea
You can't take the sky from me

~T

Last edited by Gruff; 04-26-2012 at 09:48 AM.