how to store file path in mysql database retrieve it using vb.net

[kumsay]

hello, I have form with a listbox and a windows media player. The lisbox is populated with filename from the database. If the user select one item from listbox a video clip should play on the WMP. In the mysql database, I have a table VideoClips with fields vName(varchar), vLocation(varchar). In vLocation I saved the file path of the picture (D:\VBProject\videos\video.flv).

Call Connect()
        With Me
            STRSQL = "select vLocation from movie where vName = @vName"
            Try
                myCmd.Connection = myConn
                myCmd.CommandText = STRSQL
                myReader = myCmd.ExecuteReader
                myCmd.Parameters.AddWithValue("@vName", lstName.SelectedItem.ToString())
 
                If myReader.Read Then
                    Dim path = myReader.GetString(0)
                    wmp.URL = path
                End If
            Catch ex As Exception
                MsgBox("no file")
            End Try
 
        End With
 

there's no error, the problem is that when I select an item in the list it displays the catch exception message "no file" even if I already have the full path of the video stored in the database (example: D:\VBProject\videos\video.flv). Can anybody help me work it properly? this is quite urgent, I need to finish this today. Please help me, God bless

[kumsay]

I browse and found a forum in the internet that \ should not be used because within MySQL string values the backslash is interpreted as an escape character and suggested to alter the path values to contain the "\" sequence to actually store a backslash. So I stored the file path as D:\\VBProject\\videos\\sample.flv but still failed :(

[Rabbit]

The most likely problem is that you execute your reader before supplying the parameter value.

[VanessaMeacham]

Hi ! i think it will help you

[code]STRSQL = "Select pLocation From Pix where pixName = @pixName"
myCmd.Parameters.AddWithValue("@pixName",lstPix.Se lectedItem.ToString())[/cod]e

[kumsay]

I already got it working, here's my working code:

Call Connect()
        With Me
            STRSQL = "select vLocation from movie where vName = '" & lstName.SelectedItem & "'"
            Try
                myCmd.Connection = myConn
                myCmd.CommandText = STRSQL
                myReader = myCmd.ExecuteReader
 
                If myReader.Read Then
                    Dim path = myReader.GetString(0)
                    wmp.URL = path
 
                End If
            Catch ex As Exception
                MsgBox("no file")
            End Try
          myConn.Close()
        End With
 

I stored the file path with single \ (D:\VBProject\videos\video.flv). Thanks anyway :)