OK, so I'm struggling here!
I'm trying to create a dataset representation in Visual Basic 2010 Express of my XML schema. The problem I've got is understanding the relationships.
I want my XML to look like this...
So, I thought I would create 3 datatables, within a dataset called "edx"...
"eventdata" contains the "createdwith" column
"eventdetails" contains the "eventname" and "eventdate" columns
"entrant" contains the "surname", "firstname" etc columns
Trouble is, the XML that produces is...
...which is not what I want. I suppose it may not matter ultimately, but is it possible to achieve what I ideally want and if so, how?
I thought I could include columns named "eventdetails" and "entrant" within the "eventdata" datatable and somehow tell the designer that those two columns are actually the two nested datatables with the same name, but that doesn't seem to work, no matter what I do with the "relation".
I could rename the dataset "eventdata" which would get me the root element name I want, but then I don't see where the "createdwith" element goes in the dataset design? It needs a datatable to sit in? I suppose I could put it in the "eventdetails" element and be done with it...
Thanks,
Tim
I'm trying to create a dataset representation in Visual Basic 2010 Express of my XML schema. The problem I've got is understanding the relationships.
I want my XML to look like this...
VB.NET:
<eventdata>
<createdwith>schema.xsd</createdwith>
<eventdetails>
<eventname>some event</eventname>
<eventdate>2012-05-03</eventdate>
</eventdetails>
<entrant>
<surname>Bloggs</surname>
<firstname>Joe</firstname>
..lots more simple elements..
</entrant>
</eventdata>
So, I thought I would create 3 datatables, within a dataset called "edx"...
"eventdata" contains the "createdwith" column
"eventdetails" contains the "eventname" and "eventdate" columns
"entrant" contains the "surname", "firstname" etc columns
Trouble is, the XML that produces is...
VB.NET:
<edx>
<eventdata>
<createdwith>schema.xsd</createdwith>
</eventdata>
<eventdetails>
<eventname>some event</eventname>
<eventdate>2012-05-03</eventdate>
</eventdetails>
<entrant>
<surname>Bloggs</surname>
<firstname>Joe</firstname>
..lots more simple elements..
</entrant>
</edx>
...which is not what I want. I suppose it may not matter ultimately, but is it possible to achieve what I ideally want and if so, how?
I thought I could include columns named "eventdetails" and "entrant" within the "eventdata" datatable and somehow tell the designer that those two columns are actually the two nested datatables with the same name, but that doesn't seem to work, no matter what I do with the "relation".
I could rename the dataset "eventdata" which would get me the root element name I want, but then I don't see where the "createdwith" element goes in the dataset design? It needs a datatable to sit in? I suppose I could put it in the "eventdetails" element and be done with it...
Thanks,
Tim