首页 > 代码库 > DEV GridView嵌套
DEV GridView嵌套
/// <summary>
/// 绑定主表和明显表到GridView
/// </summary>
/// <param name="machineProduct">主表</param>
/// <param name="configureData">字表</param>
private void MasterDatailToGridView(DataTable machineProduct, DataTable configureData)
{
machineProduct.TableName = "MachineProduct";
DataSet ds = new DataSet();
ds.Tables.Add(machineProduct);
DataTable dtNew = configureData.Clone();
dtNew.TableName = "AccessoryConfigure";
foreach (DataRow dr in configureData.Rows)
{
object[] arr = dr.ItemArray;
dtNew.Rows.Add(arr);
}
ds.Tables.Add(dtNew);
//关联字段为GOODS_ID(商品ID)
DataColumn keyColumn = ds.Tables["MachineProduct"].Columns["GOODS_ID"];
DataColumn foreignKeyColumn = ds.Tables["AccessoryConfigure"].Columns["GOODS_ID"];
ds.Relations.Add("商品单位", keyColumn, foreignKeyColumn, false);
this.gridControl1.DataSource = ds.Tables["MachineProduct"];
this.gridControl1.ForceInitialize();
MachineProductGridView.ExpandAllGroups(); // 默认展开分组
}
#endregion
DEV GridView嵌套