This is a migrated thread and some comments may be shown as answers.

Binding to LinQ datasource - resulting in some appointments not showing

3 Answers 143 Views

Scheduler

This is a migrated thread and some comments may be shown as answers.

mSchmidt asked on 12 Aug 2008, 01:05 PM

Hi

Iam trying to bind a RadScheduler to a Linq datasource, i got everything working but all appointments after a specific date simply dont show up.

I tried debugging and the var q below here includes information about these appointment, however they show up in none of the RadSchedluer Views.

            protected void RadScheduler1_DataBinding(object sender, EventArgs e)  
        
                    {  
        
                        FlexyNet.Data.FlexyBookLocalDataContext db = new FlexyNet.Data.FlexyBookLocalDataContext(Connections.CurrentCenterConnectionString);  
        
                        var q = from v in db.vagtPlans  
        
                                orderby v.start  
        
                                where v.start < v.slut && v.personale_db.personale_custID == fUser.CustID && v.start >= RadScheduler1.VisibleRangeStart && v.slut <= RadScheduler1.VisibleRangeEnd  
        
                                select new { v.vagt_id, v.start, v.slut, kommentar = v.kommentar };  
        
                        this.Label1.Text = q.ToString();  
        
                        this.RadScheduler1.DataKeyField = "vagt_id";  
        
                        this.RadScheduler1.DataEndField = "slut";  
        
                        this.RadScheduler1.DataStartField = "start";  
        
                        this.RadScheduler1.DataSubjectField = "kommentar";  
        
                        this.RadScheduler1.DataSource= q;  
        
                        this.RadScheduler1.Rebind();  
        
                    }

Does the RadScheduler it self only select the appointments within the visible range or do i have to do it as above to optimize speed ?

3 Answers, 1 is accepted

answered on 14 Aug 2008, 01:12 PM

Hello mSchmidt,

Thank you for contacting Telerik support.

RadScheduler shows only Appointments from the Data Source which are in the current Visible Range. On the other hand, the Data Source returns those Appointments which it is configured to select. So, to optimize the behavior, you could select only the Appointments in the Visible Range from the Data Base.

Finally, in your case, it would be better if you move the code from the DataBinding event handler to somewhere else, i.e. in Page_Load in NavigationComplete as the DataBinding event fires when the Scheduler is bound.

Greetings,
Simon
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.