Afzal Mozan

Afzal Mozan

  • NA
  • 122
  • 15.2k

How to select data after date check from sql server usingasp

Feb 25 2016 11:23 AM
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.
<appliNM, varchar(50),>
,<instiNM, varchar(100),>
,<instAdd, varchar(200),>
,<instiTaluka, varchar(50),>
,<instiDist, varchar(50),>
,<instiPIN, int,>
,<mobile, varchar(12),>
,<officeno, varchar(12),>
,<faxno, varchar(50),>
,<email, varchar(50),>
,<appliAdd, varchar(200),>
,<appliaddPIN, varchar(6),>
,<HownBuild, char(1),>
,<HexprEdu, char(1),>
,<NMcourseApp, varchar(100),>
,<classroomDtl, varchar(10),>
,<OthrInfo, varchar(50),>
,<Appdate, datetime,>
,<appmonth, int,>
,<appYear, int,>
,<appCode, varchar(15),>
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.