[Solved] Dataset

[Fred]

Hi

I am trying to use a Dataset that are connected to a Access database as datasource. But how do i get the Insert, Update and Delete command to work.

<

telerik:RadScheduler ID="RadScheduler1" runat="server" Culture="Swedish (Sweden)"

FirstDayOfWeek="Monday" LastDayOfWeek="Sunday" AllowDelete="True" AllowEdit="True" AllowInsert="True" DataEndField="End" DataKeyField="ID" DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentID" DataSourceID="ObjDtaBokn" DataStartField="Start" DataSubjectField="Description" OverflowBehavior="Scroll" SelectedView="ResourceView" GroupBy="Room">

<ResourceTypes>

<telerik:ResourceType KeyField="RoomID" Name="Room" TextField="Name" ForeignKeyField="RoomID"

DataSourceID="ObjDtaRooms" />

</ResourceTypes>

</telerik:RadScheduler>

<asp:ObjectDataSource ID="ObjDtaBokn" runat="server" DeleteMethod="Delete" InsertMethod="Insert"

OldValuesParameterFormatString="original_{0}" SelectMethod="Alla" TypeName="DataSet1TableAdapters.BokningarTableAdapter"

UpdateMethod="Update">

<DeleteParameters>

<asp:Parameter Name="Original_ID" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="ID" Type="Int32" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Start" Type="DateTime" />

<asp:Parameter Name="End" Type="DateTime" />

<asp:Parameter Name="RoomID" Type="Int32" />

<asp:Parameter Name="RecurrenceRule" Type="String" />

<asp:Parameter Name="RecurrenceParentID" Type="Int32" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="ID" Type="Int32" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Start" Type="DateTime" />

<asp:Parameter Name="End" Type="DateTime" />

<asp:Parameter Name="RoomID" Type="Int32" />

<asp:Parameter Name="RecurrenceRule" Type="String" />

<asp:Parameter Name="RecurrenceParentID" Type="Int32" />

</InsertParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="ObjDtaRooms" runat="server" DeleteMethod="Delete"

InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="Alla"

TypeName="DataSet1TableAdapters.RoomsTableAdapter" UpdateMethod="Update">

<DeleteParameters>

<asp:Parameter Name="Original_RoomID" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="RoomID" Type="Int32" />

<asp:Parameter Name="Name" Type="String" />

<asp:Parameter Name="Original_RoomID" Type="Int32" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="RoomID" Type="Int32" />

<asp:Parameter Name="Name" Type="String" />

</InsertParameters>

</asp:ObjectDataSource>

Best regards

Fredrik Michaelsson
ml | Communications in Sweden

[Peter]

Hi Fred,

Please, find attached a small demo project which shows get the Insert, Update and Delete command to work. Let us know if you have any questions.


Greetings,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center