Hi,

I checked your Schema dataset and found that some of ID in your tables are autoincrement/identity. When doing an insert operation, you will need to create a new class to handle insert identity operation.

e.g In our WebScheduler sample. Please see dsSchedulerSoftware.axd. All the Id tables are identity. 
We handle insert operation for identity in dsSchedulerSoftware_extended.cs.
If you don't handle the operation, when you insert a new event, it will return incorrect Id until you refresh the view. 

Hope this helps.

Regards,
Handy

Hi Handy,

As discussed in live chat, you said i need to handle the insert operation in dsSchedulerSoftware_extended.cs. But in this case, i'm dealing with delete event, not insert event, so does it gel together? Now when my WebScheduler load the existing record, not the newly inserted record, i still can't delete any event.

Then another thing is, i tried delete dsSchedulerSoftware_extended.cs in WebScheduler sample, and the delete event still works! Means the delete event is not related to the file.

Pls advise!

Thanks!

Hello Way Hang Wee,

As I have explained in our previous chat, the delete issue related with insert operation.
When you delete after insert an event, the ID of event which is identity, returns -1. That's why delete has a wrong operation because inccorect ID. 

I think you haven't tried anything about extended.cs I suggested to. 
dsSchedulerSoftware_extended.cs is used for not sql sample. Even without this .cs, the delete event works. At least in this .cs, It showed you how to select the identity.

Here, I have modified your sample. I created .cs extended class. The delete events should be working fine.

Regards,
Handy 

Hi Handy,

Can u reattach the file? Coz when i tried to extract the zip file i get error it's damaged.

Thanks!

Ok. Here is the attahed file.

Hi Handy,

I replaced:

dsSchedule.Designer.vb

dsSchedule.xsc

dsSchedule.xsd

dsSchedule.xss

dsSchedulerExtended.vb

with urs into my project. But the delete event still doesn't work. Still same as previous.

Attached is the sample after replaced with ur files.

Do i missed out anything?

Hi Way Hang Wee,

I am sorry that I falsely in noticing your WebScheduler. You are using WebScheduler2 while I was using WebScheduler 3.
In WebScheduler2 all operation would be set as 'CompareAllValues' at default while in WebScheduler 3 already can use 'OverwriteChanges'.

Therefore, you will need to configure tables shema in your dataset>>AdvanceOptions>>Check Use optimistic concurrency.

After that you will need to configure delete and update method tables in ISDataSource. 
(note: It is easier if you just delete ISDataSource and add new ISDataSource then configure insert,delete and update method).

I attached the modified sample and it should be working fine on yours.

Regards,
Handy

Hi Handy,

As discussed, hope to get solutions from ur side sonnest possible.

Thanks!

Hi Handy,

Any progress?

Thanks!

Hi Way,

I debugged your project and found what caused your issue. It happened because ActivityName is not bound into WebScheduler.
Everytime WebScheduler delete your existing data, ActivityName value is always 'Nothing' or Null which is incorrect. 

The delete statement condition uses 'And' operator.
 So, it could not delete the data because could not find ActivityName 'nothing' which passed into the condition.

It works when creating a new event (without click your insert button), because ActivityName value is nothing. So, when we delete the event, the condition of ActivityName meet your condition in query and sucessful.

My suggestion, if you have more field/custom field, please also create extended class to handle your new custom field ('ActivityName').
You can read for more information in our documentation 'Walkthrough: Adding custom fields in WebScheduler using Extensibility feature' or open our WebSchedulerSample EventOrganizer.aspx.

Regards,
Handy

Hi Handy,

I follow the walkthrough but encounter some problem. I hit error when run.

Attached is the sample.

Pls advise!

Thanks!

Hi,

Please let me know about the error you got. When I created the extended custom fields, I got something about ' event extended type could not be found...' or something. So, I want to ensure if this is the error you faced or not. I have submitted this to our developer teams and they will fix this issue.

Regards,
Handy

Ya that's the error i got.

Looking forward ur update..