1.使用DateSet DataRelation使主从表相关联
private void test_Load(object sender, EventArgs e)
{
Material_Inventory_DAL midal = new Material_Inventory_DAL();
Material_Inventory_Detail_DAL middal = new Material_Inventory_Detail_DAL();
BindingList<Material_InventoryBean> mibeanlist = midal.Get_Material_InventoryAll();
//创建表结构并给table赋值,如果你直接从数据库获得的是datatable或者dataset就可以省略这一步骤
DataTable dt1 = new DataTable();
dt1.Columns.Add("Inventory_ID");
dt1.Columns.Add("BatchOrder");
dt1.Columns.Add("LOT_No");
dt1.Columns.Add("LOT_Name");
dt1.Columns.Add("QTY");
dt1.Columns.Add("Price");
foreach (var materialInventoryBean in mibeanlist)
{
DataRow dr = dt1.NewRow();
dr["Inventory_ID"] = materialInventoryBean.Inventory_ID;
dr["BatchOrder"] = materialInventoryBean.BatchOrder;
dr["LOT_No"] = materialInventoryBean.LOT_No;
dr["LOT_Name"] = materialInventoryBean.LOT_Name;
dr["QTY"] = materialInventoryBean.QTY;
dr["P