Regarding Data Binding between RadScheduler and MySQL

Phil

For data binding in winform scheduler, i want to update database when the appointment is added, updated rather than when some update button is clicked.

Currently, the documentations provided is perfectly describing how it work with button, and i love it. Nonetheless, i want to find better, and easy way to update appointment, so we can get rid of using update button.

Is there any event property for radscheduelr that i can use in this condition? or Any other way to do this?

"To reload the data from the database, you should use the Fill method of your table adapters to repopulate your datasets with data. When you do this, RadScheduler should automatically detect the changes and reflect them to the user interface. If this does not happen, then you can force an update by calling RadScheduler's DataBind method."

Let us know if this helps. Feel free to ask any further questions you may have about the RadScheduler or any other RadControls.

Phil

Well, I wrote bit jumbled up post, sorry for that. I use data binding and it perfectly works when loading from database.

What i want to do is that updating database without clicking button when client add appointment or edit appointment or delete it or dragging appointments.

The documentations provides methods that works with button clicking after adding,editing deleting,dragging, or...(many other scheduler features) appointments. If i do not want to update database with button, i probably need to copy the codes for every event handling method, which is counter productive. So i am looking for any event properties in radscheduler that pops up when scheduler's appointment data is changed. Therefore, every time clients change data on scheduler, the program update database automatically without needs of client to click "update button".

Are you trying to update after a user creates / edits / deletes an appointment? There are events triggered after all of these actions are done client side. You can access the RadScheduler's DataBind method inside of the AppointmentAdded and AppointmentDeleted methods. An example of this is shown here:

Phil

Yes, both of them perfectly work when you 'add' and 'delete' appointment, but it does not work when you dragging appointment or editing appointment. And i read all the properties and could not find related properties. Did i miss that property?

George

Since RadScheduler uses ObservableCollection to store its appointments and every appointment implements the INotifyPropertyChanged interface, every time a property in an Appointment changes the CollectionChanged/Changing events are being fired. You can use them to track edits on appointments:

If it is not suitable for your specific case and you have some specific data base structure, could you please provide some additional information about the exact appointments/resources tables's structure and their relation? Thus, we would be able to investigate the precise case and assist you further.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.

Snehith

I tried with your example and trying to understand and implement in my application.
Here i attach my appointment and resource tables and our custom appointment form.
We don't main any extra table for appointmentresource like in telerik, while inserting a record into the appointment table we have a column resource. A single appointment can have multiple resources .

Dess | Tech Support Engineer, Sr.

You can refer to our Setting Appointment and Resource relations help article which is quite useful when you have only two tables for setting up data in scheduler. Please have a look at the attached sample project which demonstrates how to bind RadScheduler to a simpler data structure with two tables only. The back up file for the sample data base is included as well.

I hope this information helps. If you have any additional questions, please let me know.

Regards,
Desislava
Telerik

Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.

Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.