ASPxGridView1用法<二>

关于ASPxGridView1添加子项事件,今天上网查了好久,没有找到合适,最后看己摸所,得到了结果,贴出来,希望能给大家有所帮助。

创新互联建站服务项目包括察哈尔右翼中旗网站建设、察哈尔右翼中旗网站制作、察哈尔右翼中旗网页制作以及察哈尔右翼中旗网络营销策划等。多年来,我们专注于互联网行业,利用自身积累的技术优势、行业经验、深度合作伙伴关系等,向广大中小型企业、政府机构等提供互联网行业的解决方案,察哈尔右翼中旗网站推广取得了明显的社会效益与经济效益。目前,我们服务的客户以成都为中心已经辐射到察哈尔右翼中旗省份的部分城市,未来相信会继续扩大服务区域并继续获得客户的支持与信任!

首先是修改属性如图

ASPxGridView1用法<二>

然后,再编辑模板,

ASPxGridView1用法<二>

 

ASPxGridView1用法<二>

这样就搞定了,接下来,就是添加子项控件

<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="单号" FieldName="sheet_no" Name="sheet_no" VisibleIndex="0">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="供应商" FieldName="sup_no" Name="sup_no" VisibleIndex="1">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="经办人" 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="单号" FieldName="sheet_no" Name="sheet_no" VisibleIndex="0">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="编号" 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="数量" FieldName="order_qnty" Name="item_name" VisibleIndex="4">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn Caption="零售价" 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>

注意:红色为子项控件,另外在父控件中一定要邦定主键,KeyFieldName="sheet_no";

接下来就是后台邦定代码了,如何邦定我父控件,前面都说过了,接下来,我们看如何邦定子控件,因为子控件在后台调不出来,所以,我再加一个SqlDataSource控件,用它来邦定子控件,这个邦定要动态的去,在展开行事件中写

  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);
    }

 

ASPxGridView1用法<二>

 

 

 

本文标题:ASPxGridView1用法<二>
文章URL:https://www.cdcxhl.com/article6/ggodog.html

成都网站建设公司_创新互联,为您提供静态网站全网营销推广搜索引擎优化标签优化网站改版网站维护

广告

声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联

搜索引擎优化