GRIDCONTROL主子表

来源:互联网 发布:修改js中的字体颜色 编辑:程序博客网 时间:2024/05/02 00:43

效果图,如图:

实现代码:

 private void Form5_Load ( object sender ,EventArgs e )        {            DataSet ds = new DataSet( );            DataTable da = SqlHelper.ExecuteDataTable( "SELECT PQF01,PQF02,PQF03,PQF04 FROM R_PQF" );            da.TableName = "DA";            DataTable de = SqlHelper.ExecuteDataTable( "SELECT PQF01,JM01,JM101 FROM R_PQO A,R_PQF B WHERE A.JM90=B.PQF01" );            de.TableName = "DE";            ds.Tables.Add( da );                ds.Tables.Add( de );            DataRelation relationOne = new DataRelation( "Level2" ,ds.Tables["DA"].Columns["PQF01"] ,ds.Tables["DE"].Columns["PQF01"] );            ds.Relations.Add( relationOne );            gridControl1.DataSource = ds.Tables["DA"];                    }


0 0