how to iterate through dataset and seperate each row

See more:

C#

ASP.NET

SQL-Server

Hello Experts,

I have a table that has columns as UserID,TaskID,ReminderDate,Task,TaskType,TaskStatus.

Here TaskType is Daily,Weekly,Monthly,Yearly,Today,None.

Now i need to insert a new row in the table as per a condition (when the date in the Reminder Date matches with today's Date).

This should run only once in a day. And the inserted row values should be same(except TaskID, as taskid is set increment by '1') as the before row but the Reminder Date should be changed(as per the TaskType selected).



Please help me to proceed further...