|
Let's say I have 3 tables which are Users, Groups and UserGroup, where a user can be a member of multiple groups and a group can obviously contain multiple users. The UserGroup table is simply a 2 column table that maintains the many-to-many relationship within the database, and this all works perfectly.
--------- ------------- ----------
| Users | 1 ----- many | UserGroup | many ----- 1 | Groups |
--------- ------------- ----------
When I attempt to load these three tables into an XML document (via a dataset) it fails with an error saying "A child row has multiple parents" - presumably because the link table (UserGroup) contains duplicate UserID's and GroupID's (Which it should!). I've tried adding an artificial primary key to the UserGroup table, but it still doesn't work.
The current code is below, and a sample of the output that I would like is also provided. What do I need to do to get this to work correctly? I've been Googling all morning, but I can't seem to find anything with an actual answer!
SqlDataAdapter da = new SqlDataAdapter( "sproc", connection );
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
da.Fill(ds);
ds.Tables[0].TableName = "User";
ds.Tables[1].TableName = "Group";
ds.Tables[2].TableName = "UserGroup";
DataRelation ea1 = ds.Relations.Add(
ds.Tables["User"].Columns["UserID"],
ds.Tables["UserGroup"].Columns["UserID"],
false);
DataRelation ea2 = ds.Relations.Add(
ds.Tables["Group"].Columns["GroupID"],
ds.Tables["UserGroup"].Columns["GroupID"],
false);
ea1.Nested = true;
XmlDataDocument doc = new XmlDataDocument(ds);
I'm looking for something like this:
<Groups>
<Group>
<GroupName>Astronauts</GroupName>
<Users>
<Name>Neil Armstrong</Name>
<Name>Buzz Aldrin</Name>
<Name>Yuri Gagarin</Name>
<Users>
</Group>
<Group>
<GroupName>Americans</GroupName>
<Users>
<Name>Neil Armstrong</Name>
<Name>Buzz Aldrin</Name>
</Users>
</Group>
</Groups>
Does anyone know how to do this (or something very similar)? It would be greatly appreciated!
Thank you.
|
|
|
|
|
hi
i am new to PMML(Preditive model markup langauge).
i am not getting how to write PMML Data in xml using vc++.
could you please any one.
|
|
|
|
|
From the wikipedia page on PMML
PMML is an <a href="http://en.wikipedia.org/wiki/XML" title="XML">XML</a>-based language This is key because your question then has nothing to do with PMML. Your problem is you don't know how to work with XML. That is a significant sized problem making it a poor candidate for a question on an internet forum. There is no easy copy/paste solution for you. The reality is you will have to dig into learning XML and it's related technologies to accomplish your project.
For using VC++ the MSDN Web site will contain much information including tutorials and example code. Other major resources are the two web sites TopXML and www.w3schools.com. On all these sites you will find that one very common technique for working with XML in VC++ is to use the COM component MSXML.
Good luck
led mike
|
|
|
|
|
Hi everyone  ,
I have a really big question about editing large XML files. Im building a little XML Database engine (like a mini database engine using xml as a storage). I can create tables and select data from them.
My question is: since the XmlDocument class loads the entire xml data into memory and data files could take longer than 100 MB, Which is the best way to modify data on large XML files?
For example:
If i have the next XML file:
<invoices>
<invoice id="1">
<amount>100,000.00</amount>
<currency>Dolar</currency>
<refnum1>9486692001</refnum1>
<refnum2>NULL</refnum2>
<createdate>2008-05-19 4:21:34.532 PM</createdate>
</invoice>
...
</invoices>
And that file has like 500.000 rows on it, how can i modify the value of the single node 'RefNum2' where the invoice id is '1' without using the XmlDocument class?
I know i can use the XPathNavigator using the xpath string 'Invoices/Invoice[@id="1"]' but how can i set the value and save the file?
This is driving me nuts  ! haha
modified on Monday, May 19, 2008 6:59 PM
|
|
|
|
|
The core issue is probably that you'd be better off using a database.
Is there a SAX implimentation in .NET ? I'd think that's whaty ou need.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi all! Using MSXML 6.
1. So I have a DOM. I add CDATA section. I save. I get xml with <a><CDATA[[my data here]]></a> in it but no indentation. - we know DOM doesn't "pretty print". Ok.
2. Now I add ISAXXMLReader/IMXWriter pair to handle formatting of my output xml from DOM and get indentation but CDATA section declaration is lost.
I mean in the out put I get: <a>my data here</a>
So how do I keep CDATA section declaration? Who losses it? The writer? The reader that reads DOM?
Thanks a lot in advance!
|
|
|
|
|
Hi guys,
i want to validate the xml file using DTD in C#.net. can u send me the sample C#.net code to validate the xml file
Cheers
velu
d.sengottuvelu
|
|
|
|
|
When validating an XML file against an schema using an XMLReader we get errors of the following format
The 'MobilePhone' element has an invalid value according to its data type. An error occurred at file:///C:/temp/test.xml, (508588, 3).
I was wondering if it was somehow possible to use the ValidationEventHandler to get an XPath to the element that had failed as the line number/column is not very helpful or is there a different technique that would allow us to get the same?
|
|
|
|
|
I have a html page which Returns me some responce xml. I want to extract nodes and their values from this xml using JavaScript and store them in excel file. Can anyone help me out?
|
|
|
|
|
Please rReply if anyone can help in this.........
|
|
|
|
|
JayPrakash Kulkarni wrote: Can anyone help me out?
Sure. Hire a programmer and they can help you out
led mike
|
|
|
|
|
Hi,
I'm using an xml and xslt files as UI interface for mfc application.
One of the issues I'm trying to solve is image size in html document. Some of the html pages display external images and I can't control the image size (in the xml I have the image width and height). Although I can specify the width and height to display, not keeping the right ratio distorts the image. So, I wrote an xslt function to calculate the size to use. I kept getting the error "Namespace 'http://whatever' does not contain any functions." (sample from http://www.xml.com/lpt/a/1278[^] until I've found in the net the cause: IE7 doesn't supprt xslt 2.0.
As I see it, I have two options:
1. Find out what needed to support xslt 2.0 in IE.
2. Use MFC function from within the xsl file.
Do you see other options? please advice...
Thanks,
Yariv
|
|
|
|
|
I am facing a issue while parsing CDATA value through ISAXXMLReader.
can anybody guide me for the same
|
|
|
|
|
Hi..
I'm Using Asp.Net with C#..
I want to Generate HTML Reports in C# with XML Data..
This is my XML Data(xml_Data.xml)
<Page_Details>
<Log Page="show_Page.aspx" Time="07:05:07:32636" Type="Master" ID="1" />
<Log Page="show_Page.aspx" Time="08:10:20:32636" Type="Master" ID="2" />
<Log Page="show_Page.aspx" Time="09:15:20:32636" Type="Master" ID="1"/>
<Log Page="show_Page.aspx" Time="05:20:45:32636" Type="Master" ID="3"/>
</Page_Details>
Please give me the Suggestions in doing this..
Thank You..
|
|
|
|
|
A popular approach would be to use XSLT[^]
led mike
|
|
|
|
|
Hi,
I am suggesting best for XSLT. This will helpful for quick learning.
http://www.zvon.org/xxl/XSLTutorial/Books/Book1/index.html
Regards,
--XSLT team.
modified on Monday, May 19, 2008 9:22 AM
|
|
|
|
|
shakeela wrote: XSLT team.
Say what ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
I am trying to search for every <author> element that may contain content
such as 'Vignesh'. but there are some potential problems with it.
It only searches the first child of <file> named <author> and never
goes to the second child <author>. IF i search for 'Diaz' or 'Krish', It returns record but for 'Vignesh' and 'Tomy', it does not return record. Is there any logic to search for second child node?Please give me some idea. Any help with this will be greatly appreciated.
I faced formating problem to post xml file so it looks like this hope you dont mind.
document
file
author Diaz John author
author Vignesh Mehta author
/file
file
author Krish P author
author Tomy M. author
/file
/document
Thanks
KP
|
|
|
|
|
kmpatel wrote: It only searches
It? Sorry but that doesn't tell us anything useful.
kmpatel wrote: I faced formating problem to post xml file so it looks like this hope you dont mind.
On the screen where you post there is a checkbox "Ignore HTML tags in this message (good for code snippets)"
led mike
|
|
|
|
|
I have an XML Schema that i would like to use BulkLoad 4.0 SchemaGen to create the tables in an SQL 2005 Database. I get the error "Schema: the parent/child table of the relationship on 'Listings' does not match." Code for the Schema is as follows:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://platform.point2.com/schemas/2.0/listingDataFeed" xmlns="http://platform.point2.com/schemas/2.0/listingDataFeed" elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="Test"
parent="ListingDataFeed"
parent-key="Listings_Id"
child="Listings"
child-key="Listings_Id"
inverse="true"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="ListingDataFeed" type="data" sql:relation="ListingsDataFeed"
sql:key-fields="Listings_Id"/>
<xs:complexType name="data">
<xs:sequence>
<xs:element name="PublishDate" type="xs:dateTime"/>
<xs:element name="DocumentationUrl" type="xs:string"/>
<xs:element name="Disclaimer" type="xs:string"/>
<xs:element name="Copyright" type="xs:string"/>
<xs:element name="Listings" type="listings" minOccurs="0" sql:relation="Listings"
sql:key-fields="Listings_Id"
sql:relationship="Test"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="listings">
<xs:sequence>
<xs:element name="Listing" type="listing" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
All of the code defining relationships is what I have added to the Schema that i received in an attempt to set proper relationships to "Listings". There is further XML code for the "listing" data, but i'm pretty sure that the problem is in the code above. Any help would be really appreciated, Thanks!
Pieter.
|
|
|
|
|
Hi friends,
I have an XML file, and it has XSL file that is applied for formatting data contained in xml. Now I WANT TO SAVE THE XML FILE AS AN HTML FILE, but the content and styles should not be lost. Thats what my problem is.
when i m saving the xml file as an html, its all styles are lost, and it saves only plain text.
So please if u have any solution for that, pls provide me that, as soon as possible.
Thanks in advance.
|
|
|
|
|
xml, html, and xsl files are only plain text. It sounds to me like what you mean is, you used newlines to generate breaks in your text file and you need to change your XSL to instead add br tags, so you emit HTML.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello,
I have a group called GroupX and it contains several brands. Those brands contain products and those products have two values: their price and their product number. Now I want to store this in a XML file, and I know that I have to use System.XML but I just can't find out on how to store, read and modify this data using XML. I've searched the internet, but didn't find what I was looking for.. I am using Visual Basic with Visual Studio 2005.
Please help me out, 
--Zaegra--
|
|
|
|
|
Is this in a database or do you want to create the xmlDocument in Visual Basic from a text file or something?
|
|
|
|
|
Zaegra wrote: I've searched the internet
I find that hard to believe.
There is a myriad of ways to store XML, the easiest is to use a stringbuilder to build your XML by hand, but that is more error prone than using XMLDocument or the XMLStreamWriter ( not sure what that is called ). XMLDocument is a standard DOM implimentation, it's how you would read/modify an XML document.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
