GridControl如何绑定主从表


------------------代码开始----------------------------------------------------------------------
          DataSet ds = new DataSet();
            string strConn = "User ID=system;Data Source=oracle09;Persist Security Info=True;Password=eport";
            OracleConnection conn = new OracleConnection(strConn);
            conn.Open();
            OracleDataAdapter oda = new OracleDataAdapter("select * from  offline_dec.USERINFO", conn);
            oda.Fill(ds, "userInfo");
            BindingSource bsmaster = new BindingSource();
            OracleDataAdapter odaMembers = new OracleDataAdapter("select * from offline_dec.USERINFO_FAMILYMEMBERS", conn);
            oda.Fill(ds, "memberInfo");
            BindingSource bsSonsMembers = new BindingSource();
            OracleDataAdapter odaPlaces = new OracleDataAdapter("select * from offline_dec.USERINFO_WORKPLACE", conn);
            oda.Fill(ds, "placeInfo");
            BindingSource bsSonsPlaces = new BindingSource();
            conn.Close();

            //添加约束   家庭成员

            DataRelation drMembers = new DataRelation("家庭成员", ds.Tables["userInfo"].Columns["userid"], ds.Tables["memberInfo"].Columns["userid"]);
            ds.Relations.Add(drMembers);
            //工作地
            DataRelation drPlaces = new DataRelation("工作地", ds.Tables["userInfo"].Columns["userid"], ds.Tables["placeInfo"].Columns["userid"]);
            ds.Relations.Add(drPlaces);
            bsmaster.DataSource = ds;
            bsmaster.DataMember = "userInfo";

            bsSonsMembers.DataSource = ds;
            bsSonsMembers.DataMember = "memberInfo";

            bsSonsPlaces.DataSource = ds;
            bsSonsPlaces.DataMember = "placeInfo";


            gridControl1.DataSource = ds.Tables["userInfo"];
-------------------代码结束--------------------------------------------------------------------------
//在YBID和BZYBID之间创建关系

            System.Data.DataRelation dataRelation;
            System.Data.DataColumn dataColumn1;
            System.Data.DataColumn dataColumn2;

            dataColumn1 = ds.Tables["Parents"].Columns["YBID"];//设定表关系
            dataColumn2 = ds.Tables["Sons"].Columns["BZYBID"];
            dataRelation = new System.Data.DataRelation("ParentsSons", dataColumn1, dataColumn2);
            if (ds.Relations.Count == 0)
            {
                ds.Relations.Add(dataRelation);

            }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值