You're going to want to create a windows service to check your database periodically. The OnStart function and main executing loop of your service will look like this:
protected override void OnStart(string[] args)
{
var worker = new Thread(DoWork);
worker.Name = "MyWorker";
worker.IsBackground = false;
worker.Start();
}
private void checkLoop()
{
while(1)
{
//Run Query to check if any database records exist where registered
//date time > current date time
checkDBAndSendNotification();
//Make service inactive for 10 seconds
Thread.Sleep(10000);
}
}
This article should help you a bit on coding/setting up the windows service:
http://www.codeproject.com/KB/dotnet/simplewindowsservice.aspx
Be sure to download the example code in that article and use it as your starting point.