Hi
I have a dataset with 2 tables and Relations
What is the best way to flatten the 2 files to a new table or xml or file
I can loop thru table1 and get the childrows
or
I can do an Xpath on the xml but not sure how to get relation from xsd
or
Is there another alternative???
Currently
Table1
2000 10,000
2001 12,000
Table2
2000 mustang 2,000
2000 corvet 4,000
What I want
2000 10,000 mustang 2,000
2000 12,000 corvet 4,000
Thanks
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="vfffg">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="e1">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="CarYear" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="e2">
<xs:complexType>
<xs:sequence>
<xs:element name="ID" type="xs:string" minOccurs="0" />
<xs:element name="CarYear" type="xs:string" minOccurs="0" />
<xs:element name="CarModel" type="xs:string" minOccurs="0" />
<xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1">
<xs:selector xpath=".//vfffg" />
<xs:field xpath="ID" />
</xs:unique>
<xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1">
<xs:selector xpath=".//e1" />
<xs:field xpath="ID" />
<xs:field xpath="CarYear" />
</xs:unique>
<xs:keyref name="e1" refer="e1_Constraint1">
<xs:selector xpath=".//e2" />
<xs:field xpath="ID" />
<xs:field xpath="CarYear" />
</xs:keyref>
<xs:keyref name="e0" refer="Constraint1">
<xs:selector xpath=".//e1" />
<xs:field xpath="ID" />
</xs:keyref>
</xs:element>
</xs:schema> 3 2840
I believe using the relations to flat will be easy and efficient method to
do it.
Vijay
"Joe" <hc******@yahoo.com> wrote in message
news:u2**************@tk2msftngp13.phx.gbl... Hi
I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file
I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd or Is there another alternative???
Currently
Table1 2000 10,000 2001 12,000
Table2 2000 mustang 2,000 2000 corvet 4,000
What I want
2000 10,000 mustang 2,000 2000 12,000 corvet 4,000
Thanks
<?xml version="1.0" standalone="yes"?> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="vfffg"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e1"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e2"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="CarModel" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1"> <xs:selector xpath=".//vfffg" /> <xs:field xpath="ID" /> </xs:unique> <xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:unique> <xs:keyref name="e1" refer="e1_Constraint1"> <xs:selector xpath=".//e2" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:keyref> <xs:keyref name="e0" refer="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> </xs:keyref> </xs:element> </xs:schema>
Joe,
If you are going to use XML, then why not just export the table contents
as XML? You would have to do no work than indicating where you want the XML
written to, and all the relations will be maintained correctly (which is
better than a flat table, IMO).
If you have to create a flat table, it looks like you want an inner
join. You will have to cycle through the parent table, and then call the
GetChildRows method on each row in the parent row. If there are child rows,
then you can cycle through those and write your information (using the
parent information as well as you do) appropriately.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Joe" <hc******@yahoo.com> wrote in message
news:u2**************@tk2msftngp13.phx.gbl... Hi
I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file
I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd or Is there another alternative???
Currently
Table1 2000 10,000 2001 12,000
Table2 2000 mustang 2,000 2000 corvet 4,000
What I want
2000 10,000 mustang 2,000 2000 12,000 corvet 4,000
Thanks
<?xml version="1.0" standalone="yes"?> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="vfffg"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e1"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e2"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="CarModel" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1"> <xs:selector xpath=".//vfffg" /> <xs:field xpath="ID" /> </xs:unique> <xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:unique> <xs:keyref name="e1" refer="e1_Constraint1"> <xs:selector xpath=".//e2" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:keyref> <xs:keyref name="e0" refer="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> </xs:keyref> </xs:element> </xs:schema>
Joe,
See this sample on our website, I see you uses C#, but is should be to
translate easy http://www.vb-tips.com/default.aspx?...3-8a9529b2b38b
I hope this helps,
Cor
"Joe" <hc******@yahoo.com> schreef in bericht
news:u2**************@tk2msftngp13.phx.gbl... Hi
I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file
I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd or Is there another alternative???
Currently
Table1 2000 10,000 2001 12,000
Table2 2000 mustang 2,000 2000 corvet 4,000
What I want
2000 10,000 mustang 2,000 2000 12,000 corvet 4,000
Thanks
<?xml version="1.0" standalone="yes"?> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="vfffg"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e1"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e2"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="CarModel" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1"> <xs:selector xpath=".//vfffg" /> <xs:field xpath="ID" /> </xs:unique> <xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:unique> <xs:keyref name="e1" refer="e1_Constraint1"> <xs:selector xpath=".//e2" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:keyref> <xs:keyref name="e0" refer="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> </xs:keyref> </xs:element> </xs:schema> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jade |
last post by:
Hi, I am trying to create a dataset with 6 tables and 5 relationships created between them. I am creating it in the Form_Load event. However i keep getting the following error...
An unhandled...
|
by: suzy |
last post by:
hello.
how can i sort data in a dataset? all the examples i have seen on msdn, etc
are sorting a dataview. this works fine, but i want to return the results
in xml and the dataview doesn't...
|
by: Dennis |
last post by:
Hi, I am hoping I can get some help with a small problem I have run
into using C#. U have an XML file that I load into a Dataset and then
display this in a Datagrid. No problems doing this at all....
|
by: George Durzi |
last post by:
I have a DataSet with 3 tables, and two DataRelations
dsSubs.Tables.TableName = "Subscriptions"
dsSubs.Tables.TableName = "AccountManagers"
dsSubs.Relations.Add
"AccountManagers_Subscriptions",...
|
by: DaveF |
last post by:
How can I retrieve display_names
Dim custDS As DataSet = New DataSet
Dim mySQL, mySQL2, mySQL3 As String
|
by: cindy |
last post by:
Get data into datatable, add to dataset dsSearch "
Get data into datatable, add to dataset dsSearch
Using In-Memory SQL Engine join the tables and select the filenames from the
join, add to...
|
by: Gary |
last post by:
I have a DataSet where two tables have a relation (the
parent / child relationship is also successfully added to
the DataSet Relations collection). I am looking for a
way to programmatically...
|
by: Geoff Jones |
last post by:
Hi
Can anybody help me with the following, hopefully simple, question?
I have a table which I've connected to a dataset. I wish to add a new column
to the beginning of the table
and to fill...
|
by: Joe |
last post by:
Hi
I have a dataset with 3 tables and 2 relations
Is there a way to when I am at 1 row to tell if there is a relation on that
row ???
I have the code hardcoded but try to make it work if the #...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |