TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Afzal Mozan
NA
122
15.4k
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.
Reply
Answers (
0
)
How to pass 2 values id in to the next page using query stri
Display button based on condition false or true in table