Ive created a database programs that conists of 3 fields, NUM, Notes, and Date the NUM is the primary key that incraments by 1 each time a new Note is typed in.
What im now having issues with and cant figure out is but maybe not understanding is i want to be able to have a popup box and alert the user about any notes that fall on the date that was on the database/Choosen with a Msgbox saying the date and notes that was typed in.
using VB express 2010. ive thought about using datareader but still unsure how to do this task. any ideas or help would be great Thank you !
It shouldn't be that difficult. Just get the note that fires next, set a timer, and watch for system time change messages. Once the timer hits 0, display your note, and optionally invalidate/remove the old message from the database. Once the note is displayed, or you discover the system time has changed, get the note that fires next and repeat until your application closes.
right i understand that but my issue really is the fact im not sure how to get the Data out of the database from each colume ect. that is really where im lost at. thank you for your help tho.
Well, that would depend on which database you plan on using, and the layout of the tables, wouldn't it?
yes, the database code is really all done with the Wizard i used. Its Sql database database type. the code is generated but can be changed if need be. the controls are using a bindingSource with a datatable etc.
. . . I'm starting to suspect you haven't set up the database yet. Actually, why are you using a database? Time triggered reminders can't be that big. You could probably use a CSV or XML file just as easily, and without the overhead of a database.
Ad Choices