locked
Store MP3 File in MySQL Database RRS feed

  • Question

  • Anyone can help me how to store Mp3 Files in Database and display it into a listbox? So that I can load the files and display it into a listbox if I start my MP3 Player. Thanks...
    Sunday, March 8, 2009 5:57 AM

Answers

  • As Khanna suggested, it not a good way to store the mp3 files in the database.

    You can use the following namespace to make your application talk to MySQL database.

    Imports MySql.Data.MySqlClient  


    For how to, please visit the link below

    http://forums.mysql.com/read.php?38,10757,14565
    http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-6

    Thanks, A.m.a.L
    Sunday, March 8, 2009 8:55 AM

All replies

  • Do you want to store MP3 file content into the database or just the path of the file? Storing MP3 file content in database may not be advisable. But if you want to store it then you can use "BLOB" in your mysql database

    http://dev.mysql.com/doc/refman/5.0/en/blob.html

    Instead you can store the path of the MP3 file in database and show the names of files in listbox (using Path.GetFileName("Path")). And on selection in the listbox, load the mp3 and play it.

    Gaurav Khanna
    Sunday, March 8, 2009 7:55 AM
  • As Khanna suggested, it not a good way to store the mp3 files in the database.

    You can use the following namespace to make your application talk to MySQL database.

    Imports MySql.Data.MySqlClient  


    For how to, please visit the link below

    http://forums.mysql.com/read.php?38,10757,14565
    http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-6

    Thanks, A.m.a.L
    Sunday, March 8, 2009 8:55 AM
  • Can you give me a sample for a simple storing of file like jpg or mp3 files in MySQL?

    Tuesday, March 10, 2009 5:43 PM