XML / XSL

want to generate Schema using WriteXmlSchema()

22-May-05 11:50

jeffb_ wrote:
VB.net 2005

I don't know how in 2k5, let be alone in VB... In good ol' .NET1.1 XML elements art in "document context" so elements can be used only within XmlDocument which created them.

(Just checked, work same way in .NET 2.0)

Well XmlNode ( so XmlElement too ) implements ICloneable. Should not be a problem.

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

favor0320-May-05 19:59

favor03

20-May-05 19:59

Hi

I am trying to generate a XSD schema from a xml file by using a stream writer.

I created a dataset and read XML into that dataset.
Now I am trying the ds.WriteXmlSchema();

Actually it works correctly...but my issue is I want to send the written schema into a textbox on button click.

How would I do that?

This is the code I wrote for writing the schema:

System.IO.StreamWriter swXML= new System.IO.StreamWriter();
ds.WriteXmlSchema(swXML);
textBox1.Text =swXML.ToString();

Re: want to generate Schema using WriteXmlSchema()

DavidNohejl22-May-05 11:33

22-May-05 11:33

I'd say swXml.ReadToEnd() in this case.

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

msxmlcpp library

ikasovitch19-May-05 6:46

ikasovitch

19-May-05 6:46

Hi I am using msxmlcpp library that was written by Sven Weigand. With this library
I parse an xml file. When one of my methods ends I receive an Access violation message
box. With debugging I have seen that it happens as a result of CXMLDOMNode class's destructor.
As a result of the destructor an ATL's CComPtr->Release method is called and it causes this
problem. Does anybody know how to solve thid problem?

Best regards

Re: msxmlcpp library

DavidNohejl22-May-05 11:51

update particular attribute's value from xml file

22-May-05 11:51

Maybe contact Sven Weigand, or try C++ forum. This question have little to do with XML.

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

ksanju100018-May-05 4:24

ksanju1000

18-May-05 4:24

Hi
my program updates only farm name I want to search through loop farm name and it should
update address,
user and password from the existing file name

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("c:/farm-config.xml");
XmlNode farm=xmldoc.SelectSingleNode("/root/farm-config/farm/@name");
MessageBox.Show(farm.InnerText);
farm.InnerText="devxcv1";
MessageBox.Show(farm.InnerXml);
xmldoc.Save("c:/farm-config.xml");

My XMl strucutrue is as given below
<?xml version="1.0" encoding="UTF-8"?>
<root>
<farm-config>
<farm name="sanjay">
<connection address="127.0.0.1" user="dog" password="cat">
<lastjob>Copy-All</lastjob>
<lastconnection startdate="2005-05-10" starttime="12:43:23" enddate="2005-05-10" endtime="12:58:32" />
<state>1</state>
</connection>
</farm>
<farm name="ram">
<connection address="localhost" user="root" selectedConnection="1" password="daask">
<lastJob>Copy-All</lastJob>
<lastConnection startdate="2005-05-10" starttime="12:43:23" enddate="2005-05-10" endtime="12:58:32" />
<state>1</state>
</connection>

</farm>
</farm-config>
</root>

--- supoose i want to find thr loop ram and i want o change address,user and password attribues value thr loop
if i change it changes the upper ones farm name=sanjay 's address,user and password

regards
sanjeev

Re: update particular attribute's value from xml file

DavidNohejl22-May-05 11:22

Re: update particular attribute's value from xml file

22-May-05 11:22

Could you re-formulate this? In sentences maybe? Sorry, but I have hard time to understand what you have and what you want...

Maybe example of expected result could help. (?)

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

ksanju100022-May-05 18:30

ksanju1000

22-May-05 18:30

Hi buddy,
I have already implemented. Actually it searches the particular node from xml file and update child's node atrribute
Thanks for your interest
regards
sanjeev

XML & ASP.NET - automate daily updates

shahar rr r17-May-05 0:50

shahar rr r

17-May-05 0:50

Hello all!

I'm using ASP.NET and XML and sql server database.

I get daily updates in xml format and import them into the MSSQL DB.

I do this via a function in ASP.net using XmlReader.

The problem is that i have to do it manually!
Each morning i goto the asp.net website and click "get xml updates".

Is there any way to automate this procedure?

thanks guys Confused | :confused:

Re: XML & ASP.NET - automate daily updates

Anonymous17-May-05 1:36

Anonymous

17-May-05 1:36

You Can use windows service for this.You can shedule your specific task like sending xml file to server by using ur service .You can start with it.

regards
sagar

Re: XML & ASP.NET - automate daily updates

shahar rr r18-May-05 4:59

shahar rr r

18-May-05 4:59

windows service? meaning "scheduled task"?

can you please explain?
or maybe refer me to a link/article?

thank you

create xsd scheme

Anonymous16-May-05 22:40

Anonymous

16-May-05 22:40

Hey,

anyone knows if there are handy tools to create a XSD scheme based on a XML file?
It's because I'm not familiar with XSD scheme's and I have to use one in my project.

My scenario is the following:
in my XML file i have the following structure:

<transfer>
<customer id="mh55">
<document id="1">
<article id="computer">
<priceIncl>565</priceIncl>
<priceExcl>412</priceExcl>
<priceVAT>85</priceVAT>
</article>
<article id="screen">
... same as above ...
</article>
</document>
<document id="2">
... same as above ...
</document>
</customer>
<customer id="xdc88">
... same as above ...
</customer>
</transfer>

Re: create xsd scheme

niansah17-May-05 2:11

niansah

17-May-05 2:11

1. xmlfox[^]
2. cooktop[^]

Re: create xsd scheme

Brian Van Beek23-May-05 8:57

Brian Van Beek

23-May-05 8:57

I like xml spy while i know that actually buying it is REALLY expensive, but you can get a free 30 day trial. Fortunately my work buys copies of it for us.

Brian Van Beek
My Blog is Awesome, ok maybe not, but is still fun!!

Re: create xsd scheme

eggie524-May-05 18:00

eggie5

24-May-05 18:00

just add it to a project in visual studio, and then there's an option if you right click on it, to make a schema for it... free.

/\ |_ E X E GG

Inserting node element between nodes

ksanju100016-May-05 21:39

ksanju1000

16-May-05 21:39

hi,
I have written code to insert node
but its inserting after root node i want that it should insert after farm-config
pls check my code

private void button6_Click_1(object sender, System.EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("c:/farm-config.xml");
XmlElement farmelement = xmldoc.CreateElement("farm");
xmldoc.DocumentElement.InsertBefore(farmelement,xmldoc.DocumentElement.LastChild);

FileStream fsxml = new FileStream("c:/farm-config.xml",FileMode.Truncate,FileAccess.Write,FileShare.ReadWrite);

// XML Document Saved
xmldoc.Save(fsxml);
}
Pls modify my existing code so that i could insert after farm-config node

Hi this is my original stururtue of XML file
<?xml version="1.0" encoding="UTF-8"?>
<root>
<farm-config>
<farm name="dev1">
<connection address="localhost" user="root" selectedConnection="1" password="ram">
<lastJob>Copy-All</lastJob>
<lastConnection startdate="2005-05-10" starttime="12:43:23" enddate="2005-05-10" endtime="12:58:32" />
<state>1</state>
</connection>

</farm>

</farm-config>
</root>

after inserting XML looks like in the given below structure
----- --------- ----------------

<?xml version="1.0" encoding="UTF-8"?>
<root>
<farm />
<farm-config>
<farm name="dev1">
<connection address="localhost" user="root" selectedConnection="1" password="ram">
<lastJob>Copy-All</lastJob>
<lastConnection startdate="2005-05-10" starttime="12:43:23" enddate="2005-05-10" endtime="12:58:32" />
<state>1</state>
</connection>

</farm>

</farm-config>
</root>

I want Xml to be inserted after farm-config
This should be inserted like that
I am giving you the structure of XML file
What fucntion should i write or modify my existing code
For the code see above

<?xml version="1.0" encoding="UTF-8"?>
<root>
<farm-config>
<farm />
<farm name="dev1">
<connection address="localhost" user="root" selectedConnection="1" password="ram">
<lastJob>Copy-All</lastJob>
<lastConnection startdate="2005-05-10" starttime="12:43:23" enddate="2005-05-10" endtime="12:58:32" />
<state>1</state>
</connection>

</farm>

</farm-config>
</root>

regards
sanjeev

Re: Inserting node element between nodes

DavidNohejl17-May-05 8:32

complex XML Serialization

17-May-05 8:32

What about:

private void button6_Click_1(object sender, System.EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("c:/farm-config.xml");
XmlElement farmelement = xmldoc.CreateElement("farm");
XmlElement farmConfig = xmldoc.SelectSingleNode("//farmConfig");
xmldoc.InsertAfter(farmelement,farmConfig);

FileStream fsxml = new FileStream("c:/farm-config.xml",FileMode.Truncate,FileAccess.Write,FileShare.ReadWrite);

// XML Document Saved
xmldoc.Save(fsxml);
}

[not tested]

hope it helps,
David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

jhsun414-May-05 8:42

14-May-05 8:42

Hi all,

I need to serialize and deserialize complex elements that have attributes, and get their values as well.

An example xml snippet:

<root version="1.0" rating="1">
<tempsettings>
<setting name="blah1" istemp="False">99
<setting name="blah2" istemp="True">100

<root> contains a <tempsettings> which has an ArrayList of
<setting> that is converted to a typed array when accessed via a property.

The problem I'm running into is along with access to <setting>'s
attributes I need the values contained in them as well. (eg. 99, 100).
I've been fuddling around for days and can't come up with how to do this.
I can't use the xsd generator to generate my c# class as my xml root
is stuck to being "root" and contains additional attributes.
Is there a way I can achieve what I need using .NET XML
serialization? Confused | :confused:

I sincerely appreciate any feedback.

DavidNohejl14-May-05 9:06

14-May-05 9:06

there is something missing in your post, don't you think??

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

jhsun414-May-05 9:23

14-May-05 9:23

argh! sorry for the last post forgot to escape my tags...

<root version="1.0" producer="1">
<exportSettings>
<setting name="folder1" isBatchdefs="False">99</setting>
<setting name="folder2" isBatchdefs="True">100</setting>
</exportSettings>
</root>

jhsun414-May-05 9:28

14-May-05 9:28

david,

thanks for catching my page errors.
due to formatting errors with previous posts please let me restate my problem:

<root version="1.0" producer="1">
<exportsettings>
<setting name="folder1" isbatchdefs="False">99
<setting name="folder2" isbatchdefs="True">100

The problem I'm running into is along with access to <setting>'s
attributes I need the values contained in them as well. (eg. 99, 100).

I can't use the xsd generator to generate my c# class as my xml root
is stuck to being "root" and contains additional attributes.

Thanks for your comments and feedback!

DavidNohejl14-May-05 9:31

14-May-05 9:31

that wasn't very lucky... there are still missing things in the text... check "Do not treat <'s as HTML tags" and post it (original post) one more time... please

thanks,
David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

jhsun414-May-05 9:32