1. Home
  2. Forum
  3. WinForms
  4. Simple Schedule DataProvider.vb

Simple Schedule DataProvider.vb

Good morning. Does anyone have a version of SimpleScheduleDataProvider.vb compatible with version 21.1.35?

Is there any version where the data is saved in an mssql server database?

If someone could help me I would be grateful.


Ricardo


18 Replies
RA Ricardo Abranches May 30, 2023 04:15 PM UTC

and also, how can i "translate" the words in english to portuguese


thanks


DM Dhanasekar Mohanraj Syncfusion Team May 31, 2023 12:11 PM UTC

Ricardo Abranches,

Please find the response to your queries below,

Query

Response


Does anyone have a version of SimpleScheduleDataProvider.vb compatible with version 21.1.35?

 

Here we have attached the VB sample with the requested file SimpleScheduleDataProvider.VB. Please have a look at this, which is compatible with all versions.


Is there any version where the data is saved in an mssql server database?

 

We are a little unclear about your scenario, could you please share the below things,

Provide more details about your scenario with image illustrations.

Can you please share your exact requirement?     

It will be helpful for us to proceed with this further. 

 

 

How can i "translate" the words in english to portuguese

 

 

We suspect that your requirement to “Translating the application resources into different languages” will be achievable by using Localization.

KB Link: https://support.syncfusion.com/kb/article/6435/how-to-localize-the-default-strings-in-winforms-schedulecontrol

If we misunderstood your requirement, please provide more information regarding your requirement.


Regards,

Dhanasekar M.



Attachment: SchedulerDemo_54b973ec.zip

RA Ricardo Abranches May 31, 2023 01:26 PM UTC

Hello,


What I need is to store the information in a table(s) of a SQL database.

So instead of using a file, I like to be able to store the information in a table.

I already tried to create a class and replace the readings and writings in the file, by readings and writings in a sql database, but I didn't succeed.


can you please help me ?

thanks.

 


RA Ricardo Abranches replied to Dhanasekar Mohanraj June 1, 2023 01:45 PM UTC

Hello

the cample that you send, in vb.net 2020 can nor create an appointment.

it gives an error in controls.cs



best regards

Ricardo


RA Ricardo Abranches June 1, 2023 02:02 PM UTC

Error example


Attachment: erro_50dc9833.zip

DM Dhanasekar Mohanraj Syncfusion Team June 1, 2023 02:44 PM UTC

Ricardo Abranches,


Please find the response to your queries below,

Query 1:

By default, ScheduleControl does not have the support to auto-update the binding object. So, we are unable to update the changes directly into the DataTable or SQL. So, you can manually update the schedule control appointment changes by using the ItemChanged event. By this event, you can get the modified items then they can be updated on your table. Please refer to the below code example, 


Code Example:

this.scheduleControl1.ItemChanged += ScheduleControl1_ItemChanged;

Private Sub ScheduleControl1_ItemChanged(ByVal sender As Object, ByVal e As ScheduleAppointmentEventArgs)

       Dim item As IScheduleAppointment = Nothing

 

       Select Case e.Action

             Case ItemAction.Add,

                     ItemAction.Delete,

                     ItemAction.Edit,

                     ItemAction.ItemDrag

                    item = e.CurrentItem

       End Select

 

       If item Is Nothing Then Return

       Dim startTime As DateTime = item.StartTime

       Dim endTime As DateTime = item.EndTime

 

       'Here you can get the modified item values, And you can update this item in your table.

 

End Sub


Here, we have attached a sample with the above suggestion, please have a look at this.


Query 2:

We have checked the reported issue with the provided details. Unfortunately, we are unable to reproduce the reported issue on our end. Here, we have attached the tested sample and a video demo for your reference. Please have a look at this. Could you please confirm if we missed anything? If you are still facing the reported issue, modify the attached sample based on your scenario and share the video illustration for the reported issue. It will be helpful for us to check on it and provide you with a solution as soon as possible.


Attachment: Sample__Video_b10f602b.zip

RA Ricardo Abranches replied to Dhanasekar Mohanraj June 1, 2023 03:00 PM UTC

here is my example


thanks for your suport

Ricardo


Attachment: agenda_680cb33d.zip

RA Ricardo Abranches replied to Dhanasekar Mohanraj June 1, 2023 03:44 PM UTC

i saw the video that you send, and try to do the same thing with tne sample that was attached to the video.

it dosen´t work.

i'm upgrading know to the last version


RA Ricardo Abranches June 1, 2023 04:31 PM UTC

  1. error with tha last sample that you send 
     

RA Ricardo Abranches June 1, 2023 06:59 PM UTC

Good afternoon, I think I figured out how to reproduce the problem.


In the calendar, do not fill in random data


Then insert 1 event, and save to file

Then they run it again and the event appears on the correct date.

Insert a second event and save the file,

From now on the control stops working.

in the control.cs file it will give an error object is nothing


in the C# version it seems to be working correctly


DM Dhanasekar Mohanraj Syncfusion Team June 2, 2023 01:41 PM UTC

Ricardo,

We have analyzed the reported issue with the provided details. We regret to let you know that we are unable to run the provided sample properly it is shown below,



With this, we can’t able to add the appointments. Also, the reported issue does not reproduce in this sample. If you still facing the reported issue, please share the below things,

  1. Provide the issue reproducible sample

  2. Provide replication procedure with video illustration of the reported issue

  3. In your update, you mentioned that “in the C# version it seems to be working correctly” We suspect that the C# to VB conversion may cause the reported scenario. Could you please confirm that did you use the VB application directly or using the converted application (Created in C# and converted into VB)

  4. Describe the details of the exception and its stacktrace that takes place when the stated issue occurs.

  5. Please check the exception details in Output messages if stacktrace of the exception is not available or thrown as a popup.

It will be helpful for us to check the cause of the issue and to provide a solution at the earliest. 


RA Ricardo Abranches June 2, 2023 01:50 PM UTC

hello

1) and 2) i send the source code with a video showing the error (  just give a couple of minutes)


3)  i was using the vb.net version that you send me in  Sample__Video_b10f602b.zip


4)  the error is in controls.cs




RA Ricardo Abranches June 2, 2023 02:57 PM UTC

Hello

the vb code and the video



Attachment: VB_262234c8.zip

DM Dhanasekar Mohanraj Syncfusion Team June 5, 2023 02:39 PM UTC

Ricardo,

We have checked the reported issue with the provided details. But, the video provided only shows a green window, and we couldn't gather any relevant information regarding the reported issue.

Additionally, we tried to reproduce the issue using the provided sample, but we couldn't observe the problem you mentioned. But, the added appointment was not saved upon closing the application, even when selecting "Yes" in the popup. We suspect that the issue might be related to the usage of different filenames.

To assist you further, we have prepared a simplified sample application that includes the ScheduleControl and conducted a test to demonstrate its proper functionality. We have also recorded a video demonstration for your reference.

Could you please review the sample and video, and confirm if we missed any important details? If you are still experiencing the reported issue, kindly modify the attached sample to reflect the problem and provide a video illustration that clearly showcases the issue. This will enable us to investigate the matter more effectively and provide you with a solution as soon as possible.


Attachment: Sample__VideoDemo_e148cc32.zip

RA Ricardo Abranches June 6, 2023 08:27 AM UTC

hello  Dhanasekar 


this new sample works just fine. :-)


thanks for all you help.


best regards


RA Ricardo Abranches June 6, 2023 08:55 AM UTC

Sorry, just one more little detail.

In Portugal, working hours are from 09:00 to 18:00.

On schedual it is from 08:00 to 17:00


how do i change it to 09:00 to 18:00


I promise not to bother with this anymore  :-)


Ricardo


DM Dhanasekar Mohanraj Syncfusion Team June 7, 2023 01:57 PM UTC

Ricardo,

Your requirement to “Change the timings in the day view from 08 – 17 to 09 -18” will be achievable by changing the ScheduleControl.Appearance.PrimeTimeStart as shown below,

Me.scheduleControl1.Appearance.PrimeTimeStart = 9


Here, we have modified the attached sample based on the above suggestion, please have a look at this.

If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.


Attachment: VB_8da6541a.zip

RA Ricardo Abranches June 7, 2023 04:24 PM UTC

Thanks for your help

i thinck you can consider this case as closed.


Loader.
Up arrow icon