ASPX Code
<
body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
AllowAutomaticUpdates="True" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True"
AutoGenerateEditColumn="True" DataSourceID="ObjectDataSource_MenuCategories"
GridLines="None">
<GroupPanel ID="GroupPanel" Style="width: 100%;">
</GroupPanel>
<ExportSettings>
<Pdf FontType="Subset" PaperSize="Letter" />
<Excel Format="Html" />
</ExportSettings>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<MasterTableView CommandItemDisplay="TopAndBottom" CurrentResetPageIndexAction="SetPageIndexToFirst"
DataKeyNames="CategoryId" DataSourceID="ObjectDataSource_MenuCategories" Dir="LTR"
Frame="Border" TableLayout="Auto">
<EditFormSettings>
<EditColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType">
</EditColumn>
</EditFormSettings>
<Columns>
<telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="Name" FilterListOptions="VaryByDataType"
ForceExtractValue="None" HeaderText="Name" SortExpression="Name" UniqueName="Name">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="SubHeading"
FilterListOptions="VaryByDataType" ForceExtractValue="None" HeaderText="SubHeading"
SortExpression="SubHeading" UniqueName="SubHeading">
</telerik:GridBoundColumn>
</Columns>
<ExpandCollapseColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType"
Resizable="False">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<DetailTables>
<telerik:GridTableView runat="server" CommandItemDisplay="Top" CurrentResetPageIndexAction="SetPageIndexToFirst"
DataKeyNames="ItemId" DataSourceID="ObjectDataSource_MenuItems" Dir="LTR" Frame="Border"
TableLayout="Auto">
<EditFormSettings>
<EditColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType">
</EditColumn>
</EditFormSettings>
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="CategoryId" MasterKeyField="CategoryId" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="Name" FilterListOptions="VaryByDataType"
ForceExtractValue="None" HeaderText="Item" SortExpression="Item" UniqueName="Name">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="Price" FilterListOptions="VaryByDataType"
ForceExtractValue="None" HeaderText="Price" SortExpression="Price" UniqueName="Price">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn CurrentFilterFunction="NoFilter" DataField="SubHeading"
FilterListOptions="VaryByDataType" ForceExtractValue="None" HeaderText="Description"
SortExpression="Description" UniqueName="SubHeading">
</telerik:GridBoundColumn>
</Columns>
<ExpandCollapseColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType"
Resizable="False" Visible="False">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<RowIndicatorColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType"
Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
</telerik:GridTableView>
</DetailTables>
<RowIndicatorColumn CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType"
Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
</MasterTableView>
</telerik:RadGrid><br />
<asp:ObjectDataSource ID="ObjectDataSource_MenuCategories" runat="server" DeleteMethod="DeleteMenuCategory"
InsertMethod="InsertMenuCategory"
SelectMethod="GetAllMenuCategories" TypeName="LuckyOyster.MenuCategory" UpdateMethod="UpdateMenuCategory" >
<DeleteParameters>
<asp:Parameter Name="CategoryId" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CategoryId" Type="Int32" />
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="SubHeading" Type="String" />
<asp:Parameter Name="Disabled" Type="Boolean" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CategoryId" Type="Int32" />
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="SubHeading" Type="String" />
<asp:Parameter Name="Disabled" Type="Boolean" />
</InsertParameters>
</asp:ObjectDataSource>
</div>
<asp:ObjectDataSource ID="ObjectDataSource_MenuItems" runat="server" DeleteMethod="DeleteMenuItem"
InsertMethod="InsertMenuItem" SelectMethod="GetAllMenuItemsByCategoryID"
TypeName="LuckyOyster.MenuItem" UpdateMethod="UpdateMenuItem">
<DeleteParameters>
<asp:Parameter Name="ItemID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ItemID" Type="Int32" />
<asp:Parameter Name="CategoryId" Type="Int32" />
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="SubHeading" Type="String" />
<asp:Parameter Name="Price" Type="Decimal" />
<asp:Parameter Name="Disabled" Type="Boolean" />
</UpdateParameters>
<SelectParameters>
<asp:Parameter Name="CategoryId" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="ItemID" Type="Int32" />
<asp:Parameter Name="CategoryId" Type="Int32" />
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="SubHeading" Type="String" />
<asp:Parameter Name="Price" Type="Decimal" />
<asp:Parameter Name="Disabled" Type="Boolean" />
</InsertParameters>
</asp:ObjectDataSource>
</form>
</
body>