This is a migrated thread and some comments may be shown as answers.

How to get the Child Table row count when Parent row is selected or after insert/update in Child Table.

7 Answers 717 Views

Grid

This is a migrated thread and some comments may be shown as answers.

gc_0620 asked on 03 May 2011, 03:23 AM

Folks using VS 2010 and Rad Grid controls for Ajax 2011 V.1

I am using hierarchical Master/Child Table. I would like to know how to get the row counts of detail table into a varible (say

int childRowcount) in following scenarios:

1) When Master record is selected (Without expanding)

2) After the update/insert in Child Table.

Thanks GC_0620
_____________

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)

{

if (e.Item is GridDataItem && e.Item.OwnerTableView.Name == "MasterTable")

{

GridDataItem dataItem = (GridDataItem)e.Item;

// How to Get Child Table Row Count

}

if (e.Item is GridDataItem && e.Item.OwnerTableView.Name == "DetailTable")

{

GridDataItem childItem = (GridDataItem)e.Item;

// How to Get the Child Table Row Count

}

7 Answers, 1 is accepted

answered on 03 May 2011, 08:00 AM

Hello,

In order to get the row count when master table row is selected, better approach is to go for client side.

Javascript:

<script type="text/javascript">

function OnRowSelected(sender, args)

{

var detailTable = args.get_gridDataItem().get_nestedViews()[0];

alert(detailTable.get_dataItems().length);

}

</script>

Note: Set HierarchyLoadMode in MasterTableView as Client.

For second scenario, attach ItemCommand event and try the following snippet code. Hope this helps you.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)

{

if( (e.CommandName == RadGrid.UpdateCommandName) ||(e.CommandName == RadGrid.PerformInsertCommandName))

{

if (e.Item.OwnerTableView.Name == "DetailTable1")

{

int i= e.Item.OwnerTableView.Items.Count;

Response.Write(i);

}

Thanks,
Princy.

answered on 27 Feb 2013, 04:49 AM

Hi,

Please check the following code snippet to prevent user from editing the Parent RadGrid's row if doesn't have Child row.

Javascript:

<script type="text/javascript">

function OnCommand(sender, eventArgs) {

if (eventArgs.get_commandName() == 'Edit') {

var editIndex = eventArgs.get_commandArgument();

var masterTable = sender.get_masterTableView();

var dataItem = masterTable.get_dataItems()[editIndex];

if (dataItem.get_nestedViews().length == 0) {

eventArgs.set_cancel(true);

alert("canceled");

}

</script>

Thanks,
Princy.

answered on 27 Feb 2013, 06:10 PM

Thanks a lot Princy for your timely help,

For some reason dataItem.get_nestedViews().length comes out as zero irrespective of wheather the DetailTable has any rows or not.
Please find below the relevant code bolcks copied from my bulky program.
I use LINQ-to-SQL to set datasources at server for both the master and detailTables and the detailTable uses HierarchyLoadMode="Client" .
Hope you'd have a moment to glance through the code below and point me in the right direction.
Thanks a lot again for all your posts. They have helped me tremendously.

 function RowCommand(sender,

eventArgs) {

 var

editIndex =

eventArgs.get_commandArgument(); 

var masterTable =

sender.get_masterTableView(); 

var dataItem =

masterTable.get_dataItems()[editIndex]; 

if ((eventArgs.get_commandName() == "Edit") &&

(dataItem.get_nestedViews().length == 0))

{ 

eventArgs.set_cancel(true); 

alert("canceled

"); 

} }

 <telerik:RadAjaxManager ID="RadAjaxManager1"

runat="server" > 

<AjaxSettings> 

<telerik:AjaxSetting

AjaxControlID="cbPICPUserActivity"> 

<UpdatedControls> 

<telerik:AjaxUpdatedControl

ControlID="rgSampleData"></telerik:AjaxUpdatedControl> 

</UpdatedControls>

<UpdatedControls> 

<telerik:AjaxUpdatedControl ControlID="rgSampleData"

LoadingPanelID="RadAjaxLoadingPanel1"> 

</telerik:AjaxUpdatedControl> 

<telerik:AjaxUpdatedControl

ControlID="cbPICPUserActivity"></telerik:AjaxUpdatedControl> 

</UpdatedControls> 

</telerik:AjaxSetting> 

<telerik:AjaxSetting

AjaxControlID="cbPICPProcessType"> 

<UpdatedControls> 

<telerik:AjaxUpdatedControl ControlID="rgSampleData"

LoadingPanelID="RadAjaxLoadingPanel1"> 

</telerik:AjaxUpdatedControl> 

<telerik:AjaxUpdatedControl

ControlID="cbPICPProcessType"></telerik:AjaxUpdatedControl> 

</UpdatedControls> 

</telerik:AjaxSetting> 

</AjaxSettings> </telerik:RadAjaxManager>

 

<telerik:RadFilter runat="server" ID="RadFilter1" Skin="Sunset"

FilterContainerID="rgSampleData" ShowApplyButton="false" />

<telerik:RadGrid

 

runat="server" 

ID="rgSampleData" 

Skin="Sunset" 

ShowFooter="true"

 

AutoGenerateColumns="false" 

AllowAutomaticInserts="false"

 

AllowAutomaticUpdates="false" 

AllowMultiRowSelection="false" 

AllowPaging="true" 

PageSize="15" 

EnableViewState="true"

 

AllowFilteringByColumn="true" 

OnColumnCreated="rgSampleData_ColumnCreated" 

OnPreRender="rgSampleData_PreRender"

 

OnNeedDataSource="rgSampleData_NeedDataSource" 

OnItemEvent="rgSampleData_ItemEvent" 

OnItemCommand="rgSampleData_ItemCommand" 

OnInsertCommand="rgSampleData_InsertCommand" 

OnSelectedIndexChanged="rgSampleData_SelectedIndexChanged" 

OnItemInserted="rgSampleData_ItemInserted" 

OnUpdateCommand="rgSampleData_UpdateCommand" 

OnItemDataBound="rgSampleData_ItemDataBound" 

OnItemCreated="rgSampleData_ItemCreated" 

OnDetailTableDataBind="rgSampleData_DetailTableDataBind" 

OnRowEditing="rgSampleData_RowEditing" 

 

OnItemUpdated="rgSampleData_ItemUpdated"

OnDeleteCommand="rgSampleData_DeleteCommand" 

> 

<PagerStyle

Mode="Slider"></PagerStyle> 

<MasterTableView

IsFilterItemExpanded="true" 

Name="Master" 

Width="98%" 

datakeynames="PXQSampleId" 

bordercolor="LightGray"

 

CommandItemDisplay="Top" 

editmode="InPlace"> 

<CommandItemTemplate> 

<telerik:RadToolBar runat="server" ID="RadToolBar1" CssClass="customToolBar"

 

OnButtonClick="RadToolBar1_ButtonClick" AutoPostBack="true"

Skin="Sunset"> 

<Items> 

<telerik:RadToolBarButton Text="Apply filter" CommandName="FilterRadGrid"

 

ImageUrl="~/Portals/_default/Skins/PXQ_MRT_Skins/images/stock_filter_data_by_criteria.ico"

Visible="false"> 

</telerik:RadToolBarButton>

<telerik:RadToolBarButton

 

Text="Add new Sample Record"

 

CommandName="InitInsert" 

ImageUrl="~/Portals/_default/Skins/PXQ_MRT_Skins/images/Add Record.gif"

 

Visible='<%# !rgSampleData.MasterTableView.IsItemInserted

%>'>

 

</telerik:RadToolBarButton>

<telerik:RadToolBarButton Text="Refresh"

CommandName="RebindGrid" 

ImageUrl="~/images/synchronize.gif"> 

</telerik:RadToolBarButton>

</Items> 

</telerik:RadToolBar> 

</CommandItemTemplate> 

<EditFormSettings InsertCaption="Enter Sample

details"> 

</EditFormSettings> 

<Columns>

 

<telerik:GridNumericColumn DataField="PXQSampleId" UniqueName="PXQSampleId"

HeaderText="PXQ Sample Id" DataType="System.Int32" Visible="false"

AllowFiltering="false"> 

<ItemStyle Width="0%" HorizontalAlign="Center" CssClass="SmallLink"

/> 

</telerik:GridNumericColumn> 

<telerik:GridBoundColumn DataField="activity" UniqueName="activity"

HeaderText="Activity" AllowFiltering="false"

readonly="true"> 

<HeaderStyle Width="22%"

/> 

<ItemStyle Width="22%" HorizontalAlign="Left" CssClass="SmallLink"

/> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ProcessType" UniqueName="ProcessType"

HeaderText="Process" AllowFiltering="false"

readonly="true"> 

<HeaderStyle Width="22%"

/> 

<ItemStyle Width="22%" HorizontalAlign="Left" CssClass="SmallLink"

/> 

</telerik:GridBoundColumn> 

<telerik:GridDateTimeColumn DataField="ConductedDate"

UniqueName="ConductedDate" HeaderText="Conducted On"

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

<HeaderStyle Width="15%"

/> 

<ItemStyle Width="15%" HorizontalAlign="Left" CssClass="SmallLink"

/> 

</telerik:GridDateTimeColumn> 

<telerik:GridNumericColumn DataField="PopulationSize"

UniqueName="PopulationSize" HeaderText="Population"

DataType="System.Int32"> 

<HeaderStyle Width="2%" HorizontalAlign="right"

/> 

<ItemStyle Width="2%" HorizontalAlign="right" CssClass="SmallLink"

/> 

</telerik:GridNumericColumn> 

<telerik:GridNumericColumn DataField="SampleSize" UniqueName="SampleSize"

HeaderText="Sample"

DataType="System.Int32"> 

<HeaderStyle Width="2%" HorizontalAlign="right"

/> 

<ItemStyle Width="2%" HorizontalAlign="right" CssClass="SmallLink"

/> 

</telerik:GridNumericColumn>

 

<telerik:GridNumericColumn DataField="PXQActivityId"

UniqueName="PXQActivityId" HeaderText="PXQActivityId" DataType="System.Int32"

Visible="false"

AllowFiltering="false"> 

<ItemStyle Width="0%" HorizontalAlign="Center" CssClass="SmallLink"

/> 

</telerik:GridNumericColumn> 

<telerik:GridNumericColumn DataField="PXQProcessTypeId"

HeaderText="PXQProcessTypeId" DataType="System.Int32" Visible="false"

AllowFiltering="false"> 

<ItemStyle Width="0%" HorizontalAlign="Center" CssClass="SmallLink"

/> 

</telerik:GridNumericColumn>

 

<telerik:GridEditCommandColumn

 

ButtonType="ImageButton"

 

UniqueName="EditCommandColumn"

 

CancelText="Cancel" 

UpdateText="Post"

 

InsertText="Post New"

 

EditText="Edit">

<HeaderStyle Width="40px"

> 

</HeaderStyle>

 

</telerik:GridEditCommandColumn >

 

<telerik:GridButtonColumn CommandName="Delete" ConfirmText="Are you sure you

want to permanently delete this Sample Record and its Error/Cause Details?"

Text="Delete" UniqueName="Delete"

HeaderStyle-Width="6%">

 

</telerik:GridButtonColumn

 

</Columns> 

<DetailTables> 

<telerik:GridTableView DataKeyNames="PXQSampleId"

 

Name="SampleErrorCauseTotal"

 

Width="60%"

 

HierarchyLoadMode="Client"

 

runat="server"

 

ShowFooter="True" 

AutoGenerateColumns="False" 

AllowFilteringByColumn="false" 

AllowPaging="false" 

> 

<ParentTableRelation> 

<telerik:GridRelationFields DetailKeyField="PXQSampleId"

MasterKeyField="PXQSampleId"

/> 

</ParentTableRelation>

<Columns> 

<telerik:GridTemplateColumn HeaderText="PXQSampleErrorCauseId"

UniqueName="PXQSampleErrorCauseId" Visible="false"

> 

<ItemTemplate> 

<telerik:RadNumericTextBox runat="server" ID="PXQSampleErrorCauseId"

Text='<%# Bind( "PXQSampleErrorCauseId")

%>'> 

<NumberFormat GroupSeparator="" DecimalDigits="0"

/> 

</telerik:RadNumericTextBox> 

</ItemTemplate> 

</telerik:GridTemplateColumn> 

<telerik:GridBoundColumn DataField="PXQSampleId"

UniqueName="PXQSampleId" Visible="false"

/> 

<telerik:GridBoundColumn DataField="PXQErrorCauseId"

UniqueName="PXQErrorCauseId" HeaderText="PXQErrorCauseId" HeaderStyle-Width="5%"

Visible="false"> 

<ItemStyle HorizontalAlign="Left" CssClass="GridChildRowSmall"

/>

 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ErrorCause" UniqueName="ErrorCause"

HeaderText="ERROR CAUSES"

HeaderStyle-Width="25.7%"> 

<ItemStyle HorizontalAlign="Left" Width="120px" CssClass="GridChildRowSmall"

/>

 

</telerik:GridBoundColumn> 

<telerik:GridTemplateColumn HeaderText="ERROR CAUSE TOTALS"

HeaderStyle-Width="37%"

> 

<ItemTemplate> 

<telerik:RadNumericTextBox runat="server" ID="ErrorCauseTotal" Text='<%#

Bind( "ErrorCauseTotal")

%>' 

MinValue="0" MaxValue="99999" MaxLength="6"

Width="50"> 

<NumberFormat GroupSeparator="" DecimalDigits="0" />

 

<ClientEvents OnBlur="CauseBlur" OnFocus="CauseFocus"

OnLoad="CauseGridItemLoad"

></ClientEvents> 

</telerik:RadNumericTextBox> 

</ItemTemplate> 

<FooterTemplate> 

<telerik:RadButton runat="server" ID="btnCauseFooter"

Width="100" 

ButtonType="LinkButton" Text="Total Causes" Skin="Sunset"

> 

</telerik:RadButton> 

<telerik:RadNumericTextBox ID="txtCauseFooter" runat="server"

Width="40"

MaxLength="6"> 

<ClientEvents

OnLoad="CauseFooterLoad"></ClientEvents> 

<NumberFormat GroupSeparator="" DecimalDigits="0"

/> 

</telerik:RadNumericTextBox> 

 

  

<telerik:RadButton runat="server" ID="btnSave"

OnClientClicked="showalertSave" CommandName="SaveChanges"

Width="40"

<BR>

ButtonType="LinkButton" Text="Save" Skin="Sunset"

> 

</telerik:RadButton> 

  

<telerik:RadButton runat="server" ID="btnQuit"

OnClientClicked="showalertQuit" CommandName="Quit"

Width="40"

<BR>

ButtonType="LinkButton" Text="Quit" Skin="Sunset"

> 

</telerik:RadButton> 

  

<telerik:RadButton runat="server" ID="btnChart"

OnClientClicked="showalertChart" CommandName="Chart"

Width="40"

<BR>

ButtonType="LinkButton" Text="Chart" Skin="Sunset"

> 

</telerik:RadButton>

 

</FooterTemplate> 

</telerik:GridTemplateColumn> 

</Columns> 

<NoRecordsTemplate> 

None to

Display 

</NoRecordsTemplate>

 

</telerik:GridTableView> 

</DetailTables

 

</MasterTableView> 

<ClientSettings EnablePostBackOnRowClick="false"

> 

<Selecting AllowRowSelect="True"

/> 

<ClientEvents OnRowSelecting="RowSelecting"

/> 

<ClientEvents OnCommand="RowCommand"

/> 

</ClientSettings> 

</telerik:RadGrid> 

 

 protected void

rgSampleData_NeedDataSource(object source, GridNeedDataSourceEventArgs

e) 

{ 

//selectedActivityID =

int.Parse(cbPXQUserActivity.SelectedValue.ToString()); 

//selectedProcessID =

int.Parse(cbPXQProcessType.SelectedValue.ToString()); 

if ((cbPXQUserActivity.Items.Count > 0) &&

(!e.IsFromDetailTable)) 

{

LoadGrid_rgSampleData();} 

else 

{ 

rgSampleData.DataSource =

null; 

lblErrorMessage.Text = "You are not assigned to any Activity

yet"; 

} }

  protected void

LoadGrid_rgSampleData() 

{ 

selectedActivityID =

int.Parse(cbPXQUserActivity.SelectedValue.ToString()); 

selectedProcessID =

int.Parse(cbPXQProcessType.SelectedValue.ToString()); 

var objPXQ_SampleDetailedList = from s in

db.PXQSamples 

where (s.PXQActivityId == selectedActivityID

&& 

s.PXQProcessTypeId == selectedProcessID)

join pact in db.PXQActivities on s.PXQActivityId equals pact.PXQActivityId

join makeAct in db.make_data_activities on pact.make_data_activities_Id equals

makeAct.make_data_activities_id<BR>

join procType in db.PXQProcessTypes on s.PXQProcessTypeId equals

procType.PXQProcessTypeId

select

new 

{ 

makeAct.activity, 

s.PXQActivityId, 

procType.PXQProcessTypeId,<BR>

procType.ProcessType,<BR>

s.PXQSampleId, 

s.ConductedDate, 

s.PopulationSize, 

s.SampleSize, 

s.AddUser, 

s.AddDate, 

s.UpdateUser, 

s.UpdateDate, 

};

rgSampleData.DataSource =

objPXQ_SampleDetailedList;

 }

  protected void

rgSampleData_DetailTableDataBind(object source,

Telerik.Web.UI.GridDetailTableDataBindEventArgs

e) 

{ 

try 

{ 

// retrieve the PXQSampleId from the

datagrid 

GridDataItem gridDataItem = e.DetailTableView.ParentItem as

GridDataItem; 

int sampleRecordID =

int.Parse(gridDataItem["PXQSampleId"].Text); 

switch

(e.DetailTableView.Name) 

{ 

case

"SampleErrorTotals": 

{

 

List<PXQ_RetrieveSampleErrorTypeDetailResult> objSampleErrTotalsResult =

sqlcontroller.PXQ_RetrieveSampleErrorTypeTotalList(sampleRecordID);<BR>

e.DetailTableView.DataSource =

objSampleErrTotalsResult; 

e.DetailTableView.ToolTip = "Error Totals for the above

Sample"; 

break; 

}

case

"SampleErrorCauseTotal": 

{

 

List<PXQ_RetrieveSampleErrorCauseDetailResult>

objSampleErrCauseTotalsResult =

sqlcontroller.PXQ_RetrieveSampleErrorCauseDetailList(sampleRecordID);

e.DetailTableView.DataSource =

objSampleErrCauseTotalsResult; 

e.DetailTableView.ToolTip = "Error Causes for the above

Sample"; 

break; 

}

} 

}  catch

(Exception

exc) 

{ 

Exceptions.ProcessModuleLoadException(this,

exc); 

} }

 

answered on 01 Mar 2013, 07:16 PM

Hi Daniel,
Thank you for your reply.
When I set HierarchyLoadMode="Client" in the MasterTableView definition I am getting the correct value for dataItem.get_nestedViews().length.
However the InLine Edit function of the MasterTable Row now fails. When I click on the pencil Icon to edit a row it doesn't go into edit mode.
Looks like the inline Edit function of the Master Table in my case requires the HierarchyLoadMode to be ServerBind.
My client settings is as follows:-
<ClientSettings EnablePostBackOnRowClick="false" >
 <Selecting AllowRowSelect="True" />
 <ClientEvents OnRowSelecting="RowSelecting" />
 <ClientEvents OnCommand="RowCommand" />
</ClientSettings>
I need EnablePostBackOnRowClick="false" in order to perform some processing at the client.

Not sure how to proceed from here.