ASPxGridView.GetDetailRowKeyValue(Control) Method

Gets the key value of the grid’s row that is the master row for the specified control used to display detail data.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v19.1.dll

Declaration

C#

public static object GetDetailRowKeyValue(
    Control control
)

VB.NET

Public Shared Function GetDetailRowKeyValue(
    control As Control
) As Object

Parameters

Name	Type	Description
control	Control	A control that represents detail data.

Returns

Type	Description
Object	An object that uniquely identifies the master row containing the specified detail control.

Remarks

In master-detail scenarios, when ASPxGridView is used as a master grid that displays details within its detail rows, you can visualize detail data using any desired control. The primary task in these scenarios is to identify a master row when a control that displays the details should be bound to its data.

If a detail control is not ASPxGridView, you can use a master grid’s GetDetailRowKeyValue method to determine in which master row the specified detail control is currently instantiated. This method accepts a detail control instance as a parameter and returns the corresponding master row’s key value.

C#

protected void GridView1_DataBinding (object sender, EventArgs e) {
        //Standard GridView is used as a detail control.
        GridView detailGrid = sender as GridView;
        detailGrid.DataSource = dsDetailView;
        dsDetailView.SelectParameters["CategoryID"].DefaultValue = ASPxGridView.GetDetailRowKeyValue(detailGrid).ToString();
    }

VB.NET

Protected Sub GridView1_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
        'Standard GridView is used as a detail control.
        Dim detailGrid As GridView = TryCast(sender, GridView)
        detailGrid.DataSource = dsDetailView
        dsDetailView.SelectParameters("CategoryID").DefaultValue = ASPxGridView.GetDetailRowKeyValue(detailGrid.ToString()
    End Sub

Example

In master-detail scenarios, when ASPxGridView is used as a master grid that displays details within its detail rows, you can visualize detail data using any desired control. The main task in these scenarios is to identify a master row when a control that displays the details should be bound to its data.The simplest way to visualize detail data is to use ASPxGridView, because this control has the GetMasterRowKeyValue method that automatically obtains the corresponding master row's key value from a master ASPxGridView.For other cases (when a detail control is not ASPxGridView), you can bring a detail control in correlation with its master row by using a specifically implemented static method - ASPxGridView.GetDetailRowKeyValue. This method accepts a detail control instance as a parameter and returns the corresponding master row's key value: GetDetailRowKeyValue(Control)

This example demonstrates how to use the GetMasterRowKeyValue and ASPxGridView.GetDetailRowKeyValue methods.

object keyValue = ASPxGridView.GetDetailRowKeyValue(treeList);

Dim keyValue As Object = ASPxGridView.GetDetailRowKeyValue(treeList)

See also:

• Load detail data dynamically (self-referenced dataset example)

• Master-Detail ASPxGridView - How to show detail data in ASPxTreeList

• How to use the FormView component to display details of a master-detail ASPxGridView

• How to use different components to display related data of a master-detail ASPxGridView

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-use-different-components-to-display-details-of-a-master-detail-aspxgridview-e3604

Default.aspx.cs

using DevExpress.Web.ASPxTreeList;
using DevExpress.Web.ASPxGridView;
using DevExpress.Web.ASPxEditors;

public partial class _Default : System.Web.UI.Page {
    protected void Page_Load (object sender, EventArgs e) {
    }

    protected void ASPxTreeList1_Init (object sender, EventArgs e) {
        ASPxTreeList treeList = sender as ASPxTreeList;
        object keyValue = ASPxGridView.GetDetailRowKeyValue(treeList);
        if (keyValue.Equals(2) || keyValue.Equals(5))
            treeList.RootValue = keyValue;
    }

    protected void detailGrid_BeforePerformDataSelect (object sender, EventArgs e) {
        ASPxGridView grid = sender as ASPxGridView;
        Session["CategoryID"] = grid.GetMasterRowKeyValue();
    }

    protected void GridView1_DataBinding (object sender, EventArgs e) {
        GridView gridView = sender as GridView;
        gridView.DataSource = dsDetailView;
        dsDetailView.SelectParameters["CategoryID"].DefaultValue = ASPxGridView.GetDetailRowKeyValue(gridView).ToString();
    }
}

Default.aspx (C#)

<dx:ASPxGridView ID="masterGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsMainGrid"
    Width="700px" KeyFieldName="CategoryID">
    <Templates>
        <DetailRow>
            <dx:ASPxPageControl ID="ASPxPageControl1" runat="server" ActiveTabIndex="0" Width="100%">
                <TabPages>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl1" runat="server">
                                <dx:ASPxTreeList ID="ASPxTreeList1" runat="server" AutoGenerateColumns="False" DataSourceID="dsTreeList"
                                    KeyFieldName="EmployeeID" OnInit="ASPxTreeList1_Init" ParentFieldName="ReportsTo"
                                    Width="100%">
                                    <Columns>
                                        <dx:TreeListTextColumn FieldName="FirstName" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                        <dx:TreeListTextColumn FieldName="LastName" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                        <dx:TreeListTextColumn FieldName="Title" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                    </Columns>
                                </dx:ASPxTreeList>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl3" runat="server">
                                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ProductID"
                                    Style="margin-right: 0px" OnDataBinding="GridView1_DataBinding">
                                    <Columns>
                                        <asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
                                        <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
                                        <asp:BoundField DataField="UnitsInStock" HeaderText="UnitsInStock" SortExpression="UnitsInStock" />
                                        <asp:BoundField DataField="UnitsOnOrder" HeaderText="UnitsOnOrder" SortExpression="UnitsOnOrder" />
                                    </Columns>
                                </asp:GridView>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl2" runat="server">
                                <dx:ASPxGridView ID="detailGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsDetail"
                                    KeyFieldName="ProductID" OnBeforePerformDataSelect="detailGrid_BeforePerformDataSelect"
                                    Width="100%">
                                    <Columns>
                                        <dx:GridViewDataTextColumn FieldName="ProductName" VisibleIndex="1">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="SupplierID" VisibleIndex="2">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="CategoryID" VisibleIndex="3">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="QuantityPerUnit" VisibleIndex="4">
                                        </dx:GridViewDataTextColumn>
                                    </Columns>
                                </dx:ASPxGridView>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                </TabPages>
            </dx:ASPxPageControl>
        </DetailRow>
    </Templates>
    <Columns>
        <dx:GridViewDataTextColumn FieldName="CategoryID" ReadOnly="True" VisibleIndex="0">
            <EditFormSettings Visible="False" />
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="CategoryName" VisibleIndex="1">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="2">
        </dx:GridViewDataTextColumn>
    </Columns>
    <SettingsDetail ShowDetailRow="True" />
</dx:ASPxGridView>
<asp:AccessDataSource ID="dsMainGrid" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]">
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsTreeList" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [Title], [ReportsTo] FROM [Employees]">
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsDetail" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit] FROM [Products] WHERE ([CategoryID] = ?)">
    <SelectParameters>
        <asp:SessionParameter Name="CategoryID" SessionField="CategoryID" Type="Int32" />
    </SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsDetailView" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [CategoryID] FROM [Products] WHERE ([CategoryID] = ?)">
    <SelectParameters>
        <asp:Parameter DefaultValue="ParentID" Name="CategoryID" Type="Int32" />
    </SelectParameters>
</asp:AccessDataSource>

Default.aspx (VB.NET)

<dx:ASPxGridView ID="masterGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsMainGrid"
    Width="700px" KeyFieldName="CategoryID">
    <Templates>
        <DetailRow>
            <dx:ASPxPageControl ID="ASPxPageControl1" runat="server" ActiveTabIndex="0" Width="100%">
                <TabPages>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl1" runat="server">
                                <dx:ASPxTreeList ID="ASPxTreeList1" runat="server" AutoGenerateColumns="False" DataSourceID="dsTreeList"
                                    KeyFieldName="EmployeeID" OnInit="ASPxTreeList1_Init" ParentFieldName="ReportsTo"
                                    Width="100%">
                                    <Columns>
                                        <dx:TreeListTextColumn FieldName="FirstName" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                        <dx:TreeListTextColumn FieldName="LastName" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                        <dx:TreeListTextColumn FieldName="Title" VisibleIndex="0">
                                        </dx:TreeListTextColumn>
                                    </Columns>
                                </dx:ASPxTreeList>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl3" runat="server">
                                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ProductID"
                                    Style="margin-right: 0px" OnDataBinding="GridView1_DataBinding">
                                    <Columns>
                                        <asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
                                        <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
                                        <asp:BoundField DataField="UnitsInStock" HeaderText="UnitsInStock" SortExpression="UnitsInStock" />
                                        <asp:BoundField DataField="UnitsOnOrder" HeaderText="UnitsOnOrder" SortExpression="UnitsOnOrder" />
                                    </Columns>
                                </asp:GridView>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                    <dx:TabPage>
                        <ContentCollection>
                            <dx:ContentControl ID="ContentControl2" runat="server">
                                <dx:ASPxGridView ID="detailGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsDetail"
                                    KeyFieldName="ProductID" OnBeforePerformDataSelect="detailGrid_BeforePerformDataSelect"
                                    Width="100%">
                                    <Columns>
                                        <dx:GridViewDataTextColumn FieldName="ProductName" VisibleIndex="1">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="SupplierID" VisibleIndex="2">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="CategoryID" VisibleIndex="3">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn FieldName="QuantityPerUnit" VisibleIndex="4">
                                        </dx:GridViewDataTextColumn>
                                    </Columns>
                                </dx:ASPxGridView>
                            </dx:ContentControl>
                        </ContentCollection>
                    </dx:TabPage>
                </TabPages>
            </dx:ASPxPageControl>
        </DetailRow>
    </Templates>
    <Columns>
        <dx:GridViewDataTextColumn FieldName="CategoryID" ReadOnly="True" VisibleIndex="0">
            <EditFormSettings Visible="False" />
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="CategoryName" VisibleIndex="1">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="2">
        </dx:GridViewDataTextColumn>
    </Columns>
    <SettingsDetail ShowDetailRow="True" />
</dx:ASPxGridView>
<asp:AccessDataSource ID="dsMainGrid" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]">
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsTreeList" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [Title], [ReportsTo] FROM [Employees]">
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsDetail" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit] FROM [Products] WHERE ([CategoryID] = ?)">
    <SelectParameters>
        <asp:SessionParameter Name="CategoryID" SessionField="CategoryID" Type="Int32" />
    </SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="dsDetailView" runat="server" DataFile="~/App_Data/nwind.mdb"
    SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [CategoryID] FROM [Products] WHERE ([CategoryID] = ?)">
    <SelectParameters>
        <asp:Parameter DefaultValue="ParentID" Name="CategoryID" Type="Int32" />
    </SelectParameters>
</asp:AccessDataSource>

Default.aspx.vb

Imports DevExpress.Web.ASPxTreeList
Imports DevExpress.Web.ASPxGridView
Imports DevExpress.Web.ASPxEditors

Partial Public Class _Default
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    End Sub

    Protected Sub ASPxTreeList1_Init(ByVal sender As Object, ByVal e As EventArgs)
        Dim treeList As ASPxTreeList = TryCast(sender, ASPxTreeList)
        Dim keyValue As Object = ASPxGridView.GetDetailRowKeyValue(treeList)
        If keyValue.Equals(2) OrElse keyValue.Equals(5) Then
            treeList.RootValue = keyValue
        End If
    End Sub

    Protected Sub detailGrid_BeforePerformDataSelect(ByVal sender As Object, ByVal e As EventArgs)
        Dim grid As ASPxGridView = TryCast(sender, ASPxGridView)
        Session("CategoryID") = grid.GetMasterRowKeyValue()
    End Sub

    Protected Sub GridView1_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
        Dim gridView As GridView = TryCast(sender, GridView)
        gridView.DataSource = dsDetailView
        dsDetailView.SelectParameters("CategoryID").DefaultValue = ASPxGridView.GetDetailRowKeyValue(gridView).ToString()
    End Sub
End Class