hi,
I am dealing with 3 xml schemas (lets say 1.xsd,2.xsd,3.xsd)
where 1.xsd imports and references 2,3.
The total number of tables in the combined schema are 22.(several nested elements with attribute values )
Here is the problem.I am trying to fill the dataset with the data from sql server.Right now I have a stored proc which gives 3 result sets .I do not knwo how to fill the dataset.Do I have to modify the stored proc to give 22 result sets?Also some of the tables in the dataset dont need data from database as they are root of their children.I am just outlining here what exactly I need
<E1>
<E2 attr1="gh">..</E2>
<E3>
<E4>
<E5 attr2="fd"></E5>
</E4>
</E3>
</E1>
Here in this example 5 tables and I only need data for 2 tables.Hence I do not expect stored proc to return 5 result sets.What exactly shoul I do to achieve my task.
I would appreciate if someone can help me with this.