How to report same record id's in row

Question

Dear Code Masters,

 

I believe this mail meet you well and in good condition.

 

Please i have this challange and i will appreciate your solution to resolve it, i have a database called tbl_Leavesheet that contain the follo record as shown below:

 

 

i was asked to write a report that will keep the same record in one row, their startedate and stopdate in different colun while their nodays will accumulate and display in another column of the same row, it should look like the one below:

 

all sample code is strongly appreciated.

 

thank you all 

Answer 1

mahesh start method willbe called once or it will run like looping untill i dont stop sevice

Answer 2

Here is an article that shows you how to build a Windows Service. Instead of writing to a text file, you will write your code to send email here.

Creating a Windows Service in C#

Answer 3

Mahesh can u give any link that provide information about how to build service process

Answer 4

Yes Mahesh is right, you should use other options instead of using a web application. Your problem occurring might due to Application Pool recycling.

Answer 5

If your code is sending emails for 1 hour but not for 4-5 hrs, it seems like a bug in the code. Also, I am not sure if it is a good idea to put your send email code in the Global.asax file. You should either build a service or a job process (separate exe and schedule it as a job) or create a job in SQL Server.

BTW Restarting server does not need you to restart IIS. IIS should automatically restart and so your application and so your Global.asax.