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=2015,now when user login on 12th sep an aleart form show all the record which are having same date.   

Answer 1

Ok Nithin ... carry on...

Answer 2

thanks for your reply

 i have solved it just now .

thanks 

Answer 3

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

 

Answer 4

already try this not working

Answer 5

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.mobile,A.address,A.order from customer A ,followup B Where B.folloDate=CURDATE() "

-------------------------------------------------------------------

If you find anything useful please accept my answer