主从表的建立

 

//表查--病害id--主从表++++++++++++++++++++++++public static DataSet QueryGetQlgjDispdbdisidTABbyqidZC(string qid, string bwname){string SQLStringZ = "select * from   tl_qlsoft_cql_qlcheck_qlstye_bw a, tl_qlsoft_cql_qlcheck_qlstye_bw_gj b  where   a.chbwid=b.chbwid   and  a.qlid='" + qid + "' and a.chbwtypename='" + bwname + "' ";string SQLStringC = "select * from    tl_qlsoft_cql_qlcheck_qlstye_bw_gj_checkDispd  ";// and  c.chgjid='" + bwname + "'// string SQLStringC = "select * from   tl_qlsoft_cql_qlcheck_qlstye_bw a, tl_qlsoft_cql_qlcheck_qlstye_bw_gj b,tl_qlsoft_cql_qlcheck_qlstye_bw_gj_checkDispd c where   a.chbwid=b.chbwid and   b.chgjid=c.chgjid   ";// and  c.chgjid='" + bwname + "'using (SqlConnection connection = new SqlConnection(connString)){DataSet ds = new DataSet();connection.Open();//主表SqlDataAdapter commandZ = new SqlDataAdapter(SQLStringZ, connection);commandZ.Fill(ds, "dsZ");//从表SqlDataAdapter commandC = new SqlDataAdapter(SQLStringC, connection);commandC.Fill(ds, "dsC");connection.Close();//创建主外键DataColumn parent = ds.Tables["dsZ"].Columns["chgjid"];DataColumn child = ds.Tables["dsC"].Columns["chgjid"];//添加关系并指定为RelationColumnDataRelation rel = new DataRelation("RelationColumn", parent, child,false);ds.Relations.Add(rel);return ds;　　　　//返回的是一个DataSet}

//主从表
            DataSet datdis = CqlcheckBwGjDispdSER.QueryGetQlgjDispdbdisidTABbyqidZC(cqlid, "上部结构");//QueryGetQlgjDispdbdisidTABbyqidZC
            //XRTable zz = report.FindControl("table6", false) as XRTable; //表格隐藏
            //zz.DataBindings.Add("Text", datdis, "tableCell42");
            //1.绑定主表
            DetailReportBand DetailReporttZ = report.FindControl("DetailReport", true) as DetailReportBand;
            DetailReporttZ.DataSource = datdis;
            DetailReporttZ.DataMember = "ds";

            DetailReportBand DetailReporttC = report.FindControl("DetailReport11", true) as DetailReportBand;
            //2.//指定从表成员
            DetailReporttC.DataMember = "RelationColumn";
            //3.绑定从表
            DetailReporttC.DataSource = datdis;