Sample1
Import data from an access database file to a catalog.
This examples shows how to read data from an Access database file and use that data to create video entries in fast video cataloger. Access database files have the mdb file extension. The "All my movies" software stores its data in an Access database. This example shows how to read videos from that database and import it into the current catalog.
This sample require the Access database runtime provider to be installed. Make sure to download the 64 bit version of the software that is available here: https://www.microsoft.com/en-us/download/details.aspx?id=13255
This sample first shows a dialog to let you pick the mdb database to read from.
We then open the database file and runs a sql query.
Next we create some new extended properties for the catalog.
For each video in the database we
-Read out data from the catalog, use that data to create a new video entry
-Add extended properties to the newly added video.
Finally we refresh the user interface.