[Solved] Child grid not updating on edit and not displaying column aggregates....

[Robbie]

Hi,

I have a RadGrid, with a child grid contained inside. I AM NOT a coder and am doing this through the GUI. I have most things working, but cannot get the records to update when the edit button is selected. The child grid is also not displaying the column aggregates for the Hours and Minutes columns. Here is the aspx:

<%

@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

 

<%

@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

 

<!

 

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<

 

html xmlns="http://www.w3.org/1999/xhtml">

 

<

 

head runat="server">

 

 

<title>Untitled Page</title>

 

 

</head>

 

<

 

body>

 

 

<form id="form1" runat="server">

 

 

<telerik:RadScriptManager ID="ScriptManager1" runat="server"

 

 

EnableTheming="True">

 

 

</telerik:RadScriptManager>

 

 

<div>

 

 

 

<br />

 

 

 

</div>

 

 

<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True"

 

 

AllowSorting="True" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1"

 

 

GridLines="None" ShowGroupPanel="True" Skin="Sunset"

 

 

AllowAutomaticDeletes="True" AllowAutomaticInserts="True"

 

 

AllowAutomaticUpdates="True">

 

<

 

MasterTableView AllowCustomPaging="True" AllowCustomSorting="True"

 

 

AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="IssueNumber"

 

 

DataSourceID="SqlDataSource1" EditMode="PopUp">

 

 

<DetailTables>

 

 

<telerik:GridTableView runat="server" CommandItemDisplay="Top" ShowFooter="true"

 

 

DataSourceID="SqlDataSource2" AllowCustomPaging="True" Skin="Telerik"

 

 

AllowCustomSorting="True" AutoGenerateColumns="False" Width="99%" EditFormSettings-PopUpSettings-Modal="True"

 

 

CommandItemSettings-AddNewRecordText="Add new action" EditMode="PopUp" AllowAutomaticDeletes="True"

 

 

AllowAutomaticInserts="True" AllowAutomaticUpdates="True" EditFormSettings-PopUpSettings-Width="50%" Frame="Box"

 

 

TableLayout="Fixed" EditFormSettings-EditColumn-HeaderText="Edit Item">

 

 

<ParentTableRelation>

 

 

<telerik:GridRelationFields DetailKeyField="IssueNumber" MasterKeyField="IssueNumber" />

 

 

</ParentTableRelation>

 

 

<Columns>

 

 

<telerik:GridDropDownColumn HeaderText="Engineer" DataSourceID="SqlDataSource3" ListTextField="Engineer" ListValueField="Engineer" DataField="Engineer">

 

 

</telerik:GridDropDownColumn>

 

 

<telerik:GridBoundColumn HeaderText="Action Type" HeaderButtonType="TextButton"

 

 

DataField="ActionType">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="Title" HeaderButtonType="TextButton" DataField="HeaderDesc">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridHTMLEditorColumn HeaderText="Description" HeaderButtonType="TextButton" DataField="Description" ColumnEditorID="GridHTMLEditorColumnEditor1">

 

 

<HeaderStyle Width="40%" />

 

 

</telerik:GridHTMLEditorColumn>

 

 

<telerik:GridDateTimeColumn HeaderText="Date" HeaderButtonType="TextButton"

 

 

DataField="DateTime" DataFormatString="{0:dd/MM/yyyy}">

 

 

</telerik:GridDateTimeColumn>

 

 

<telerik:GridNumericColumn HeaderText="Hours" FooterText="Total"

 

 

HeaderButtonType="TextButton" DataField="HoursSpent" DataType="System.Decimal"

 

 

ColumnEditorID="GridNumericColumnEditor1" KeepNotRoundedValue="True"

 

 

Aggregate="Sum">

 

 

</telerik:GridNumericColumn>

 

 

<telerik:GridNumericColumn HeaderText="Minutes" FooterText="Total"

 

 

HeaderButtonType="TextButton" DataField="MinutesSpent" DataType="System.TimeSpan"

 

 

ColumnEditorID="GridNumericColumnEditor2" KeepNotRoundedValue="True"

 

 

Aggregate="Sum">

 

 

</telerik:GridNumericColumn>

 

 

<telerik:GridBoundColumn HeaderText="Issue No" HeaderButtonType="TextButton" DataField="IssueNumber">

 

 

</telerik:GridBoundColumn>

 

 

</Columns>

 

<

 

CommandItemSettings AddNewRecordText="Add new action"></CommandItemSettings>

 

 

<RowIndicatorColumn>

 

 

<HeaderStyle Width="20px" />

 

 

</RowIndicatorColumn>

 

 

<ExpandCollapseColumn>

 

 

<HeaderStyle Width="20px" />

 

 

</ExpandCollapseColumn>

 

<

 

EditFormSettings>

 

<

 

PopUpSettings ScrollBars="Auto" Modal="True" Width="50%"></PopUpSettings>

 

</

 

EditFormSettings>

 

 

<EditItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"

 

 

Font-Strikeout="False" Font-Underline="False" Wrap="True" />

 

 

<PagerStyle Mode="NextPrevNumericAndAdvanced" />

 

 

</telerik:GridTableView>

 

 

</DetailTables>

 

<

 

RowIndicatorColumn>

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

RowIndicatorColumn>

 

 

<ParentTableRelation>

 

 

<telerik:GridRelationFields DetailKeyField="IssueNumber"

 

 

MasterKeyField="IssueNumber" />

 

 

</ParentTableRelation>

 

<

 

ExpandCollapseColumn Visible="True">

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="IssueNumber" DataType="System.Decimal"

 

 

HeaderText="Issue Number" ReadOnly="True" SortExpression="IssueNumber"

 

 

UniqueName="IssueNumber">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Customer" HeaderText="Customer"

 

 

SortExpression="Customer" UniqueName="Customer">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="InitialContact" HeaderText="Initial Contact"

 

 

SortExpression="InitialContact" UniqueName="InitialContact">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="InitialEngineer"

 

 

HeaderText="Initial Engineer" SortExpression="InitialEngineer"

 

 

UniqueName="InitialEngineer">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressName" HeaderText="Address Name"

 

 

SortExpression="AddressName" UniqueName="AddressName">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressNumber" DataType="System.Int32"

 

 

HeaderText="House/Flat Number" SortExpression="AddressNumber"

 

 

UniqueName="AddressNumber">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressStreet1" HeaderText="Street 1"

 

 

SortExpression="AddressStreet1" UniqueName="AddressStreet1">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressStreet2" HeaderText="Street 2"

 

 

SortExpression="AddressStreet2" UniqueName="AddressStreet2">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressStreet3" HeaderText="Street 3"

 

 

SortExpression="AddressStreet3" UniqueName="AddressStreet3">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressCity" HeaderText="City"

 

 

SortExpression="AddressCity" UniqueName="AddressCity">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressCounty" HeaderText="County"

 

 

SortExpression="AddressCounty" UniqueName="AddressCounty">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressCountry" HeaderText="Country"

 

 

SortExpression="AddressCountry" UniqueName="AddressCountry">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AddressPostCode"

 

 

HeaderText="PostCode" SortExpression="AddressPostCode"

 

 

UniqueName="AddressPostCode">

 

 

</telerik:GridBoundColumn>

 

 

</Columns>

 

</

 

MasterTableView>

 

 

<ClientSettings AllowDragToGroup="True">

 

 

<Selecting AllowRowSelect="True" />

 

 

</ClientSettings>

 

 

</telerik:RadGrid>

 

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:Trident_SLURPConnectionString %>"

 

 

DeleteCommand="DELETE FROM [Core_Support] WHERE [IssueNumber] = @IssueNumber"

 

 

InsertCommand="INSERT INTO [Core_Support] ([Customer], [InitialContact], [InitialEngineer], [AddressName], [AddressNumber], [AddressStreet1], [AddressStreet2], [AddressStreet3], [AddressCity], [AddressCounty], [AddressCountry], [AddressPostCode]) VALUES (@Customer, @InitialContact, @InitialEngineer, @AddressName, @AddressNumber, @AddressStreet1, @AddressStreet2, @AddressStreet3, @AddressCity, @AddressCounty, @AddressCountry, @AddressPostCode)"

 

 

SelectCommand="SELECT * FROM [Core_Support] ORDER BY [Customer]"

 

 

UpdateCommand="UPDATE [Core_Support] SET [Customer] = @Customer, [InitialContact] = @InitialContact, [InitialEngineer] = @InitialEngineer, [AddressName] = @AddressName, [AddressNumber] = @AddressNumber, [AddressStreet1] = @AddressStreet1, [AddressStreet2] = @AddressStreet2, [AddressStreet3] = @AddressStreet3, [AddressCity] = @AddressCity, [AddressCounty] = @AddressCounty, [AddressCountry] = @AddressCountry, [AddressPostCode] = @AddressPostCode WHERE [IssueNumber] = @IssueNumber">

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

 

</DeleteParameters>

 

 

<UpdateParameters>

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

 

</UpdateParameters>

 

 

<InsertParameters>

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

</InsertParameters>

 

 

</asp:SqlDataSource>

 

 

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:Trident_SLURPConnectionString %>"

 

 

DeleteCommand="DELETE FROM [Detail_Support] WHERE [RID] = @RID"

 

 

InsertCommand="INSERT INTO [Detail_Support] ([Engineer], [ActionType], [HeaderDesc], [Description], [DateTime], [HoursSpent], [MinutesSpent], [InHours], [IssueNumber]) VALUES (@Engineer, @ActionType, @HeaderDesc, @Description, @DateTime, @HoursSpent, @MinutesSpent, @InHours, @IssueNumber)"

 

 

SelectCommand="SELECT RID, Engineer, ActionType, HeaderDesc, Description, DateTime, HoursSpent, MinutesSpent, InHours, IssueNumber FROM Detail_Support WHERE (IssueNumber = @IssueNumber) ORDER BY DateTime"

 

 

 

 

 

UpdateCommand="UPDATE [Detail_Support] SET [Engineer] = @Engineer, [ActionType] = @ActionType, [HeaderDesc] = @HeaderDesc, [Description] = @Description, [DateTime] = @DateTime, [HoursSpent] = @HoursSpent, [MinutesSpent] = @MinutesSpent, [InHours] = @InHours, [IssueNumber] = @IssueNumber WHERE [RID] = @RID">

 

 

<SelectParameters>

 

 

<asp:ControlParameter ControlID="RadGrid1" Name="IssueNumber"

 

 

PropertyName="SelectedValue" />

 

 

</SelectParameters>

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="RID" Type="Decimal" />

 

 

</DeleteParameters>

 

 

<UpdateParameters>

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

<asp:Parameter Name="HoursSpent" Type="Decimal" />

 

 

<asp:Parameter Name="MinutesSpent" Type="Decimal" />

 

 

<asp:Parameter Name="InHours" Type="Boolean" />

 

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

 

<asp:Parameter Name="RID" Type="Decimal" />

 

 

</UpdateParameters>

 

 

<InsertParameters>

 

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

<asp:Parameter Name="HoursSpent" Type="Decimal" />

 

 

<asp:Parameter Name="MinutesSpent" Type="Decimal" />

 

 

<asp:Parameter Name="InHours" Type="Boolean" />

 

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

 

</InsertParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:GridNumericColumnEditor ID="GridNumericColumnEditor1" runat="server">

 

 

<NumericTextBox Culture="English (United Kingdom)" LabelCssClass=""

 

 

DataType="System.Decimal" MaxLength="5" MaxValue="24" MinValue="0"

 

 

ShowSpinButtons="True" Skin="Telerik">

 

 

<NumberFormat AllowRounding="False" DecimalSeparator=":"

 

 

KeepNotRoundedValue="True" />

 

 

</NumericTextBox>

 

 

</telerik:GridNumericColumnEditor>

 

 

<br />

 

 

<telerik:GridNumericColumnEditor ID="GridNumericColumnEditor2" runat="server">

 

 

<NumericTextBox Culture="English (United Kingdom)" LabelCssClass="" MaxValue="59"

 

 

MinValue="0" ShowSpinButtons="True" Skin="WebBlue">

 

 

</NumericTextBox>

 

 

</telerik:GridNumericColumnEditor>

 

 

<br />

 

 

<telerik:GridHTMLEditorColumnEditor ID="GridHTMLEditorColumnEditor1"

 

 

runat="server">

 

<

 

Editor AutoResizeHeight="True" EditModes="HTML" Skin="Telerik" Language="en-GB"><Content>

 

</

 

Content>

 

</

 

Editor>

 

 

</telerik:GridHTMLEditorColumnEditor>

 

 

<br />

 

 

<telerik:RadAjaxManager runat="server">

 

 

<AjaxSettings>

 

 

<telerik:AjaxSetting AjaxControlID="RadGrid1">

 

 

<UpdatedControls>

 

 

<telerik:AjaxUpdatedControl ControlID="RadGrid1" />

 

 

</UpdatedControls>

 

 

</telerik:AjaxSetting>

 

 

</AjaxSettings>

 

 

</telerik:RadAjaxManager>

 

 

<telerik:GridDateTimeColumnEditor ID="GridDateTimeColumnEditor1" runat="server">

 

 

</telerik:GridDateTimeColumnEditor>

 

 

<asp:SqlDataSource ID="SqlDataSource3" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:Trident_SLURPConnectionString %>"

 

 

SelectCommand="SELECT [Engineer] FROM [DataSources] ORDER BY [Engineer]">

 

 

</asp:SqlDataSource>

 

 

</form>

 

</

 

body>

 

</

 

html>




Thanks for any help anyone can give me.

:-)

 

[Shinu]

Hi Robbie,

Here is a code library submission which explains how to perform Automatic operations(insert/update/delete) in a hierarchical grid with SqlDataSource control. Give a try with that and see whether it works.
Automatic operations in hierarchical grid with SqlDataSource control

Shinu

[Robbie]

Hi Shinu and thanks for the reply.

As I said in the original post, i'm not a coder and am trying to do most of this via the GUI. I have already looked at the example you posted and cannot really understand it. I was hoping for something without code.

Many thanks again.

:-)