I am creating an event calendar populated by two SQL tables where a Stored Procedure (SP for short) is calling all of the information for the calendar to use. I can get the calendar to populate on the start date of the event but not populate on every day that the event occurs. In my SP I did a DateDiff where I calculated the difference in the start and end date for this event. I am sending the "REF_EVENT_ID, EVENT_NAME, EVENT-START_DATE, AND NUM_DAYS" to a "myCollection" in the VB code behind. I cant seem to figure out how to use the "NUM_DAYS" to make the calendar populate a multi day event starting on the "EVENT_START_DATE" and populating each day after until the NUM_DAYS number has been reached. Here is my VB code Please let me know whats the deal, I have been stuck on this for a week:

The code is attached****

Well, I guess nobody knows how to fix this.......Honestly, does anyone know how to even remotely get this to work?

Patience young Padawan, we have lives (work, family, school, etc) and do not spend every waking moment here awaiting your questions. Sometimes it can take a day or two before someone who can answer your question visits the forum.

Think of "NUM_DAYS" as a counter that is going to count backwards when you hit the start day of the event. As you are generating the calender and adding the events to each day, you will only need a simple If statement to determine if "NUM_DAYS" is greater than zero. If it is then put the event on that calendar day and deduct one from "NUM_DAYS".

You don't necessarily have to use "NUM_DAYS" from your structure, you could simply assign its value to another variable that will be the actual counter.

This way as your calendar is being generated forward the counter will be counting down from the start date and adding the event to the calendar.

Does that help?

Thank you, I realize you have lives. I do to. Sorry for sounding "pressing" on the situation. Im just a little aggravated at this program.

Reguarding what you wrote about "fixing" the problem. That is kind of what I have done....kind of. I'll keep hacking away at it and I will post another response when I get stumped again or get the answer.

Thank you for your response.

ok, found a question....

Do I need to do all of this on the "dayRender" event or do it in another function and call it in DayRender?

Yes, you will need to do it in the DayRender event, as this is what is actually creating each day in the calendar.

Something I forgot to mention is you will need your counter to be a class level variable, this way the value of the counter will be remembered each time the DayRender event is executed for each day of the month.

ok. I'm working on it now. I'll keep you informed.

Thank you very much!