Hello Everyone,
I’m calculating the time difference as
|
Time1: 2017-09-26 15:00:00.000
|
Time Difference
30 Mins
|
|
Time2: 2017-09-26 15:30:00.000
|
SELECT DATEDIFF(MINUTE, [MeetingStartTime] , [MeetingEndTime]) AS MinuteDiff FROM MeetingSchedule.dbo.Meetings where MeetingStartTime=Datetime.Now
My issue is after 1 min when I refresh the page the DetailsView display empty rows. I want to show the detailsview for 30mins based on the duration of mins which I’m getting from the Database. Can you please suggest me solution.
Suppose the current date time is 2017-09-27 12:00:00.000 and when I fetch the records at the same time details view bind successfully. When i refresh the page at 2017-09-27 12:01:00.000 the details view have no records for the current time. So i want to keep the details view data for the duration of meeting like 30mins or 1 hour depend on the meeting duration on the page if the page is refresh also.
Thanks
