Click here to Skip to main content
15,892,537 members
Please Sign up or sign in to vote.
1.44/5 (2 votes)
See more:
I want to make a reminder application which remind my message on the set time. when the set time approach the system time my reminder message display with alarm tune. may it complete with SQL server 2012 database
please give me any idea how can i do this.

Thanks in Advance.

What I have tried:

I have no code and no idea how can i do this
Posted
Updated 26-Apr-18 23:34pm

The first thing you have to do is realise that your reminders won't display unless your app is running: so you need to decide if your app should be running all the time, or kicked off at regular intervals by the operation system to check and display if it needs to. The two approaches are very different, and need preety different code.

Other than that, it's pretty simple: store a list of reminders in your database (so they persist once the computer is switched off) and read them back when your app starts.
If your app is running occasionally, get the time, check your list, display any "ready to go" reminders and remove them from the DB.
If you app runs all the time, set up a Timer, and handle it's Tick event. In the Tick handler, do the same as you did for an "occasional" app.

So start by writing code to access your DB, compare lists, and then display messages.
Then expand from that in one direction or the other.
 
Share this answer
 
Comments
Fahid Zahoor 27-Apr-18 5:16am    
i want when my app is start then set a condition on tic event of clock .my reminder message is display .My reminder message is come from database as i saved my message at the time of set reminder. and i also want to add a button when i click on button the reminder message is removed from sql DB.
please you send me code how i save my reminder message and datetime in database
OriginalGriff 27-Apr-18 5:32am    
Quote:please you send me codeNo - we are not a "code to order" service.

We are more than willing to help people, but we are not here to do your work for you - give it a try, and see how far you get. If you get stuck on a specific point, then ask - but "send me code" makes you no friends at all...
Maciej Los 27-Apr-18 5:25am    
5ed!
Fahid Zahoor 27-Apr-18 5:27am    
what is the meaning of 5ed!
You need a scheduler. This can be done with Quartz.Net, located here:

1. Quartz Enterprise Scheduler .NET | Quartz.NET Documentation[^]
2. GitHub - quartznet/quartznet: Quartz Enterprise Scheduler .NET[^]
 
Share this answer
 
Comments
BillWoodruff 28-Apr-18 1:20am    
Voted #5 to counteract a #1 vote: this is a reasonable (C#, free, open source) solution for the OP who has "no code and no idea how can i do this."

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900