DataTable goodsGroup = new DataTable("GoodsGroup");
goodsGroup.Columns.Add("GoodsGroupCode",typeof(string));
DataTable goods = new DataTable("Goods");
goods.Columns.Add("GoodsGroupCode",typeof(string));
goods.Columns.Add("GoodsCode",typeof(string));
goods.Columns.Add("Cost",typeof(int));
DataSet ds = new DataSet();
ds.Tables.Add(goodsGroup);
ds.Tables.Add(goods);
goodsGroup.Rows.Add(new object[]{"A"});
goodsGroup.Rows.Add(new object[]{"B"});
goodsGroup.Rows.Add(new object[]{"C"});
goods.Rows.Add(new object[]{"A","123",1000});
goods.Rows.Add(new object[]{"A","456",1500});
goods.Rows.Add(new object[]{"A","789",2000});
goods.Rows.Add(new object[]{"B","777",3000});
goods.Rows.Add(new object[]{"C","001",500});
goods.Rows.Add(new object[]{"C","002",550});
goodsGroup.ChildRelations.Add("GoodsGroupGoods",
goodsGroup.Columns["GoodsGroupCode"],goods.Columns["GoodsGroupCode"]);
this.DataList1.DataSource = goodsGroup;
this.DataList1.DataBind();
|