472,119 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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 1113
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.