ASPxGridView1用法<二>

關(guān)于ASPxGridView1添加子項(xiàng)事件，今天上網(wǎng)查了好久，沒有找到合適，最后看己摸所，得到了結(jié)果，貼出來，希望能給大家有所幫助。

首先是修改屬性如圖

然后，再編輯模板，

這樣就搞定了，接下來，就是添加子項(xiàng)控件

<div>
        <dx:ASPxGridView ID="grid" runat="server" KeyFieldName="sheet_no" AutoGenerateColumns="False"
            ClientIDMode="AutoID" OnSelectionChanged="Page_Load" OnDataBound="grid_DataBound"
            OnFocusedRowChanged="grid_FocusedRowChanged" OnDetailRowExpandedChanged="grid_DetailRowExpandedChanged"
            OnDetailsChanged="grid_DetailsChanged" Width="490px">
            <ClientSideEvents FocusedRowChanged="function(s, e) { }" RowClick="function(s, e) {
    OnGridFocusedRowChanged();
}" />
            <Columns>
                <dx:GridViewDataTextColumn Caption="單號(hào)" FieldName="sheet_no" Name="sheet_no" VisibleIndex="0">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="供應(yīng)商" FieldName="sup_no" Name="sup_no" VisibleIndex="1">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="經(jīng)辦人" FieldName="order_man" Name="order_man" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="操作人" FieldName="oper_id" Name="oper_id" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="操作日期" FieldName="oper_date" Name="oper_date"
                    VisibleIndex="4">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="總金額" FieldName="paid_amount" Name="paid_amount"
                    VisibleIndex="5">
                </dx:GridViewDataTextColumn>
                <dx:GridViewCommandColumn VisibleIndex="6" ShowSelectCheckbox="True">
                    <EditButton Visible="True" Text="編輯">
                    </EditButton>
                    <DeleteButton Visible="True" Text="刪除">
                    </DeleteButton>
                </dx:GridViewCommandColumn>
            </Columns>
            <Templates>
                <DetailRow>
                    <dx:ASPxGridView ID="subGrid" runat="server" DataSourceID="SqlDataSource1">
                        <Columns>
                            <dx:GridViewDataTextColumn Caption="單號(hào)" FieldName="sheet_no" Name="sheet_no" VisibleIndex="0">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="編號(hào)" FieldName="item_no" Name="item_no" VisibleIndex="1">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="條碼" FieldName="barcode" Name="barcode" VisibleIndex="2">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="單位" FieldName="unit_no" Name="unit_no" VisibleIndex="3">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="數(shù)量" FieldName="order_qnty" Name="item_name" VisibleIndex="4">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="零售價(jià)" FieldName="in_price" Name="in_price" VisibleIndex="5">
                            </dx:GridViewDataTextColumn>
                        </Columns>
                    </dx:ASPxGridView>
                </DetailRow>
            </Templates>
            <SettingsBehavior AllowFocusedRow="True" ConfirmDelete="True" />
            <SettingsDetail ShowDetailRow="True" />
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" DataSourceMode="DataReader">
        </asp:SqlDataSource>
    </div>

注意：紅色為子項(xiàng)控件，另外在父控件中一定要邦定主鍵，KeyFieldName="sheet_no"；

接下來就是后臺(tái)邦定代碼了，如何邦定我父控件，前面都說過了，接下來，我們看如何邦定子控件，因?yàn)樽涌丶诤笈_(tái)調(diào)不出來，所以，我再加一個(gè)SqlDataSource控件，用它來邦定子控件，這個(gè)邦定要?jiǎng)討B(tài)的去，在展開行事件中寫

  private void NewMethod(int i)
    {
//得到主鍵值
        object var = this.grid.GetRowValues(i, new string[] { "sheet_no" });
        this.SqlDataSource1.DataSourceMode = SqlDataSourceMode.DataReader;
        this.SqlDataSource1.ConnectionString = "Server=.;DataBase=hjh02;uid=sa;pwd=1";
        this.SqlDataSource1.SelectCommand = string.Format("select * from lsps_bhqd where sheet_no='{0}'", var.ToString());
        this.SqlDataSource1.DataBind();
    }
//展開行事件

    protected void grid_DetailRowExpandedChanged(object sender, ASPxGridViewDetailRowEventArgs e)
    {
        NewMethod(e.VisibleIndex);
    }