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?
Best to All,