The stored procedure p_WebSchedulerResources_ins properly inserts new resources row to the database and returns new ResourceID (@@IDENTITY) and this identity value is returned from the Insert method of ResourceAdapter. There is nothing wrong with the resource related functionaly.
Later, ther is a problem with EventsAdapter - Update method as this method automatically takes old ResourceID (not the updated one). So the new record is not updated.
I need to refresh page manually and the it stars working properly.
So I believe only the problem here is the new resourceID is not properly sent between ResourcesAdapter and EventsAdapter.

Thanks,
Jakub

Ok, this is solved. The problem was related to the return value of the custom Insert metod in the EventsTableAdapter.

return (int)command.ExecuteScalar()

needs to be changed to

return Convert.ToInt32(command.ExecuteScalar())

Hi Bernard,

I've got another related problem. Say we might have dozens thousands users. Is there any way to forbid/disallow user to select resource manually?
I'd need to add a record to resources table automatically on first user's hit. My idea is to extend Resources table to contain UserID. This approach would allow me to pair user events with users the events belong to.
Every user should see only his/her event and no user should have an opportunity to select resource manually.
So I'd like to hide resources view (possible to do by setting DisplayResourcesTable to false) and also I'd like to disable / hide the resourceid dropdown in "create new event" flyout. I'd like to fill the resourceID programatically based on the retrieved UserID - getting resourceID programatically based on UserID via stored procedure and then filtering events programatically by the retrieved resourceID.
Thus users would automatically see ONLY events that were entered under their own UserID.
Is this possible to do or are there any suitable alternatives?

Thank you,
Jakub