combine a few xml files

[PZWU]

How can I build a big XML file by appending a few smaller
xml files in C#?

Below is what I've been trying:
/* FileString.xml is the path and name string of the big
xml file*/
XmlTextWriter writer = new XmlTextWriter (FileString,
System.Text.Enc oding.UTF8);
writer.WriteSta rtDocument();
writer.WriteSta rtElement("Fund XML");
/*p_FundOperatio nFileName is the string name of a smaller
xml file saved under d:\\xml\\FundOp erationXML directory */
string Text = AppendXMLFile
(p_FundOperatio nFileName, "d:\\xml\\FundO perationXML");
writer.WriteStr ing(Text);
writer.WriteEnd Element();
writer.Flush();
writer.Close();

in function AppendXMLFile:
string strfile = path +"\\"+filena me;
string s = "?>";
try
{
StreamReader sr = new StreamReader(st rfile);
String line;
/*while loop removes <?xml version="1.0" encoding="utf-8" ?

from the xml file and return the rest as string append

to the big xml file*/
while ((line = sr.ReadLine()) != null)
{
int idx = line.IndexOf(s) ;
sr.Close();
return line.Substring( idx+2);
}
}
catch (Exception e)
{
Console.WriteLi ne(e.Message);
}

The big XML constructed this way is not "well formed" if
open it in xmlspy and xslt couldn't retrieve info from it
if it's loaded as xslt source xml file.

Please help and thanks in advance.

[William Ryan]

Do all of the documents have the same schema? If so, you can create a
Dataset and use its ReadXml method. Do it for all three tables. If they
all have the same structure, they should all load. Then use WriteXML to
your given path.

HTH,

Bill
"PZWU" <an*******@disc ussions.microso ft.com> wrote in message
news:05******** *************** *****@phx.gbl.. .

How can I build a big XML file by appending a few smaller
xml files in C#?

Below is what I've been trying:
/* FileString.xml is the path and name string of the big
xml file*/
XmlTextWriter writer = new XmlTextWriter (FileString,
System.Text.Enc oding.UTF8);
writer.WriteSta rtDocument();
writer.WriteSta rtElement("Fund XML");
/*p_FundOperatio nFileName is the string name of a smaller
xml file saved under d:\\xml\\FundOp erationXML directory */
string Text = AppendXMLFile
(p_FundOperatio nFileName, "d:\\xml\\FundO perationXML");
writer.WriteStr ing(Text);
writer.WriteEnd Element();
writer.Flush();
writer.Close();

in function AppendXMLFile:
string strfile = path +"\\"+filena me;
string s = "?>";
try
{
StreamReader sr = new StreamReader(st rfile);
String line;
/*while loop removes <?xml version="1.0" encoding="utf-8" ?

from the xml file and return the rest as string append

to the big xml file*/
while ((line = sr.ReadLine()) != null)
{
int idx = line.IndexOf(s) ;
sr.Close();
return line.Substring( idx+2);
}
}
catch (Exception e)
{
Console.WriteLi ne(e.Message);
}

The big XML constructed this way is not "well formed" if
open it in xmlspy and xslt couldn't retrieve info from it
if it's loaded as xslt source xml file.

Please help and thanks in advance.

[pzwu]

Thanks Bill!
The six files combine to form a big file containing full
information about a specific mutual fund. Each smaller
file has different content therefore different schema.
Peter

-----Original Message-----
Do all of the documents have the same schema? If so, you can create aDataset and use its ReadXml method. Do it for all three tables. If theyall have the same structure, they should all load. Then use WriteXML toyour given path.

HTH,

Bill
"PZWU" <an*******@disc ussions.microso ft.com> wrote in messagenews:05******* *************** ******@phx.gbl. ..

How can I build a big XML file by appending a few smaller

xml files in C#?

Below is what I've been trying:
/* FileString.xml is the path and name string of the big
xml file*/
XmlTextWriter writer = new XmlTextWriter (FileString,
System.Text.Enc oding.UTF8);
writer.WriteSta rtDocument();
writer.WriteSta rtElement("Fund XML");
/*p_FundOperatio nFileName is the string name of a smaller xml file saved under d:\\xml\\FundOp erationXML directory */ string Text = AppendXMLFile
(p_FundOperatio nFileName, "d:\\xml\\FundO perationXML");
writer.WriteStr ing(Text);
writer.WriteEnd Element();
writer.Flush();
writer.Close();

in function AppendXMLFile:
string strfile = path +"\\"+filena me;
string s = "?>";
try
{
StreamReader sr = new StreamReader(st rfile);
String line;
/*while loop removes <?xml version="1.0" encoding="utf- 8" ?

> from the xml file and return the rest as string append

to the big xml file*/
while ((line = sr.ReadLine()) != null)
{
int idx = line.IndexOf(s) ;
sr.Close();
return line.Substring( idx+2);
}
}
catch (Exception e)
{
Console.WriteLi ne(e.Message);
}

The big XML constructed this way is not "well formed" if
open it in xmlspy and xslt couldn't retrieve info from

it if it's loaded as xslt source xml file.

Please help and thanks in advance.

.

[William Ryan]

If they have a common column, then check out DataRelations. If you use
these, then they'll be included as well.
"pzwu" <an*******@disc ussions.microso ft.com> wrote in message
news:06******** *************** *****@phx.gbl.. .

Thanks Bill!
The six files combine to form a big file containing full
information about a specific mutual fund. Each smaller
file has different content therefore different schema.
Peter

-----Original Message-----
Do all of the documents have the same schema? If so, you

can create a

Dataset and use its ReadXml method. Do it for all three

tables. If they

all have the same structure, they should all load. Then

use WriteXML to

your given path.

HTH,

Bill
"PZWU" <an*******@disc ussions.microso ft.com> wrote in

message

news:05******* *************** ******@phx.gbl. ..

How can I build a big XML file by appending a few smaller xml files in C#?

Below is what I've been trying:
/* FileString.xml is the path and name string of the big
xml file*/
XmlTextWriter writer = new XmlTextWriter (FileString,
System.Text.Enc oding.UTF8);
writer.WriteSta rtDocument();
writer.WriteSta rtElement("Fund XML");
/*p_FundOperatio nFileName is the string name of a smaller xml file saved under d:\\xml\\FundOp erationXML directory */ string Text = AppendXMLFile
(p_FundOperatio nFileName, "d:\\xml\\FundO perationXML");
writer.WriteStr ing(Text);
writer.WriteEnd Element();
writer.Flush();
writer.Close();

in function AppendXMLFile:
string strfile = path +"\\"+filena me;
string s = "?>";
try
{
StreamReader sr = new StreamReader(st rfile);
String line;
/*while loop removes <?xml version="1.0" encoding="utf- 8" ? > from the xml file and return the rest as string append
to the big xml file*/
while ((line = sr.ReadLine()) != null)
{
int idx = line.IndexOf(s) ;
sr.Close();
return line.Substring( idx+2);
}
}
catch (Exception e)
{
Console.WriteLi ne(e.Message);
}

The big XML constructed this way is not "well formed" if
open it in xmlspy and xslt couldn't retrieve info from it if it's loaded as xslt source xml file.

Please help and thanks in advance.

.

[pzwu]

Bill,
There are no common columns between files. What I'm trying
to do is just creating a xml file with the following form:
<?xml version="1.0" encoding="utf-8?>
<fundxml>
<content of file1 without the xml header>
<content of file2 without the xml header>
<content of file3 without the xml header>
<content of file4 without the xml header>
<content of file5 without the xml header>
<content of file6 without the xml header>
</fundxml>
Here "xml header" refers to <?xml version="1.0"
encoding="utf-8?>
Thanks for your help.
Peter

-----Original Message-----
If they have a common column, then check out DataRelations. If you usethese, then they'll be included as well.
"pzwu" <an*******@disc ussions.microso ft.com> wrote in messagenews:06******* *************** ******@phx.gbl. ..

Thanks Bill!
The six files combine to form a big file containing full
information about a specific mutual fund. Each smaller
file has different content therefore different schema.
Peter

>-----Original Message-----
>Do all of the documents have the same schema? If so, you

can create a

>Dataset and use its ReadXml method. Do it for all

three tables. If they

>all have the same structure, they should all load.

Then use WriteXML to

>your given path.
>
>HTH,
>
>Bill
>"PZWU" <an*******@disc ussions.microso ft.com> wrote in

message

>news:05******* *************** ******@phx.gbl. ..
>> How can I build a big XML file by appending a few

smaller

>> xml files in C#?
>>
>> Below is what I've been trying:
>> /* FileString.xml is the path and name string of the

big >> xml file*/
>> XmlTextWriter writer = new XmlTextWriter (FileString,
>> System.Text.Enc oding.UTF8);
>> writer.WriteSta rtDocument();
>> writer.WriteSta rtElement("Fund XML");
>> /*p_FundOperatio nFileName is the string name of a

smaller

>> xml file saved under d:\\xml\\FundOp erationXML

directory */

>> string Text = AppendXMLFile
>> (p_FundOperatio nFileName, "d:\\xml\\FundO perationXML"); >> writer.WriteStr ing(Text);
>> writer.WriteEnd Element();
>> writer.Flush();
>> writer.Close();
>>
>> in function AppendXMLFile:
>> string strfile = path +"\\"+filena me;
>> string s = "?>";
>> try
>> {
>> StreamReader sr = new StreamReader(st rfile);
>> String line;
>> /*while loop removes > >> > from the xml file and return the rest as string append >> to the big xml file*/
>> while ((line = sr.ReadLine()) != null)
>> {
>> int idx = line.IndexOf(s) ;
>> sr.Close();
>> return line.Substring( idx+2);
>> }
>> }
>> catch (Exception e)
>> {
>> Console.WriteLi ne(e.Message);
>> }
>>
>> The big XML constructed this way is not "well formed" if >> open it in xmlspy and xslt couldn't retrieve info

from it

>> if it's loaded as xslt source xml file.
>>
>> Please help and thanks in advance.
>>
>>
>>
>
>
>.
>

.