469,347 Members | 3,452 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

How to create DataSet schema with Parent table containing child table

I have a requirement where I need to create a dataset that consists of
a table inside a table ( a child table inside a parent table). I am not
really familiar with the data relations and not sure how to represent
this relation.

I did create a schema and it looks good on paper, but when I create a
dataset from this schema it does not allow me to write to the child
table. I am elaborate more if required.

This is what my schema looks like:

Table 1:
Row1 int
Row2 string
Row3 (Table 2) ComplexType
|
Table 2:
Row1 int
Row2 int

As can be seen, Table 2 is part of the Table 1.

Please help me out how to create this kind of relation and then
populate data through code.
Thanks

Dec 4 '06 #1
1 1065
Can somebody throw some light on this ....

donet programmer wrote:
I have a requirement where I need to create a dataset that consists of
a table inside a table ( a child table inside a parent table). I am not
really familiar with the data relations and not sure how to represent
this relation.

I did create a schema and it looks good on paper, but when I create a
dataset from this schema it does not allow me to write to the child
table. I am elaborate more if required.

This is what my schema looks like:

Table 1:
Row1 int
Row2 string
Row3 (Table 2) ComplexType
|
Table 2:
Row1 int
Row2 int

As can be seen, Table 2 is part of the Table 1.

Please help me out how to create this kind of relation and then
populate data through code.
Thanks
Dec 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.