Bonsoir,

J'utilise SL4, RIA Service, EF et SqlServer.

j'ai simplement une table Personnels et une table Hotels avec une association
(PersonnelID dans Hotels)

J'ai une datagrid + grid avec la présence des différents champs d'un hotel.

Je souhaite avoir une combobox proposant le choix de la personne ( personnel ) qui est lié à l'hotel (Hotels).

J'arrive à lister mes personnes dans ma combobox mais impossible de faire apparaitre la personne lié à l'hotel sélectionné dans ma datagrid.

PS : j'utilise bien [include] pour consommer mon association.

Voilà le code si quelqu'un pourrais y voir une solution Merci d'avance.

Code xml : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<navigation:Page
  x:Class="PortailSMCOM.Home" 
  xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" 
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
  xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
  xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"
  mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480"  
  Style="{StaticResource PageStyle}" xmlns:toolkit="http://schemas.microsoft.com/winfx/2006/xaml/presentation/toolkit" xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices" xmlns:my="clr-namespace:PortailSMCOM.Web"
    xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk">
 
  <Grid x:Name="LayoutRoot">
    <ScrollViewer x:Name="PageScrollViewer" Style="{StaticResource PageScrollViewerStyle}" >
 
      <StackPanel x:Name="ContentStackPanel">
 
        <TextBlock x:Name="HeaderText" Style="{StaticResource HeaderTextStyle}" 
                           Text="{Binding Path=ApplicationStrings.HomePageTitle, Source={StaticResource ResourceWrapper}}"/>
        <TextBlock x:Name="ContentText" Style="{StaticResource ContentTextStyle}" 
                           Text="Home page content"/>
 
                <Grid>
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*" />
                        <RowDefinition Height="29" />
                        <RowDefinition Height="*" />
                    </Grid.RowDefinitions>
 
                    <sdk:DataGrid AutoGenerateColumns="False" ItemsSource="{Binding ElementName=hotelsDomainDataSource, Path=Data}" Name="hotelsDataGrid" RowDetailsVisibilityMode="VisibleWhenSelected" IsReadOnly="True">
                        <sdk:DataGrid.Columns>
                            <sdk:DataGridTextColumn x:Name="nomColumn" Binding="{Binding Path=Nom}" Header="Nom" Width="300" />
                            <sdk:DataGridTextColumn x:Name="adresseColumn" Binding="{Binding Path=Adresse}" Header="Adresse" Width="600" />
                            <sdk:DataGridTextColumn x:Name="telColumn" Binding="{Binding Path=Tel}" Header="Tel" Width="Auto" />
                            <sdk:DataGridTemplateColumn x:Name="noteColumn" Header="Note" Width="Auto">
                                <sdk:DataGridTemplateColumn.CellTemplate>
                                    <DataTemplate>
                                        <toolkit:Rating Value="{Binding Note}" HorizontalAlignment="Left" ItemCount="5"  VerticalAlignment="Top" SelectionMode="Continuous" IsReadOnly="True" DisplayMemberPath="Note"  />
                                    </DataTemplate>
                                </sdk:DataGridTemplateColumn.CellTemplate>
                            </sdk:DataGridTemplateColumn>
                        </sdk:DataGrid.Columns>
                    </sdk:DataGrid>
                    <sdk:DataPager Grid.Row="1" Name="dataPager1" PageSize="20" Source="{Binding ElementName=hotelsDomainDataSource, Path=Data}" />
 
                </Grid>
                <Grid DataContext="{Binding ElementName=hotelsDomainDataSource, Path=Data}" Name="grid1">
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="Auto" />
                        <ColumnDefinition Width="530" />
                        <ColumnDefinition Width="349*" />
                    </Grid.ColumnDefinitions>
                    <Grid.RowDefinitions>
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="29" />
                        <RowDefinition Height="Auto" />
                        <RowDefinition Height="Auto" />
                    </Grid.RowDefinitions>
                    <sdk:Label Content="Adresse:" Grid.Column="0" Grid.Row="1" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <TextBox Grid.Column="1" Grid.Row="1" Height="30" HorizontalAlignment="Left" Margin="3,3,0,3" Name="adresseTextBox" Text="{Binding Path=Adresse, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true, TargetNullValue=''}" VerticalAlignment="Center" Width="527" />
                    <sdk:Label Content="Commentaire:" Grid.Column="0" Grid.Row="7" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <TextBox Grid.Column="1" Grid.Row="7" Height="100" HorizontalAlignment="Left" Margin="3,3,0,3" Name="commentaireTextBox" Text="{Binding Path=Commentaire, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true, TargetNullValue=''}" VerticalAlignment="Center" Width="523" />
                    <sdk:Label Content="Nom:" Grid.Column="0" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <TextBox Grid.Column="1" Height="27" HorizontalAlignment="Left" Margin="3,3,0,3" Name="nomTextBox" Text="{Binding Path=Nom, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true, TargetNullValue=''}" VerticalAlignment="Center" Width="298" />
                    <sdk:Label Content="Note:" Grid.Column="0" Grid.Row="4" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <toolkit:Rating DisplayMemberPath="Note" Grid.Column="1" Grid.Row="4" ItemCount="5" SelectionMode="Continuous" Value="{Binding Note}"  Name="noteRating" Margin="0,0,404,0" />
                    <sdk:Label Content="Personnel:" Grid.Column="0" Grid.Row="6" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <ComboBox DisplayMemberPath="Nom" Grid.Column="1" Grid.Row="0" Height="23" HorizontalAlignment="Left"    SelectedItem="{Binding  PersonnelID, Mode=TwoWay}" ItemsSource="{Binding ElementName=personnelDomainDataSource, Path=Data}" Margin="3" Name="nomComboBox" VerticalAlignment="Center" Width="120">
 
                    </ComboBox>
                    <sdk:Label Content="Prix:" Grid.Column="0" Grid.Row="3" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <TextBox Grid.Column="1" Grid.Row="3" Height="30" HorizontalAlignment="Left" Margin="3,3,0,3" Name="prixTextBox" Text="{Binding Path=Prix, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true}" VerticalAlignment="Center" Width="60" />
                    <sdk:Label Content="Tel:" Grid.Column="0" Grid.Row="2" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <TextBox Grid.Column="1" Grid.Row="2" Height="30" HorizontalAlignment="Left" Margin="3,3,0,3" Name="telTextBox" Text="{Binding Path=Tel, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true, TargetNullValue=''}" VerticalAlignment="Center" Width="120" />
                    <sdk:Label Grid.Column="0" Grid.Row="5" Content="Resto Present:" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                    <CheckBox Content="" Grid.Column="1" Grid.Row="5" Height="16" HorizontalAlignment="Left" IsChecked="{Binding Path=RestoPresent, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true}" Margin="3,3,0,3" Name="restoPresentCheckBox" VerticalAlignment="Center" />
                    <Grid DataContext="{Binding ElementName=personnelDomainDataSource, Path=Data}" Grid.Column="1" Grid.Row="5" Grid.RowSpan="2" HorizontalAlignment="Left" Margin="194,4,0,0" Name="grid2" VerticalAlignment="Top">
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="Auto" />
                            <ColumnDefinition Width="Auto" />
                        </Grid.ColumnDefinitions>
                        <Grid.RowDefinitions>
                            <RowDefinition Height="Auto" />
                        </Grid.RowDefinitions>
                        <sdk:Label Content="Nom:" Grid.Column="0" Grid.Row="0" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
 
                    </Grid>
                    <Grid Grid.Column="1" Grid.Row="3" HorizontalAlignment="Left" Margin="204,7,0,0" Name="grid3" VerticalAlignment="Top">
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="Auto" />
                            <ColumnDefinition Width="Auto" />
                        </Grid.ColumnDefinitions>
                        <Grid.RowDefinitions>
                            <RowDefinition Height="Auto" />
                        </Grid.RowDefinitions>
                        <sdk:Label Content="Prénom:" Grid.Column="0" Grid.Row="0" HorizontalAlignment="Left" Margin="3" VerticalAlignment="Center" />
                        <TextBox Grid.Column="1" Grid.Row="0" Height="23" HorizontalAlignment="Left" Margin="3" Name="prénomTextBox" Text="{Binding Path=Personnel.Prénom, Mode=TwoWay, NotifyOnValidationError=true, ValidatesOnExceptions=true, TargetNullValue=''}" VerticalAlignment="Center" Width="120" />
                    </Grid>
 
                </Grid>
 
                <riaControls:DomainDataSource AutoLoad="True" d:DesignData="{d:DesignInstance my:Hotels, CreateList=true}" Height="0" LoadedData="hotelsDomainDataSource_LoadedData_3" Name="hotelsDomainDataSource" QueryName="GetHotelsQuery" Width="0">
                    <riaControls:DomainDataSource.DomainContext>
                        <my:SMCOMDomainContext/>
                    </riaControls:DomainDataSource.DomainContext>
                </riaControls:DomainDataSource>
                <riaControls:DomainDataSource AutoLoad="True" d:DesignData="{d:DesignInstance my:Personnel, CreateList=true}" Height="0" LoadedData="personnelDomainDataSource_LoadedData_2" Name="personnelDomainDataSource" QueryName="GetPersonnelQuery" Width="0">
                    <riaControls:DomainDataSource.DomainContext>
                        <my:SMCOMDomainContext />
                    </riaControls:DomainDataSource.DomainContext>
                </riaControls:DomainDataSource>
            </StackPanel>
 
 
        </ScrollViewer>
 
    </Grid>
 
</navigation:Page>