Hi,

I am new on this but I am trying to do the following:

I have a movie player that I can use to record some coordinates from some selected points (mouse click) for each frame.

I want to store this points (they are different for each movie) so every time I open a movie I need to select points. Till know this is done but I want to put this data in a database.


For this I need to create a database at run time something like this:

Frame Number (column1)
Time (column2)
Point1 (column3)
Point2 (column4)
Point3 (column4)
and so one.

I need a primary key, but I want the Frame Number in column 1 to do this.

Every time I open a movie I want to remove the database created early and create a new one with different number and name of points.

I am newbie on databases so I hope that some one can help me on this.

thanks
Redcat

Unless you really need to use a database, this would probably work better using an XML file. Creating databases on the fly isn't going to be the most efficient way of doing this. Alternatively, you could use a single database and key the data off of the movie file as well so you don't need multiple databases for multiple movies.

-Peter

You can add movie name too to the database, every time you open the movie delete the records from the database.

For database programming and code samples the best place to start with is http://www.dotnetjunkies.com/quickst...ataaccess.aspx

Mujahid Khaleel
Web designing, development, E-commerce applications.