the differences of DataRelation class between 1.1 and 2.0

本文探讨了在不同.NET版本中创建DataRelation时遇到的问题,并提供了解决方案。在1.1版本中,直接添加关系不会引发错误,但在2.0版本中则会因父或子列不在DataSet中而失败。文章通过示例代码展示了如何正确地在一个DataSet内定义表格关系。

when u use the follow code on 1.1.it will compile without error.

/**////<summary>
///Testtablerelation.
///</summary>

publicvoidRelation_1_1()
...{
DataTabledtParent
=this.CreateDataTable();
dtParent.TableName
="Parent";

DataRelationrelations
=ds.Relations.Add("Relation",dtParent.Columns["index"],dtParent.Columns["parent_index"],false);

this.builder.Append(" GetthedatafromtreeROOT.");
this.GetLayerFromParent(ds,relations);
this.PrintDataTable(ds.Tables["parent"]);

this.builder.Append(" GetthedatafromtreeCHILDS.");
this.GetLayerFromChilds(ds,relations);
this.PrintDataTable(ds.Tables["parent"]);

this.DebugPrint(this.builder.ToString());
}

while it will run error on 2.0 with "Cannot create a DataRelation if Parent or Child Columns are not in a DataSet.".

if u want to run normally,u can use this cod:

/**////<summary>
///Testtablerelation.
///</summary>

publicvoidRelation_2_0()
...{
DataTabledtParent
=this.CreateDataTable();
dtParent.TableName
="Parent";

DataSetds
=newDataSet();
ds.Tables.Add(dtParent);
DataRelationrelations
=ds.Relations.Add("Relation",ds.Tables["Parent"].Columns["index"],ds.Tables["Parent"].Columns["parent_index"],false);

this.builder.Append(" GetthedatafromtreeROOT.");
this.GetLayerFromParent(ds,relations);
this.PrintDataTable(ds.Tables["parent"]);

this.builder.Append(" GetthedatafromtreeCHILDS.");
this.GetLayerFromChilds(ds,relations);
this.PrintDataTable(ds.Tables["parent"]);

this.DebugPrint(this.builder.ToString());

//this.WriteToTxtFile(this.builder.ToString());
}

what's your idea?

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值