How to get an actual data row for a DetailView

Sophie Hazell

created 11 years ago

Hello,

I have few master detail views on my grid. I am using

((ColumnView)gridControl1.FocusedView).GetDataSourceRowIndex(currentRowHandle);

to get the selected row in the datasource, as suggested by few posts by other members. Please see the attached code and the relevant method is

gridView3_FocusedRowChanged().

The problem is that it gets wrong datasource index - Please look at the attached image for more info. It counts the row handle relative to every child view. So the row handle of 1 could appear in more than one child views, hence not unique.

Is there any way to get the correct data row from the datasource, which actually does correspond to the actual row in the datasource?

Kind Regards

dxSample.zip

Answers approved by DevExpress Support

DevExpress Support Team

created 11 years ago (modified 11 years ago)

Hello,
Each detail view has a unique data source. That is why the GetDataSourcRowIndex returns the same value for different detail views. I recommend that you review the “Identifying Rows and Cards” help topic for additional information.
I believe the best way to retrieve correct data row it to use this approach:

C#
ColumnView detailView = (ColumnView)gridView1.GetDetailView(gridView1.FocusedRowHandle, 0);  
int detailRowHandle = detailView.FocusedRowHandle;  
DataRow row = detailView.GetDataRow(detailRowHandle);

Please try this solution and let me know your results.

Show previous comments (3)

Sophie Hazell 11 years ago

Hello,
I used the code that you provided (after changing GetDataRow to GetRow, as my datasource is not DataTable) but it still returns wrong row:
object row = detailView.GetRow(detailRowHandle);
If you plug this in my code, provided earlier, you will know what I mean.

Thanks for providing the link “Identifying Rows and Cards”. After reviewing this, I did not find anywhere any way of uniquely identifying a row within the whole of grid control. It does tell that every row handle is unique WITHIN a view, but it doesn't tell how to get the correct row in the datasource using the row which has been clicked. Did I miss anything?

DevExpress Support Team 11 years ago

Hello,
For regular data sources without any relationships, use the GridView.GetDataRow, GridView.GetDataSourceRowIndex or GridView.GetRow method.
Since each detail view has its own data source, use the method I described in the answer to get the correct row.
I have modified your example with my approach, and all works correctly. Please replace the gridView3_FocusedRowChanged event handler with this code:

C#
private void gridView3_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)  
{  
     GridView view = sender as GridView;  
     int currentRowHandle = view.FocusedRowHandle;  
     if (gridView3.IsGroupRow(currentRowHandle)) {  
     } else {  
            object row = view.GetRow(currentRowHandle);  
            Text = (row as RecordCustomerChild).ProductDesc;  
     }  
}

Please try this solution and let me know your results.

Sophie Hazell 11 years ago

This works fine (except one thing, please see below). I think the trick was to cast sender as GridView, to get the current detail view, instead of using gridView1.GetDetailView.
I found one thing: It doesn't invoke FocusedRowChanged event in the following scenario:

Expand at least 2 detail views
Click on top most row in the first detail view
Click on the top most row in the second detail view.
Click on the top most row in the first detail view again.
Expected result:
FocusedRowChanged should be invoked
Actual result:
FocusedRowChanged does not get invoked
So in other words, if you click on the same row index in another detail view, it will not trigger the FocusedRowChanged event. Is there any other event which I could use and it would get triggered in this case? (This should have been a separate ticket, but had most of the relevant details here)
Thanks

DevExpress Support Team 11 years ago

Hello,
This behavior is caused by the fact that a focused row handle is not changed in this case, but a focused detail view is changed. I recommend that you review the "Detail Pattern and Clone Views" help topic to learn more about this functionality.
To resolve this issue, handle the GridControl.FocusedViewChanged property, for example, like this:

C#
private void gridControl1_FocusedViewChanged(object sender, DevExpress.XtraGrid.ViewFocusEventArgs e)  
{  
    if (e.View.Name == gridView3.Name)  
        (e.View as GridView).FocusedRowHandle = int.MinValue;  
}

Please try this solution and let me know your results.

Sophie Hazell 11 years ago

Hello Andrey,
Handling FocusedViewChanged in combination with FocusedRowChanged works great - Thanks for your assistance!
(May be in future, dev express changes this behaviour, which would eliminate the need of using FocusedViewChanged for this)
Kind Regards

DevExpress Support Team 11 years ago

You're welcome, Sophie.
We do not have plans to change the current behavior since it is logical. Each DetailGrid has its own row numbering starting with zero and its own datasource. Thus, the FocusedRowChanged event is raised only when a focused row handle is changed.
Please feel free to contact us in case of any difficulty. We are happy to help you at any time.

Created: May 27, 2014 11:56 AM

Modified: May 29, 2014 12:54 PM

Platform: WinForms

Product: XtraGrid Suite

Build: 13.1.10

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

How to get an actual data row for a DetailView

Answers approved by DevExpress Support

Recently viewed tickets