hello dear programmes,
i developing an website in asp.net and it is institutional website,it gives the approval of courses to another institute, i have an table "app_branches" in sql server database and data can stored through one page in this table.the table has following fields.

,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
i was stored the data in table and selected this data in a gridview, but i want to track the data(approval) on another page based on the field(s) appmonth and appYear compared with last day of month and month and year of next year.(for eg: current year 31/1/2015 and next year 31/1/2016. ) if the next year date is equal to the current year(but year is increased) then select data in gridview and display a message in gridview column as approval is needed to be renew and send a mail on button click from gridview base on their id.
so how to do this type of job ?
please anybody can help me.
thanks for replay.
sorry for bad english.