Hi All,
We have a datatable that is bound to a calendarinfo instance with a dayview control on the form. When we add, modify or delete an Appointment we launch AppointmentsTableAdapter.Update, but other network users do not see the changes. I tried to use the DataBindingsForAppointments.RefreshData method, but I do not see the changes. The only method that we can see changes is to repeat every 5 minutes AppointmentsTableAdapter.Fill, but if there are many records this method takes a long time and lowers the performance.
How can I resolve this?
Regards, Lello
Questions:
1) In the Infragistics documentation is written that the method "RefreshData" synchronizes data between data source and component. I read wrong?
2) Instead to reload entire database (AppointmentsTableAdapter.Fill), there is a method to reload only Appointments included in SelectedDateRanges?
1) Yes, that is correct. The RefreshData method is useulf in situations where the underlying DataSet has changed outside of the WinSchedule binding, and you want to synchronize with those changes. The "data source" referenced here, however, is typically a DataSet, not a database.
2) As mentioned in the quote (by David Hanson) that you referenced, you have to handle these things yourself. If you need to get the appointments within a certain range and you want to include recurrences, the query you use to get the appointments within the SelectedDateRanges will have to be modified to include recurrences. You might want to add a boolean column to the table that earmarks the appointments that are recurrences so that you can differentiate between them and regular appointments, and include records that have that field set to true in your query.
Brian Fallon said: 2) As mentioned in the quote (by David Hanson) that you referenced, you have to handle these things yourself. If you need to get the appointments within a certain range and you want to include recurrences, the query you use to get the appointments within the SelectedDateRanges will have to be modified to include recurrences. You might want to add a boolean column to the table that earmarks the appointments that are recurrences so that you can differentiate between them and regular appointments, and include records that have that field set to true in your query.
Thanks for your reply but this is very complicated for an inexpert programmer. I suggest to Infragistics to add a method that allow UltraCalenrarInfo to reload from a database only the records changed.
jurisquick said: I suggest to Infragistics to add a method that allow UltraCalenrarInfo to reload from a database only the records changed. Regards, Lello
I suggest to Infragistics to add a method that allow UltraCalenrarInfo to reload from a database only the records changed.
You can't be serious Lello! It would be near impossible for Infragistics to produce such functionality... it is completely out of scope and responsibility for the Infragistics to do so. there are many WELL DOCUMENTED processes to handle the problems associated with multi-user network environments and disconnected data objects.
jurisquick said:this is very complicated for an inexpert programmer
I suggest you do some training and read some books about ADO.NET. Perhaps if you gained some insight into the methods available you will realise why it is not reasonable to expect Infragistics to implement such functionality.
aaronglover said:You can't be serious Lello! It would be near impossible for Infragistics to produce such functionality... it is completely out of scope and responsibility for the Infragistics to do so. there are many WELL DOCUMENTED processes to handle the problems associated with multi-user network environments and disconnected data objects.
The UltraCalendarInfo class is very special because centralizes all the date specific state information into a single component that can be referenced from all the UltraSchedule controls. The UltracalendarInfo class manages also the frequency of recurrences. For this reason it is not easy to manage the problems associated with multi-user network environments and disconnected data objects. If there are many records the method AppointmentsTableAdapter.Fill() reduces the performance. For this reason I would like to reload "from the database" only Appointments included in SelectedDateRanges but my problem is to handle the recurrences with a start date recurring series outside selected date range. No book on ADO.NET explains how to do this because UltraCalendarInfo is a special class created by Infragistics. Only Infragistics can solve the problem of propagating quickly appointments changes in a network environment.
Sorry for my English, but I use Google translator :-)