Page load issue in .NET web application
I have developed timesheet management system in ASP .NET & MS-SQL for around 500 employees. But having very big issue with speed, few pages and grid-views loads very slow. I have tried everything from update panel to fetching data with all conditions from database itself to reduce page load time. In few pages, there are 2 sub-gridviews. Please help me fix this issue.
Dharmraj ThakurPosted Jan 31, 2018, 4:11 AM
By default it will show last month or current month data, if sometimes you user want to see previous month of data he will filter out.
Remember featch only records of dates not all employees attendence data for each row... onclick date popup another form with that particular data of date.
Shrikesh KalePosted Feb 25, 2018, 9:57 AM
Chaitra V ShettyPosted Jan 31, 2018, 5:20 AM
Dharmraj ThakurPosted Jan 31, 2018, 5:14 AM
Its a pagination you need to implement...
Chaitra V ShettyPosted Jan 31, 2018, 5:10 AM
Dharmraj ThakurPosted Jan 31, 2018, 4:42 AM
Chaitra V ShettyPosted Jan 31, 2018, 4:28 AM
Chaitra V ShettyPosted Jan 31, 2018, 4:02 AM
Dharmraj ThakurPosted Jan 31, 2018, 3:51 AM
Chaitra V ShettyPosted Jan 31, 2018, 2:58 AM
FROM MorningReport T
INNER JOIN Admin_Users A ON A.Id=T.UserId
INNER JOIN JobTitle J ON J.Id=A.JobTitle
INNER JOIN Project P ON P.Id=T.ProjectId
INNER JOIN CostCode CC ON CC.ProjectCode=P.Id
INNER JOIN Team TM ON TM.CostCodeId=CC.Id
WHERE T.Isdeleted=0 AND TM.Isdeleted=0 AND TM.Supervisor=@Id
GROUP BY T.Date
ORDER BY T.Date DESC
SELECT COUNT(distinct T.Id) as 'TJobCount',convert(varchar,convert(date, Date, 103), 106) as 'TDate',T.Date,P.Project_Code,P.Project_Name,P.Id as 'PId',CONVERT(VARCHAR(19),MAX(T.PostedDate)) as 'PostedDate',
CASE convert(varchar(5),(DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)/24)
WHEN 0 THEN convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)+'h:'+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))%3600/60)+'m'
ELSE convert(varchar(5),(DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)/24)+'d ('+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)+'h:'+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))%3600/60)+'m)'
END as 'Delay'
FROM MorningReport T
INNER JOIN Admin_Users A ON A.Id=T.UserId
INNER JOIN JobTitle J ON J.Id=A.JobTitle
INNER JOIN Project P ON P.Id=T.ProjectId
WHERE T.Isdeleted=0
GROUP BY T.Date,P.Project_Code,P.Project_Name,P.Id
ORDER BY T.Date DESC
Dharmraj ThakurPosted Jan 31, 2018, 12:52 AM