如何做一对多表单

dongzhuo

unread,

Aug 19, 2003, 11:49:03 PM8/19/03

to

我搜过以前的贴子都没有类似问题
我自已建立了一对多关系如下：可子表中始终显示全部数据
请高手指点或给个完整的例子，不盛感激!

private void button5_Click(object sender, System.EventArgs e)
{
this.oleDbDataAdapter1 .Fill(df31);
this.oleDbDataAdapter2 .Fill (df31);

DataColumn mastercl;
DataColumn childcl;

mastercl=this.df31 .Tables ["bom_pcs"].Columns ["bom_pcs"];
childcl=this.df31 .Tables ["bom_pcs_sub"].Columns ["bom_pcs"];
DataRelation bom_pcsrel;
bom_pcsrel = new DataRelation ("vdfsg",mastercl,childcl);
df31.Relations .Add (bom_pcsrel);
this.dataGrid1 .DataSource =df31.bom_pcs_sub ;
}

derek

unread,

Aug 20, 2003, 1:35:11 AM8/20/03

to

DataRelation datarelation;
DataColumn datacolumn1;
DataColumn datacolumn2;
datacolumn1=this.ds.Tables["customers"].Columns["custid"];
datacolumn2=this.ds.Tables["contacts"].Columns["custid"];
datarelation=new DataRelation
("CustomerToContacts",datacolumn1,datacolumn2);
this.ds.Relations.Add(datarelation);

this.dataGrid1.SetDataBinding(this.ds,"customers");
this.dataGrid2.SetDataBinding
(this.ds,"customers.CustomerToContacts");

reference:
ms-
help://MS.VSCC.2003/MS.MSDNQTR.2003APR.1033/vbcon/html/vbts
kcreatingmasterdetailslistwithdatagrid.htm

dongzhuo

unread,

Aug 20, 2003, 3:01:46 AM8/20/03

to

我昭以下方法做了，可两DataGrid均只显示表头没有记录(即运行后显示两个空
表)，请大侠再次出手相就，

还有个问题我在移动记录时是否只移动父表记录就可以了？

"derek" <dere...@163.net> 写入消息新闻
:0b1e01c366dc$d32966d0$a101...@phx.gbl...

derek

unread,

Aug 20, 2003, 9:13:23 PM8/20/03

to

子表会跟主表记录的变而变。

改为这样：

private void button5_Click(object sender, System.EventArgs e)
{
this.oleDbDataAdapter1 .Fill(df31);
this.oleDbDataAdapter2 .Fill (df31);

DataColumn mastercl;
DataColumn childcl;

mastercl=this.df31 .Tables ["bom_pcs"].Columns ["bom_pcs"];
childcl=this.df31 .Tables ["bom_pcs_sub"].Columns ["bom_pcs"];
DataRelation bom_pcsrel;
bom_pcsrel = new DataRelation ("vdfsg",mastercl,childcl);
df31.Relations .Add (bom_pcsrel);

//this.dataGrid1 .DataSource =df31.bom_pcs_sub ;
//这里加上指定datagrid1(master), datagrid2（sub）数据源的语句
this.dataGrid1.SetDataBinding(df31,"bom_pcs");
this.dataGrid2.SetDataBinding(df31,"bom_pcs.vdfsg");
}

dongzhuo

unread,

Aug 20, 2003, 10:48:30 PM8/20/03

to

成了，多谢!多谢!

"dongzhuo" <dong...@yahorng.com.cn> 写入消息新闻
:uB7UW5sZ...@TK2MSFTNGP09.phx.gbl...