Results 1 to 2 of 2

Thread: I am developing windows application using C# and MS SQL. how do i make pop up?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    208

    Arrow 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

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width