specify persons who failed to update "date" in gridview c#

Question

Respected Friends,

 

                                I have sno(integer),name(varchar), event(varchar),planned (varchar ) ,conducted (varchar),email(varchar) in ADD_FACUlLTY  table. 

In planned field I am entering the future date that indicates when that event to be done in future and in Expected field when it was actually done will be uploaded.

 

conducted date as shown below.   

                         

SNO	NAME	EVENT	PLANNED	CONDUCTED	EMAIL
1	CHIRANJEEVI	ADD ATTENDANCE	19-JULY-2015	19-JULY-2015	[email protected]
2	VANDANA	ADD MARKS	20  -JULY-2015		[email protected]
3	TANUSHREE	POST ATTENDANCE	20-JULY-2015		[email protected]

 

when people forget to update their CONDUCTED date according to PLANNED date then we prepare forgot list at the end of the same day in gridview in c#

 

      forgot list shown below    for 20-july-2015      

 

SNO	NAME	EVENT	PLANNED	CONDUCTED	EMAIL
2	VANDANA	ADD MARKS	20 -JULY-2015		[email protected]
3	TANUSHREE	POST ATTENDANCE	20-JULY-2015		[email protected]

 

thanks in advance..