how to set alert based on sql column

Question

i have a simple application in windows form and c# . user set some follow up date in system those date are store in sql database column datatyle is datetime. now in fature user lofin the application he/she will see a aleart form on based on those flooow up date now i explain with example today user set a follow up date as 12-Sep=2015now when user login on 12th sep an aleart form show all the record which are having same date.

Prem Anandh Natchatran · Answer

Ok Nithin ... carry on...

Nitin Sharma · Answer

thanks for your reply i have solved it just now . thanks

Prem Anandh Natchatran · Answer

I tried the same in my project ... It is working Check the data type of date field .Write the show alert code in the form_load function post your code for further steps... ------------------------------------------------------------------- If you find anything useful please accept my answer

Nitin Sharma · Answer

already try this not working

Prem Anandh Natchatran · Answer

Hi Nithin Use two tables 1. contain followupdate 2. customer information update the followupdate by some form on form load of your resultant from use this query and update your fields or Datagrid. Select A.name A.mobileA.addressA.order from customer A followup B Where B.folloDate=CURDATE()  ------------------------------------------------------------------- If you find anything useful please accept my answer