Ado & Mp3

[hipopony66]

Hey, I'm revamping my MP3 program (that has become quite a fun project for me). The way it loads the files to the listview now is by retreiving the info from text file. I wan't to change this to make it more efficent and get a faster load time when the list has to be refreshed. So, what controls do I need to use to create a database for each folder of mp3 files? In the Database I want to store info and paths of the files and then load them to the listview using ADO. I've done a little research on ADO, but creating the db to start with is the problem right now. If anyone can give me some tips, or point me in the right direction to learn more about this, it would be much appreciated. Do I need to use Visual FoxPro? What's the best way? Thanks in advance.

[mendhak]

You need VB6, and a database. There's no need to delve in to VFP.

Creating the DB is the problem right now? plz be a little more specific, I didn't understand that one...

[hipopony66]

Ok, here's what I want to do. Say a users mp3 files are in "C:\My Music\". I want to loop through all the files in this folder retreiving information such as ID3 info, etc. Then I want to store this info in a db file (create a db file). When my program loads up, I want to use ADO to load the info in the database file into a listview.

So basically, when a user first loads my program, they will specify the path of their mp3s, and click "OK". On cmdok_click (), I want to get the info on the files in the specified path and create a database. Then each time the program is loaded, it will opent the database and add all the info to a Listview, and then close the database. Hope this makes more sense.

[mendhak]

well, you know what? You just answered yourself.

I'll still go over what I'd do if I were in your place.

You don't need to create a database just for each folder. You can have one database, with one table for each folder. You can use SQL statements to create the table for the very first time a new folder is introduced. (This was my suggestion, but you go ahead and do as you please)

So, the user specifies the folder where the MP3s are kept, and your app would loop through all the MP3 files, get their names, add into the table. This would of course be really easy using ADO, and you should NOT use any data controls for this purpose.

Each time the program is run, it can check the previously specified folder, and do one of two things:

1)Check for new or deleted MP3 files, make appropriate changes

2)Just loop through the entire folder, and rewrite the entire table.


You'd have an "Add New" button, which would create a new table for the folder specified.


These are just suggestions, so don't get pissed off if these disagree with what you want to do.

[hipopony66]

Thanks for the suggestions, the question I was meaning to ask was whether to use a table, query, etc. Anyway, can anyone give me any tips on using ADO? Creating the db is what is confusing me right now. Do I need SQL to actually create the database? I understand the part about having a table for each folder, but I'm not sure how to do create the tables. To I need to use the MSFlexgrid control? Any more info is appreciated.

[Steve Stunning]

Create the DB using Access.. If you have it. I recall there is a way in VB to do it also. Been a long time for me since I just jump into access 2000 and create a mdb file.

Hope this helps.

[formulav8]

To create a datbase file in VB is very easy. Just click the Add IN Menu and then click Visual Data Manager. Then just click the File then New menu and choose which type of database you want to use. And go from there.


Jason