DevForce Community Forum : Navigation problem.... http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Navigation problem.... Tue, 14 Apr 2026 15:04:03 -700 Thu, 02 Dec 2010 09:24:29 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2319 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Navigation problem.... : ... And I am preety sure there... http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9295#9295 Author: bala
Subject: 2319
Posted: 02-Dec-2010 at 9:24am

... And I am preety sure there is no problem in Binding with AgDataGrid..

Somewhere Query has problem ...


THanks
]]> Thu, 02 Dec 2010 09:24:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9295#9295 Navigation problem.... : Hi DeniskThanks for replyBut with... http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9246#9246 Author: bala
Subject: 2319
Posted: 25-Nov-2010 at 10:04am

Hi Denisk

Thanks for reply
But with this multi leg  not able to achieved the resutl. I trace my result at certain
level query collapsing..
Function evaluation disabled because a previous function evaluation timed out.
You must continue execution to reenable function evaluation.    IdeaBlade.EntityModel.RelatedEntityList<Crmall.Entities.PESSOA_TIPO_LOJA_SHOPPING>

I am getting such type of error when i debugging data..

Is there anotherway to achieved ???


With Best
]]> Thu, 25 Nov 2010 10:04:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9246#9246 Navigation problem.... : Hi bala;Here&#039;s an example... http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9197#9197 Author: DenisK
Subject: 2319
Posted: 22-Nov-2010 at 11:47am

Hi bala;

Here's an example to achieve what you want using the NorthwindIB database.

1. First query the related entities.

public void LoadDataGridFromIndirectlyRelatedEntity() {
      Orders = new ObservableCollection<Order>();

      //This is also called a multi-leg include. See http://drc.ideablade.com/xwiki/bin/view/Documentation/AddIncludeToQuery
      var ordersQuery = _mainMgr.Orders
        .Include(o => o.Customer)
        .Include("OrderDetails.Product.Supplier");

      ordersQuery.ExecuteAsync(e => {
        e.Results.ForEach(Orders.Add);
      });
    }

2. Bind to the data grid. I'm not an expert on DevExpress AgDataGrid so I'm using the Silverlight DataGrid as an example.

<sdk:DataGrid Name="OrdersGrid" 
                      AutoGenerateColumns="False"                      
                      ItemsSource="{Binding Orders}"
                      SelectionMode="Single"
                      Grid.Row="0">
            <sdk:DataGrid.Columns>
                <sdk:DataGridTextColumn
                    Binding="{Binding OrderID}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
                <sdk:DataGridTextColumn
                    Binding="{Binding Customer.CompanyName}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
                <sdk:DataGridTextColumn
                    Header="Count of OrderDetails"
                    Binding="{Binding OrderDetails.Count}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
            </sdk:DataGrid.Columns>
        </sdk:DataGrid>
        
        <sdk:DataGrid Name="CustomersGrid"
                      AutoGenerateColumns="False"
                      ItemsSource="{Binding ElementName=OrdersGrid, Path=SelectedItem.OrderDetails}"
                      SelectionMode="Single"
                      Grid.Row="1">
            <sdk:DataGrid.Columns>
                <sdk:DataGridTextColumn
                    Binding="{Binding OrderID}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
                <sdk:DataGridTextColumn
                    Binding="{Binding Order.ShipCity}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
                <sdk:DataGridTextColumn
                    Binding="{Binding Product.ProductName}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
                <sdk:DataGridTextColumn
                    Binding="{Binding Product.Supplier.CompanyName}"
                    CanUserReorder="True"
                    CanUserResize="True"
                    CanUserSort="True"
                    Width="Auto" />
            </sdk:DataGrid.Columns>
        </sdk:DataGrid>

You can see here for information on how to do it using the AgDataGrid. 

http://www.devexpress.com/Support/Center/p/Q238939.aspx
]]> Mon, 22 Nov 2010 11:47:05 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9197#9197 Navigation problem.... : HiI am try to using navigation.I... http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9166#9166 Author: bala
Subject: 2319
Posted: 19-Nov-2010 at 9:57am

Hi
I am try to using navigation.I can get the value who has one-many relation
but its not possible to getting value who has many to many relation.
I want to navigate from xmal file. Like I am acessing value of PERFIL
 <dxg:AgDataGridColumn FieldName="PESSOA_TIPO_USUARIO_PERFIL.DESCRICAO" HeaderContent="Perfil" MaxColumnWidth="Infinity"
 MinColumnWidth="150" SortIndex="-1" GroupIndex="-1" Visible="True" Width="250" />
same I want to acess value of others which are not in direct relation.
I want to get the value of NOME  its in PESSOA_FISICA and Email its in PESSOA_EMAIL.
..

I am attaching my grid and EDM below.
Any Help.


Edited by bala - 22-Nov-2010 at 10:26am]]> Fri, 19 Nov 2010 09:57:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2319&PID=9166#9166