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

Gettting granular Appointment Data to/from the Database

1 Answer 32 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 30 Aug 2010, 09:29 PM
Hi, I'm new to Telerik and am trying to get my bearings.  I hope to get some basic guidelines/best practices with this question.  I have a web app for School Counselors helping Students.  The Counselor logs on, enters a students code and gets all their data.  I'm trying to get the student's schedule to appear as well. Also, I want to checkbox toggle to add/remove the schedule of other users such as the Advisors and Tutors to show availability of times for all entities.
  I've been working with this Demo as a learning tool.
My question is, how is it best to approach getting granular info from the database?  For example.  (using the telerik Appointments table), how does one get just the appointments for a specific user_id, or two user_id's and bind them back to the scheduler?

1) I tried using a SqlDataSource and it seems great for displaying----everything in the database.  Is it inherently simple or is there a way to leverage this control to squeeze what you want from the database and get specific datasets?

2) We use a product called MereMortal.NET as a framework for creating business objects.  I was able to get a bindinglist of the data I wanted and assigned that as the DataSource of the Scheduler and I even managed to save back to the database by hardcoding a few variables in.  But, that's when things start flying apart.  On the demo, if you right mouse click to enter a new appointment, you first get an extremely simple appointment form to fill in and on the bottom right it offers an "Options" selection which brings up a more advanced menu. When I hit the "Options" link, the program dies.  I'm guessing I don't have it wired up right somewhere.  I just don't know how/where to start---the debugger isn't helping me at the moment mainly because I don't know enough I think. If one is going to bind the data to a datasource (like a bindinglist) what is the overhead?  What do you need to know how to do?

3) Am I off base by trying to work with the demo and craft it to my needs? Should I be starting simpler?  If so, my original questions remain.

Any pearls of wisdom?

Thanks.
Best to All,

Don

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 03 Sep 2010, 03:14 PM
Hi Donald,


1. This requirement is best handled with the resource types feature of RadScheduler. You can view the Defining Resources demo. Notice how selecting and unselected the User checkboxes shows or hides the appointment for that user. I imagine you will need something similar for the students scheduler.

2. RadScheduler can be bound to various data sources. I suggest you review the Binding to Generic List demo and also the Getting Started help topic that shows data binding to ObjectDataSource.

Clicking the "Options" shows the default advanced form of RadScheduler. Issues can arise if you decide to customize it using the AdvancedEditTemplate and AdvancedInsertTemplate. Is this case? If so, can you send us the code of your implementation or event better a simple working demo of the issue?

3. As mentioned above, RadScheduler is very flexible when it comes to data biding. I suggest you review the topics from the Data Bindig chapter in the help and decide what data source will fit best your existing data infrastructure. 

A good way to start learning the controls is through the Step-by-step Tutorial – RadControls for ASP.NET AJAX. In addition, you can resort to the online demoskb articles and forums.



Kind regards,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Scheduler
Asked by
Daniel
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or