Question Database Slideshow

[Davey]

Hey all,

Here's the problem: I have to make a vb project for school, with a database.
I have all my images in 1 map, and in my database I have text fields containing links, which refer to the proper images. Now, in this project, I have to make a slideshow (the background of my MdiParent has to change every so often by means of a Timer, going over the images in my database).

I need the code line to get the link from my database, and then telling vb to go to the next image each tick. Also, if u upload a new image as a user, it has to be added to the slideshow.

Is there anyone that can help me, I have no code yet (at least not for the slideshow)

Greeting,
Davey

 

[jmcilhinney]

So you're saying that you don't know how to get some text from a database?

 

[cjard]

create a table in the db having
ID (auto incrementing number), imageLocation

when you app starts, fill the contents of the database table into a dataset (see the dw2 link in my signature, section Creatig a Simple Data App) ORDER BY id

start a timer, and load the pictures, using Image.FromFile

when you reach the last row in the table, call another FILL from the database, but this time using a parameterixed query of all records having ID greater than (the current highest ID in your local table) - see the DW2 link Creating a Form to Search Data for this

If more rows were downloaded, carry on with the show. If no more were downloaded, loop round to the beginning

-

Now you have a slideshow app that can show new photos added while it was running