Many-To-Many DataSet as XML document - XML / XSL Discussion Boards

I hope this isn't a dumb question.

I am working on an ASP .NET web application that will take a lot (thousands and thousands) of PDF files and allow users to search for a file/group of files and display them on the web page. Then the user can click the one they want and open it.

There are so many files that I don't want to access the directory structure every time someone searches for a file. So my question is this - should I store the file names/paths in a database or should I maybe use some sort of XML file? I would update it once a day or so. I have never really worked with XML before and was wondering if this would be a good application for it. Thank you for any ideas.

dreamaway820 wrote:
will take a lot (thousands and thousands)

dreamaway820 wrote:
should I store the file names/paths in a database or should I maybe use some sort of XML file?

Database

led mike

Definately a database.

Scott.

—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

[Forum Guidelines] [Articles] [Blog]

Yes, a database. Of course that database may be XML... Big Grin | :-D

I do a similar thing, with a Windows Service periodically looking for new files to add to the index.

I have 2 text box Controls on form and i have to save the contents entered into this in XML file. When i enter text through keyboad into this two text box, these are saved into XML file. But When i want to save File path( like C:\xyz\patient.bmp ) which is returned by openFileDialogBox control, this path can't be save into XML file.
Where is the problem.

I have to set any Textbox property or XML can't save this type of format?. then to save this format any Type casting is reqiured in XML?

Code is like this

XmlNode^ imgnode = doc->CreateNode(XmlNodeType::Element,"imgFile","");
imgnode ->InnerText = txtimageFile->Text;
node->AppendChild(imgnode);

When I debug it, Imagefile text box contain text like;

txtimageFile->Text = “C:\xyz\patient.bmp”

this path is not save into XML file. It is not giving any error while saving.
If you enter normal text through keyboard ( like patient details), it will save. Then what's the problem.?

Please reply

I cannot reproduce the problem. This likely means it is due to a bug of your own making.

led mike

Do you save the XML document?

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!

// sproc returns a dataset containing three tables
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;
//ea2.Nested = true; // Do I need this?
					
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.

Sunrise Wallpaper Project | The StartPage Randomizer | The Windows Cheerleader

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 Big Grin | :-D

,

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 Frown | :(

! 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?
Confused | :confused:

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