I am developing windows application using C# and MS SQL. how do i make pop up?
I am developing windows application using C# and ms sql .
i have a table named
create table remindertbl( rid int not null primary key, title varchar(100), description varchar(600), reminderdate datetime);
table is created and i have a form to insert data to this table. now i want to show a pop up message based on the date of my table.
example values on the table.
select * form remindertbl;
101 meeting discussion about software developing 19/10/2012
102 rent pay rent for house 15/10/2012
these are the data in my table.
so now i want to show me a pop up message to remind me these works. the pop up message should appear when the difference between today's date and the date on the table is less than or equal to 3 days. so how i can i do this please help me.. with your ideas i can built my home. thanks
Re: I am developing windows application using C# and MS SQL. how do i make pop up?
When the application starts you can get the records from the database ordered by date. You can Start a Timer with an Interval calculated based on the record date, so it will raise its Tick event at the appropriate time and you can display the reminder. The maximum value for the Interval corresponds to about 24 and a half days. After a reminder you can then get the next date and Start the Timer again.