VB Database Questions

Toshiba Satellite l505d-s5965 notebook
October 6, 2010 at 20:08:49
Specs: Windows 7, 1024
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 !


See More: VB Database Questions

Report •


#1
October 9, 2010 at 16:23:14
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.

How To Ask Questions The Smart Way


Report •

#2
October 9, 2010 at 17:38:50
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.


Report •

#3
October 9, 2010 at 18:45:10
Well, that would depend on which database you plan on using, and the layout of the tables, wouldn't it?

How To Ask Questions The Smart Way


Report •

Related Solutions

#4
October 9, 2010 at 18:50:11
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.


Report •

#5
October 10, 2010 at 08:36:50
. . . 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.

How To Ask Questions The Smart Way


Report •


Ask Question