Hi the Forum,
I am working on a C# webform web site.
Does someone knows if it is possible to use an existing table with dates ?
Especialy for insert and update action.
Because my data base is already existing but the fields name are not the same than the mandatory table fields.
I think the Data Collection should be used to load the events.
But, as my ID is GUID type and not int, how to update the dates ?
Thank you.
Hi,
Does someone knows if it is possible to use an existing table with dates ?
Because my data base is already existing but the fields name are not the same than the mandatory table fields.
You can select events into some intermediate class with all required properties, e.g.
[code]var events = from dataRow in dataTable.AsEnumerable() select
new { id = dataRow[“uid”], text = dataRow[“Descriptions”], … };
context.Response.Write( new SchedulerAjaxData(events) );[/code]
Or you may use custom function to render items as described here
scheduler-net.com/docs/loading_d … r_function
as for updating events, DataAction expects ‘id’ to be an integer, but you may render response manually. format is pretty simple:
return string.Format("<data><action type=\"{0}\" sid=\"{1}\" tid=\"{2}\"></action></data>", type, sourceId, targetId);
Where
type - “inserted”,“updated”,“deleted” or “error”
sourceId, targetId - id of the event, they will differ only if event was inserted. In this case sourceId will be a temporary id recieved from the client,
and the targetId - actual id of the inserted event.
All fields of the event can be accessed from request Post collection