Database load?

Dec 16, 2009 at 10:36 PM

Really cool control - very intuitive and powerful.  I was going to try to load some information from a database for a personal time tracker stuff - what do you think the easiest way to do this would be? 

Would you just update LoadEventDocument() to fill m_events with created objects from a SQL call instead of the XML doc?

Thanks from all of us to you for making an effort for the community!

 

Coordinator
Dec 16, 2009 at 11:45 PM

Getting data from sql is not supported directly now. You can though create xml from sql and then call ClearEvents and ResetEvents.

 

Dec 17, 2009 at 12:25 AM

ResetEvents() just builds a collection of TimeLineEvent objects, yeah?  Seems like that could build from anything, XML, sql using the same table structure or whatever.  Am I oversimplifying the problem?  Are there javascript operations on that XML file or something?

 

 

Coordinator
Dec 17, 2009 at 12:30 AM

Yes, ResetEvents builds and displays collection of events, and it accepts xml only (but you can, again, create this xml from whatever you want).

> Are there javascript operations on that XML file or something?

No, ResetEvents just gets events from xml and displays them.

Dec 22, 2009 at 2:13 PM
Edited Dec 23, 2009 at 3:07 AM

Hi

Just want to share some information about loading from a database.

I have a WCF-service delivering data to me...
So this is the return of the wcf-data-call:

void con_GetTimeLineCompleted(object sender, sqlMon.GetTimeLineCompletedEventArgs e)
{
  sqlMon.
sqlMessage[] res = e.Result;

  XElement _events = new XElement("data",
   from x in res
   orderby x.Run_Date 
   select new XElement("event",
       new XAttribute("title", x.Job_Name),
       new XAttribute("start", x.Run_Time),
       new XAttribute("end", x.End_Time),
       new XAttribute("isDuration", true),
       new XAttribute("color", x.Job_StatusColor),
           x.Run_Description);

   timeline.ResetEvents(XDocument.Parse(_events.ToString()));
}

/SebulbaSe