|
-
Oct 8th, 2012, 06:04 AM
#1
Thread Starter
Addicted Member
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
-
Oct 8th, 2012, 07:16 AM
#2
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|