XmlDocument Write problems and Add Identation Help! - C# Discussion Boards

Hi I have done a program such that the program asks for a xml schema file. Then we have to give out the schema file. the program reads the schema file (for all field names) and according to their datatypes, it automatically creates data's for each fields in a new xml file(about 200 data's).

For example:
"FIRST XML FILE"
for string datatype -> say field name "Name( john1,john2,john3...etc)" for about 200 values
for decimal -> say field name "Salary(9120.88, 9120.89, 9120.90 ..etc)" for about 200 values.This will be our resultant xml.

Leave this apart.
"SECOND XML FILE"
Now we have another xml file with some field name and data's seperately.
This has about 200 values for each field.
In this xml file we have a fieldname called "Name".

So what I want to do is , that coming to my program , My program while reading the schema file , when it comes across the fieldname "Name" then it should read the "SECOND XML FILE" and copy the fieldname "Name" (ie, its data's ) and insert the values into the "FIRST XML FILE" field name "Name". The others should be the same.

This is my requirement.
I tried a lot but i couldnt suceed. Pls help me to do this.

santhosh

I think I understand a little bit better now, however, I still need some clarification. Here's what I think you're saying--You have a schema file and two XML files. While you are iterating through the fields in the schema, you want to look up the current field in the second xml file and copy the data to a field in the first xml file. Is that correct?

I'll assume it is for a moment. There is a method on the XmlElement object called SelectSingleNode. This method uses XPath to allow you to select a single node based on a query criteria somewhat similar to a SQL query. Here is an example from the Microsoft site:

using System;
using System.IO;
using System.Xml;

public class Sample
{
public static void Main()
{

XmlDocument doc = new XmlDocument();
doc.Load("booksort.xml");

//Create an XmlNamespaceManager for resolving namespaces.
XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.NameTable);
nsmgr.AddNamespace("bk", "urn:samples");

//Select the book node with the matching attribute value.
XmlNode book;
XmlElement root = doc.DocumentElement;
book = root.SelectSingleNode("descendant::book[@bk:ISBN='1-861001-57-6']", nsmgr);

Console.WriteLine(book.OuterXml);

}
}

And here is the related XML file:

<?xml version="1.0"?>

<bookstore xmlns:bk="urn:samples">
<book genre="novel" publicationdate="1997" bk:ISBN="1-861001-57-8">
<title>Pride And Prejudice</title>
<author>
<first-name>Jane</first-name>
<last-name>Austen</last-name>
</author>
<price>24.95</price>
</book>
<book genre="novel" publicationdate="1992" bk:ISBN="1-861002-30-1">
<title>The Handmaid's Tale</title>
<author>
<first-name>Margaret</first-name>
<last-name>Atwood</last-name>
</author>
<price>29.95</price>
</book>
<book genre="novel" publicationdate="1991" bk:ISBN="1-861001-57-6">
<title>Emma</title>
<author>
<first-name>Jane</first-name>
<last-name>Austen</last-name>
</author>
<price>19.95</price>
</book>
<book genre="novel" publicationdate="1982" bk:ISBN="1-861001-45-3">
<title>Sense and Sensibility</title>
<author>
<first-name>Jane</first-name>
<last-name>Austen</last-name>
</author>
<price>19.95</price>
</book>
</bookstore>

I'm not sure if this is going to help you or not, but if I understand your correctly, then you should be able to get the node you're looking for using this method on the first XML file. The key is that you will have to now what you're looking for.

Let me know if I've missed the boat completely here and if so, just clarify what you are trying to do.

Best Regards.

-Matt

p.s. Here is a link to the documentation I got the code from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemXmlXmlNodeClassSelectSingleNodeTopic.asp .

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Hi I have done a program in c# such that , my program reads a schema file and automatically loads data into a xml file.

ex:we hav e a text box where we give a schema file.
let us give the following schena file
consider the following schema

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns:xs="http://://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:Locale="en-AU">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="vw_forecast">
<xs:complexType>
<xs:sequence>
<xs:element name="billto_name" type="xs:string" minOccurs="0" />
<xs:element name="dividend" type="xs:float" minOccurs="0" />
<xs:element name="section" type="xs:double" minOccurs="0" />

</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
</NewDataSet>

We can see that there are three fields namely billto_name, dividend and section.
-------------------------------------------------------------------------
we have another textbox, where we give a path and a newname xml file . where we get the result.
after giving giving the path where we want to save and the new xml file name and we click a button named load. then values get loaded into the new xml file automatically

so my program reads this schema file and loads data automatically by obtaining the following xml file

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<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:Locale="en-AU">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="vw_forecast">
<xs:complexType>
<xs:sequence>
<xs:element name="billto_name" type="xs:string" minOccurs="0" />
<xs:element name="dividend" type="xs:float" minOccurs="0" />
<xs:element name="section" type="xs:double" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<vw_forecast>
<billto_name>Castle Hampers0</billto_name>
<dividend>4.5</dividend>
<section>888888</section>
</vw_forecast>
<vw_forecast>
<billto_name>Castle Hampers1</billto_name>
<dividend>5.5</dividend>
<section>888889</section>
</vw_forecast>
<vw_forecast>
<billto_name>Castle Hampers2</billto_name>
<dividend>6.5</dividend>
<section>888888</section>
</vw_forecast>
<vw_forecast>
<billto_name>Castle Hampers3</billto_name>
<dividend>7.5</dividend>
<section>8888890</section>
</vw_forecast>
<vw_forecast>
<billto_name>Castle Hampers4</billto_name>
<dividend>8.5</dividend>
<section>888891</section>
</vw_forecast>

</NewDataSet>

we can see the values as castlehampers1,..2..3..4..so on for string datatype and 4.5,5.5,6.5...so on for float..etc...

-----------------------------------------------------------------------

Now my requirement is that I have another xml file in the project directory with a single field name "billto_name". with some meaningful values. So I have to program such that if the schema contains a "billto_name" field then load data's from this xml where we have meaninful fields into the result xml. ie, the previous xml here we obtained data's automatically.
ie, values for billto_name should chanege whereas others should remain unchanged.

this is the xml file with meaninful values. so we should read the values of billto_name from here and load it into the above xml for that particular field.

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<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:Locale="en-AU">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="billtoname">
<xs:complexType>
<xs:sequence>
<xs:element name="billto_name" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<billtoname>
<billto_name>ACCOUNTS CODES ONLY</billto_name>
</billtoname>
<billtoname>
<billto_name>ACCOUNTS CODES ONLY</billto_name>
</billtoname>
<billtoname>
<billto_name>AERIAL PRODUCT RANGE</billto_name>
</billtoname>
<billtoname>
<billto_name>AFL LICENCED PRODUCT</billto_name>
</billtoname>
<billtoname>
<billto_name>AUST RUGBY UNION</billto_name>
</billtoname>
</NewDataSet>

so the values such as AUST RUGBY UNION , AFL LICENCED PRODUCT EVERYTHING SHOUYLD BE INSERTED INTO THE PREVIOUS XML FILE FOR THAT FIELD ALONE.

This is my requirement. I tried a lot but i couldnt suceed

my coding for automatic loading of values is as follows. pls chaneg and sent , as I need this very urgently.

------------------------------------------------------------------
private void button2_Click(object sender, System.EventArgs e)
{
dataSet1.ReadXmlSchema(txtSchema.Text);
//*******txtschema.text is the schema file which we pass
foreach (DataTable dTbl in dataSet2.Tables)
{
object[] oValues = new object[dTbl.Columns.Count];
int i = 0;
foreach (DataColumn dColmn in dTbl.Columns)
{
switch(dColmn.DataType.ToString())
{
case "System.String":
oValues[i] = (string) "sachin" + j;
break;

case "System.Int32":
oValues[i] = (int) 100 + j;
break;
case "System.DateTime":
oValues[i] = new DateTime(2004,01,30).AddDays(j * 1);
break;
case "System.Decimal":
oValues[i] = new Decimal(10000900.99) + j;
break;
}
i += 1;
}
dTbl.Rows.Add(oValues);
}
}
}

private void button3_Click(object sender, System.EventArgs e)
{
dataSet2.WriteXml(txtXml.Text, XmlWriteMode.IgnoreSchema );
//***txtxml.text is the xml file which we obtain as the result
MessageBox.Show("Saved");
}

santhosh

Hello all,

I need to return more than one Value from methon.how can i do this pleas help

Regards
hay

Take a look at the ref[^] and out[^] message parameter keywords.

www.troschuetz.de

Usually, if you find yourself in such a need you should reexamine your code and check if it would be better to have a new class to combine and manage the data that you want to be returned.
If this is not the case you can always use the "ref" statement as mentioned in the reply above.

If you mean to say you might return a string OR an integer as that methods output. You can either
a. Return a structure containing both these thing and at runtime one of them will be null OR
b. return the base class object in the function signature and at runtime it can be either of the derived class objects at runtime.

Option b is cleaner.

If you mean to say you have two values to return from a function in each run use the ref or out keywords to mark those function parameters as modifiable/return values.

Salil Khedkar [^]

Hi there,

I have 2 questions to ask.

1) I have this code...

XmlDocument doc = new XmlDocument();
doc.Load(myXmlPath);

int maxValue = 0;
int newValue = 0;

XmlNodeList nodeList = doc.SelectNodes("//Product");

foreach (XmlNode node in nodeList)
maxValue = XmlConvert.ToInt32(node.Attributes["id"].Value);

XmlElement newElem = doc.CreateElement("Product");
newValue = maxValue + 1;
XmlAttribute newAttr = doc.CreateAttribute("id");
newAttr.Value = newValue.ToString();
newElem.Attributes.Append(newAttr);

doc.DocumentElement.AppendChild(newElem);
XmlElement elem = doc.CreateElement("Description");
elem.InnerText = "JVC Camera";
doc.DocumentElement.AppendChild(elem);

XmlTextWriter wrtr = new XmlTextWriter(myXmlPath, Encoding.UTF8);
doc.WriteTo(wrtr);
wrtr.Close();

Xml (Before) // xml has identation nicely
----------------
<?xml version="1.0" encoding="utf-8"?>
<ProductList>
<Product id="1">
<Description>Panasonic Camcorder</Description>
</Product>
</ProductList>

Xml(After) // xml has no identation
--------------
<?xml version="1.0" encoding="utf-8"?>
<ProductList>
<Product id="1">
<Description>Panasonic Camcorder</Description>
</Product>
<Product id="2" />
<Description>JVC Camera</Description>
</ProductList>

Xml (Expected this)
-----------------------
<?xml version="1.0" encoding="utf-8"?>
<ProductList>
<Product id="1">
<Description>Panosonic Camcorder</Description>
</Product>
<Product id="2">
<Description>JVC Camera</Description>
</Product>
</ProductList>

Note: I want the Second Description tag to be part of Product id="2", but with my C# codes, i can't achieve it.

2)

After i perform the C# code on top, my codes has no more identation. It seems that it removes all the whitespaces to this. (Please take note, the above xml examples, i manually re-arrange the generated xml for clear view).

Xml (After)
--------------
<?xml version="1.0" encoding="utf-8"?><ProductList><Product id="1"><Description>Panasonic Camcorder</Description></Product><Product id="2" /><Description>JVC Camera</Description></ProductList>

I hope i can indent nicely, just like what i did above on original xml file.

Any help please?
--
Regards,
Chua Wen Ching
Visit us at http://www.necoders.com

Regards,
Chua Wen Ching
Visit us at http://www.necoders.com

I use this way:

after the XmlTextWriter initialization put this code:

wrtr.Formatting = Formatting.Indented;

so the code block looks like this

XmlTextWriter wrtr = new XmlTextWriter(myXmlPath, Encoding.UTF8);
wrtr.Formatting = Formatting.Indented;

stan_fisher™ [www.aeroxp.net]

As for part 2 of your question, you are appending both new nodes to the doc.DocumentElement node whereas what you want is to create the Product node, append that to the DocumentElement and then append the description node as a child to the newly created Product node.

Hi,

Thanks Stanimir_Stoyanov and J4amieC.

I got it right already with your suggestions. Cheers.

Regards,
Chua Wen Ching
Visit us at http://www.necoders.com

Hi.
I have a list view with about 4000 items (with 7 subitems, too) and I'd like to 'export', ie. save all the data, to a tab-separated file, so the data can be reloaded later. The problem is, that the saving and loading process using, for example:

(Save)

(...)
foreach(ListViewItem lvi in this.listView1.Items)
{
string line = "";

line += lvi.Text;
for(int i=1;i

Hi, what you want to do is called serialization. Serialization is saving an object's state to a stream so its state can be transported or saved and later restored.

You suggested a tab separated text file, which is nice since the file is easily read and understood by other applications, however binary files are faster. If format don't mattter to you, I would suggest binary format.

BinaryFormatter.Serialize Method is the method you use for binary serialization. The problem will be for you that a listview control or ListViewItemCollection object do not support serialization. To be able to serialize an object, the object's class needs to be either marked with the Serializable attribute or implement the ISerializable interface.

The class ArrayList however is marked Serializable attribute and it's pretty easy to construct an arraylist from a listview control.

Good luck and feel free to check my C# blog,
Patric

i would like to print directly without preview the report.

This is the code that i have written.
//BEGIN CODE
// Declare the variables
TableLogOnInfo logOnInfo = new TableLogOnInfo ();
int i = 0;
ReportDocument report = new ReportDocument();
report.Load("EtatEcheancier.rpt");
Parametres.Configuration.Database mainD =
Parametres.Configuration.Database.MainDatabase;
while(i <= (report.Database.Tables.Count - 1))
{
logOnInfo = report.Database.Tables[i].LogOnInfo;
logOnInfo.ConnectionInfo.ServerName = mainD.Serveur;
logOnInfo.ConnectionInfo.DatabaseName = mainD.BaseDonnees;
logOnInfo.ConnectionInfo.UserID = mainD.Utilisateur;
logOnInfo.ConnectionInfo.Password = mainD.MotDePasse;
report.Database.Tables[i].ApplyLogOnInfo(logOnInfo);
i++;
}
report.PrintToPrinter(1, true, 0, 0);
//END CODE

it doesn't work. it opens the save window. and if i click on cancel an InternalException is returned

thank you for your help

^ Hi,
since I have two monitors now, and my desktop is expanded across both,
I wanted an screensaver for both monitors, just showing an image.
The screensaver needs to strecth the image across both screens.

With the help of the code from the CP screensaver I got it working.
Only it keeps using more memory every time the image changes.
I think it's a simple problem not releasing the image, but I a bit of a noob.

Can someone help me on my way?

Grtz, Steven.
############################################################
...
// holder for bitmaps in folder:
private long maxImageIndex = 0;
private long myBitmapIndex = 0;
private string[] myBitmapStrings;

// temp holder for bitmap:
private Bitmap myBitmap;

...

private void loadPicture()
{
try
{
myBitmap = new Bitmap(Image.FromFile(myBitmapStrings[myBitmapIndex]), rcScreen.Width, rcScreen.Height);
this.pictureBox1.Image = myBitmap;
Console.WriteLine("Loaded image " + myBitmapIndex + ": " + myBitmapStrings[myBitmapIndex]);
}
catch(Exception e)
{
Console.WriteLine("There has been an error loading the picture: " + e.Message);
}
}
...
############################################################

Have you called Dispose on your bitmap when you're done?

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Hi Matt,
thx for your input Smile | :)

What I have now:
I use an private Bitmap.
this is filled with an scaled Image.FromFile() when I load a picture.
This Bitmap is then used as picture in my picturebox.

When I reload I cannot dispose of the bitmap, if I do I get:
######
Found 23 jpg images in directory C:\Documents and Settings\Steven\My Documents\MyScreensaver
There has been an error loading the picture: Object reference not set to an instance of an object.
The program '[480] myScreenSaver.exe' has exited with code 0 (0x0).
######

I do dispose of the Image.FromFile(), but that doesn't help.
On intervals I change the image, getting the filename from an hash?( -> mystrings[])
And this increases the used memory by 10MB or so.

Is this the right way to show an image as screensaver?
Frown | :(

ah,
I did it!

It was because the picturebox needed the image to be there.
And so I couldn't dispose it.
Now I have this, and I think this works.
#####
private void loadPicture()
{
try
{
myImage = Image.FromFile(myBitmapStrings[myBitmapIndex]);
this.Invalidate();
Console.WriteLine("Loaded image " + myBitmapIndex + ": " + myBitmapStrings[myBitmapIndex]);
}
catch(Exception e)
{
Console.WriteLine("There has been an error loading the picture: " + e.Message);
}
}

protected override void OnPaint(PaintEventArgs e)
{
Graphics dc = e.Graphics;
dc.DrawImage(myImage, 0, 0, rcScreen.Width, rcScreen.Height);
myImage.Dispose();

base.OnPaint(e);
}
######

Now I can use dispose.
I am going to test this.....
Thx everyone! Big Grin | :-D

Hi,
I was wondering how to get foll. explorer like controls : (in order of preference)

a) Launch Explorer(C:\) in WinXP. Do not have any of the side panes like "search" or "folder" treeview opened. Close all such panes. On yr LHS we see some sections named "Files and Folder Tasks", "Other Places", etc. These drawer like controls have circular buttons with double-arrows(>> pointing vertically). I wish to have this kind of a control, without color. If I can also get the sliding drawer like functionality, much better - nothing like it.

b) The "Go" button with green arrow on explorer's address taskbar. I guess its the same as (a), but if not, pls let me know.

There are many other controls which I sometimes see in Windows' own GUI, and wish to have them as part of my Windows Forms. Is there a standard way to get these controls ? Does Microsoft make them publicly usable/accessible somewhere ?

Thanks.

As a part of cost cutting, the light at the end of the tunnel has been switched off !!

Search code project for the first one. Second one is a simple image button. No MS doesn't have the collapsible panel controls available, CP is best place to find these for free.

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

Hello every one please help meeeeeee,
At the movemet i'm involving into analyze phase of a web base project Management system which is going to develop by using c#.and i'm using rational XDE for the part of uml design.but i 'm new to rational XDE.so can any body give me a sample application which is developed by using XDE and ebook or chm file as a guide.
And also i need a sample guide material for model a system by using uml notations.

Thanks

Check out this article: Developing pet store using RUP and XDE[^].

- Nick Parker
Microsoft MVP - Visual C#
My Blog | My Articles

Thanks a lot for the quick response.i have go through that and i want some thing more detail than that.somthing like step by step modeling of a paricular application.cas some download links r not active in IBM site.

So if some one have more detail about how a dot net application build on rational XDE.Please let me know soon.

Amal

Hi I'm writing a C# application that has links to run other applications that i've also written in C#. The problem is when I close one of these sub-applications, the main application which called them is also closed.
In the sub-application, the OnClosing method executes the Application.Exit.
How to rewrite the exit function of the sub-application to avoid closing the main one? Confused | :confused:

I'd be very gratefult if u answer my question as soon as possible.

thanx alot Smile | :)

Anonymous wrote:
application that has links to run other applications

What exactly do you mean here? I'm getting the feeling that you interchange the terms form and application.?
If so, leaving out the Application.Exit should do the job.

www.troschuetz.de