C1 Community

Try following configuration, this must work. If it does not work then please attach a sample that replicates the issue. The Id field in your table should be of GUID type.
------------------
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT * FROM [Appointments]"
            InsertCommand="INSERT INTO [Appointments] (Id, Body, ApptEnd, Location, Start, Subject, Properties) VALUES (@Id, @Body,
@ApptEnd, @Location, @Start, @Subject, @Properties)"
            UpdateCommand="UPDATE [Appointments] SET Body=@Body, ApptEnd=@ApptEnd, Location=@Location, Start=@Start, Subject=@Subject,
Properties=@Properties WHERE Id=@Id"
            DeleteCommand="DELETE FROM [Appointments] WHERE Id=@Id"
            SelectCommandType="Text" InsertCommandType="Text" UpdateCommandType="Text" DeleteCommandType="Text">
            <DeleteParameters>
                <asp:Parameter Name="Id" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="Body" Type="String" />
                <asp:Parameter Name="ApptEnd" Type="DateTime" />
                <asp:Parameter Name="Location" Type="String" />
                <asp:Parameter Name="Start" Type="DateTime" />
                <asp:Parameter Name="Subject" Type="String" />
                <asp:Parameter Name="Properties" Type="String" />
                <asp:Parameter Name="Id" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="Id" />
                <asp:Parameter Name="Body" Type="String" />
                <asp:Parameter Name="ApptEnd" Type="DateTime"  />
                <asp:Parameter Name="Location" Type="String" />
                <asp:Parameter Name="Start" Type="DateTime" />
                <asp:Parameter Name="Subject" Type="String"  />
                <asp:Parameter Name="Properties" Type="String"  />
            </InsertParameters> 
        </asp:SqlDataSource>   
       
       
        <C1WebSchedule:C1WebSchedule ID="C1WebSchedule1" runat="server" Height="555px" ViewType="WorkWeekView"
            Width="637px">
            <DataStorage>
                <AppointmentStorage DataSourceID="SqlDataSource1">
                    <Mappings>
                        <SubjectMapping MappingName="Subject" />
                        <LocationMapping MappingName="Location" />
                        <StartMapping MappingName="Start" />
                        <EndMapping MappingName="ApptEnd" />
                        <IdMapping MappingName="Id" />
                        <BodyMapping MappingName="Body" />
                    </Mappings>
                </AppointmentStorage>
            </DataStorage>
        </C1WebSchedule:C1WebSchedule>


Regards,

Patrick

 

All operations done through the data source.

WebSchedule DataStorage bounds to the object that implements System.Web.UI.IDataSource(using DataSourceID). Through IDataSource.GetView  DataStorage  gets DataSourceView, and then it calls Update/Insert/Delete/Select methods of the DataSourceView.