show popup window when database date matches system date

Question

how to show popup window when database date/time matches system date/time for each data inserted in c# windows application

Sam Megane · Answer

DateTime date1 = new DateTime(2009, 8, 1, 0, 0, 0); DateTime date2 = new DateTime(2009, 8, 1, 12, 0, 0); int result = DateTime.Compare(date1, date2); string relationship; if (result relationship = "is earlier than"; else if (result == 0) relationship = "is the same time as"; else relationship = "is later than"; Console.WriteLine("{0} {1} {2}", date1, relationship, date2);   i want to get it from this database clum.. named Date,Return