End Date not populationg correctly in Bind Rad Scheduler to a Sharepoint List

[smith spd]

Hello Telerik Team,

I have developed a scheduler which pulls data from sharepoint list.But i could see that the end date
does not show up correctly.Please anyone can guide me .

Thank you
Smith

[T. Tsonev]

Hello,

Can you please share some additional details? Does the End date get populated at all or is it populated with wrong data?

We have a running sample of RadScheduler in SharePoint 2010 site. Here's how the data binding code looks there:

using (var site = new SPSite("http://localhost"))
{
    using (var web = site.OpenWeb())
    {
        var list = web.Lists["SchedulerEvents"];
        RadScheduler1.DataSource = list.Items.GetDataTable();
        RadScheduler1.DataSubjectField = "Title";
        RadScheduler1.DataStartField = "Start";
        RadScheduler1.DataEndField = "End";
        RadScheduler1.DataKeyField = "ID";
        RadScheduler1.DataRecurrenceField = "RecurrenceRule";
        RadScheduler1.DataRecurrenceParentKeyField = "RecurrenceParentID";
        RadScheduler1.DataBind();
    }
}

I hope this helps.

Kind regards,
Tsvetomir Tsonev
the Telerik team

[smith spd]

Hello telerik team,

Thank you for the response.I am able to get the end date but it appears as 1 DAY less than the original end date and how do you validate whether start date is less than end date in the above code.

Thank you
Smith

[T. Tsonev]

Hello,

Can you please show us how the data looks in the SharePoint list?

The validation for start and end date will be done as soon as the data is obtained from the data source. It must be valid at this point.

I hope this helps.

Sincerely yours,
Tsvetomir Tsonev
the Telerik team

[smith spd]

Hello Telerik team,

The code which i am using to bind the scheduler to list is below.
{

 

String stUrl = SPContext.Current.Web.Url.ToString();

spSite =

new SPSite(stUrl);

 

site = spSite.OpenWeb();

 

 

listItems = site.Lists[

"TestList"].Items;

 

site.AllowUnsafeUpdates =

true;

 

 

DataTable DTable = listItems.GetDataTable();

 

RadScheduler1.DataSource = DTable;
}

I wanted to add only those records(list items)  to DTable for which  start date and time is earlier than end date and time.

I appreciate your response.

Thank you
Smith

[T. Tsonev]

Hi,

The best approach would be to let SharePoint do the filtering for us. The preferred option is to use LINQ to SharePoint. The SPQuery class should come handy for older versions of SharePoint.

I hope this helps.

Greetings,
Tsvetomir Tsonev
the Telerik team