Discussion :

[zakarinalaw]

Hello ,

I have 2 ASPxGriwView and my need is that when I select a row of the first ASPxGridView1, the 2nd ASPxGridView2 should show me all matching records in the ID of the selected row.

As I have shown in the attached pieces, I want when I select the 1st line, the 2nd ASPxGridView should shows me all matching records in the ID of the selected row.

I also share with my code to understand more the situation :

The code of ASPxGridView1 :

Code :

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
 
<dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" KeyFieldName="id_mvt">
            <Columns>
 
                <dx:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="5" 
                    ButtonType="Image" Caption="Nouveau   Filtrer" Width="100px">
                     <NewButton Visible="True">  <Image Url="images/add.gif" Height="20px" Width="20px"> </Image>
                    </NewButton>
                    <EditButton Visible="True" >  <Image Url="images/edit.gif" Height="25px" Width="25px"> </Image>
                    </EditButton>
                    <DeleteButton Visible="True"> <Image Url="images/delete.gif" Height="17px" Width="17px"> </Image>
                    </DeleteButton>
                    <ClearFilterButton Visible="True">
                    </ClearFilterButton>
                </dx:GridViewCommandColumn>
                <dx:GridViewDataTextColumn FieldName="id_mvt" ReadOnly="True" VisibleIndex="0" 
                    Caption="ID" Width="20px" ShowInCustomizationForm="True">
                    <EditFormSettings Visible="False"></EditFormSettings>
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataDateColumn FieldName="date" VisibleIndex="1" Caption="Date" 
                    Width="100px">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataComboBoxColumn Caption="Domaine" FieldName="id_dom_01" 
                    VisibleIndex="2" Width="60px">
                    <PropertiesComboBox DataSourceID="SqlDataSource2" 
                        DisplayFormatInEditMode="True" TextField="id_dom" ValueField="id_dom">
                    </PropertiesComboBox>
                </dx:GridViewDataComboBoxColumn>
                <dx:GridViewDataTextColumn FieldName="bon" VisibleIndex="3" 
                    Caption="Bon" Width="100px" Name="B">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="sens" VisibleIndex="4" 
                    Caption="Sens" Width="20px">
                </dx:GridViewDataTextColumn>
            </Columns>
            <Settings ShowFilterRow="False" />
 
<Settings ShowFilterRow="False"></Settings>
 
        </dx:ASPxGridView>

The code of ASPxGridView2 :

Code :

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
 
<dx:ASPxGridView ID="ASPxGridView2" runat="server" AutoGenerateColumns="False" 
            DataSourceID="DtlMvtDataSource">
            <Columns>
                <dx:GridViewDataTextColumn FieldName="article" VisibleIndex="0">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="id_detail_mvt" ReadOnly="True" 
                    VisibleIndex="1">
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="qte" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="stock" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="id_mvt" ReadOnly="True" VisibleIndex="4">
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="bon" VisibleIndex="5">
                </dx:GridViewDataTextColumn>
            </Columns>
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="DtlMvtDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:han_agriConnectionString %>" 
            SelectCommand="SELECT t_article_03.article, t_detail_mvt_02.id_detail_mvt, t_detail_mvt_02.qte, t_detail_mvt_02.stock, t_mvt_01.id_mvt, t_mvt_01.bon FROM t_article_03 INNER JOIN t_detail_mvt_02 ON t_article_03.id_article = t_detail_mvt_02.id_article_03 INNER JOIN t_mvt_01 ON t_detail_mvt_02.id_mvt_01 = t_mvt_01.id_mvt WHERE (t_mvt_01.id_mvt = @selected_id_mvt)">
            <SelectParameters>
                <asp:ControlParameter ControlID="ASPxGridView1" Name="selected_id_mvt" 
                    PropertyName="Selection" />
            </SelectParameters>
        </asp:SqlDataSource>

I Thank You in advance for your suggestions.
Merci pour vos réponses.