สร้าง bindingsource Data ON dgv สองตาราง เมื่อคลิกเลือกตาราง header จะ select ข้อมูลโชว์ในตาราง detail
ยกตัวอย่าง function ดังนี้
private void SetBindingPlan() { this.bdsH.DataSource = this._dsData; this.bdsH.DataMember = this._sqlManager.TableName; this.bdnH.BindingSource = this.bdsH; this.dgvH.DataSource = this.bdsH; this.bdsD.DataSource = this.bdsH; this.bdsD.DataMember = this._sqlManager.FK_HCode; this.dgvD.DataSource = this.bdsD; } // SQLDataRelation relation = new DataRelation(this.FK_HCode, dataSet.Tables[this.TableName].Columns["HeardNo"], dataSet.Tables[this.TableNameHistory].Columns["HeardNo"], true); // false set constraint in DataRelation class dataSet.Relations.Add(relation); return dataSet; //// Array DataRelation relation = new DataRelation(this.FK_GroupMaterial, new DataColumn[]{ dataSet.Tables[this.TableSYPONBasketLayerSch].Columns["MATL_CD"] , dataSet.Tables[this.TableSYPONBasketLayerSch].Columns["MATL_CO"]}, new DataColumn[]{ dataSet.Tables[this.TableMaterailGroup].Columns["MATL_CD"] , dataSet.Tables[this.TableMaterailGroup].Columns["MATL_CO"]}, false); dataSet.Relations.Add(relation); // Reset Data for relation this._dsData.table[this._sql.child].rows.clear(); this._dsData.table[this._sql.parent].rows.clear();