Reading and writing to an xml document - XML / XSL Discussion Boards

You want to add more ASP code? If the XSL does not change and HTML code concerning the body element and its ancestors, you can place that code in the ASP file. Then, you can add more ASP code before or after the transformed HTML code.

... kindly, can you give me an example with the post code? Big Grin | :-D

... the code I should change it so?

my code asp

<%
' View Message

' prevent page caching

Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1

xslpath = Server.mappath("viewmessage.xsl") '"d:\InetPub\wwwroot\XMLmessageboard\messageboard.xsl"
xmlpath = Application("xmlpath")

Set id = Request.QueryString("id")
set xdoc = Application("xdoc")
set xsldoc = Server.CreateObject("MSXML2.FreeThreadedDOMDocument")

'load up XSL doc and perform transformations

xsldoc.async = false
xsldoc.load(xslpath)

set xsltemp = Server.createObject("MSXML2.XSLTemplate")
xsltemp.stylesheet=xsldoc

set xslproc = xsltemp.createProcessor
xslproc.input=xdoc.nodeFromID(id)
xslproc.output=Response

' parameter for message group

xslproc.addParameter "msgid",CStr(id)
xslproc.transform()

my code asp

%>

Andrea

Yes, just make sure that the HTML, HEAD and BODY elements aren't in the messageboard.xsl.

I try with my application and It give me the error:

The page

http://www.allinonenet.it/gamezone/gameaon/display.asp?gameid=4

ant the xsl

http://www.allinonenet.it/gamezone/gameaon/gameaon.xsl

The synbol is:ÿþ

why Smile | :)

?

I cannot help you here since you are embedding and object in your page.

in the xsl page ?

Hello,

I am trying to read and write to a xml document into a dataset, but got an error message that cannot find the file path.

This is using the Compact Framework 2.0, so cannot use the currentDirectory or startupPath, I have used the code below. However, the path i get is \programFile\PDACodeRedWM5 which is returned

PDACodeRedWM5 being the name of my project.

However, this path doesn't exist on my file system. So i got an error saying 'Could not find a part of the path '\C:\Program Files\PDACodeRedWM5\webServiceUrl.xml'.

So i created this actual path on my file system and still got the same error message.

This is my code so you can have a better understanding, I am trying to read in a xml file into a Dataset.

Try<br />
            'File the xml file<br />
            Dim fileName As String = String.Empty<br />
            Dim ds As New DataSet<br />
            Dim dv As DataView<br />
<br />
            Dim path As String<br />
            path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)<br />
            path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetModules(0).FullyQualifiedName)<br />
<br />
            'Read in the xml file<br />
<br />
            fileName = String.Format("{0}\WebServiceURL.xml", path)<br />
<br />
            ds.ReadXml(fileName)<br />
<br />
            'Find if a url already exists<br />
            dv = New DataView(ds.Tables(0))<br />
<br />
            If (dv.Count = 0) Then<br />
                'This is the first time the application is running, so input from user<br />
                Dim objInputURL As New InputURL()<br />
                objInputURL.ShowDialog()<br />
            Else 'Set the URL to the current web service location<br />
                Dim objUrl As New Globals<br />
                objUrl.UrlPath = ds.Tables(0).Rows(0)("url").ToString()<br />
            End If<br />
<br />
        Catch ex As Exception<br />
            MsgBox(ex.Message)<br />
        End Try

If the programFile\PDACodeRedWM5 has not been created why does it give that file path?

The actual path the application is in, is on my D drive.

Many thanks for any help,

Steve

Steve I am not sure I agree with you conclusion that an issue of finding a file using the compact framework qualifies as an XML issue just because the contents of your particular file is XML. Oh never mind... I just noticed you are using VB.

led mike

Hello all,
I'm sure this is a walk in the park for all you experts out there.
I'm very new to VB.net coming from a VBA background. I have the job of opening a XML file when it is recieved by a web service adding it's data to a database. I believe I must use a dataset and compare the file to a XML schema. If anyone can help I would be very grateful as I'm making little progress myself Frown | :(

Thanks in advance

-ukfrosty

Your post might be too broad. Go to the C# forum and read the post at the top of the list "How to get an answer to your question".

led mike

Hi, i try to make a new asp.net web service project in ms visual studio .net 2003, but in solution explorer window, the .vsdisco file doesn't come up. I want to try xml web service locally.Can u help me and give some advise?

Thanks

dear hariharan,

if you have an idea to find the text in xmldocument.

Then if it is an attribute name then

xmlDoc.selectsingleNode("//ParentNode/Node[@id='" & txtbox1.text &"']")

If its a element name then

xmlDoc.selectsingleNode("//ParentNode")

All The Best

Sathesh Pandian

Hi!
I am using C#, i want to search a node in XML file having a given Attribute. the structure of XML file is not known, i.e. we dont know that how many nodes are there and each node conatins how many child nodes.

following is a sample of the structure of XML file. I want to traverse all nodes of file and return the "Name" attribute of the node if it matches with the user defined string.

<ROOT>
<Group Name="A" ID="1">
<Group Name="C" ID="3">
<Group Name="D" ID="4" />
</Group>
<Group Name="E" ID="5">
<Group Name="F" ID="6">
<Group Name="G" ID="7" />
</Group>
</Group>
</Group>
<Group Name="B" ID="2" />
</ROOT>

I tried to do it with recursion but could not handle it. Please tell me how to do it.

Thanks in advance..

Regards,
Affan Ahmad Toor

Affan Toor wrote:
could not handle it

What does that mean? Show us the code you got so far.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

I am trying to write a dataset upon login and write certain information retrieved from an Access db (I hate Access but right now the SQL box isn't available so I'm hitting the Access db as little as possible). When I populate the DataSet and use DataSet.WriteXML it's giving weird results. Also, when I login in a 2nd time (with a different user, the only part that works is searching the XML for the user I'm logging in with if it exists then dont rewrite it) I want it to append it to the existing XML document and even this isn't working right, the .WriteXML is giving a result like

<newdataset>
  <Table>
    <_x0027_u_name_x0027_>rlmccutchen<_x0027_u_name_x0027_>
    <_x0027_u_pwd_x0027_>*********<_x0027_u_pwd_x0027_>
    <_x0027_f_name_x0027_>Richard<_x0027_f_name_x0027_>
    <_x0027_l_name_x0027_>McCutchen<_x0027_l_name_x0027_>
    <_x0027_email_x0027_>richard@psychocoder.net<_x0027_email_x0027_>
    <_x0027_is_admin_x0027_>1<_x0027_is_admin_x0027_>
    <_x0027_total_posts_x0027_>0<_x0027_total_posts_x0027_>
    <_x0027_client_id_x0027_>1<_x0027_client_id_x0027_>
    <_x0027_user_id_x0027_>1<_x0027_user_id_x0027_>
    <_x0027_site_name_x0027_>RamEngine<_x0027_site_name_x0027_>
  </Table>
</newdataset>
<newdataset>
    <Table>
      <_x0027_u_name_x0027_>jbunton<_x0027_u_name_x0027_>
      <_x0027_u_pwd_x0027_>*********<_x0027_u_pwd_x0027_>
      <_x0027_f_name_x0027_>Jack<_x0027_f_name_x0027_>
      <_x0027_l_name_x0027_>Bunton<_x0027_l_name_x0027_>
      <_x0027_email_x0027_>ramremfg@aol.com<_x0027_email_x0027_>
      <_x0027_is_admin_x0027_>0<_x0027_is_admin_x0027_>
      <_x0027_total_posts_x0027_>0<_x0027_total_posts_x0027_>
      <_x0027_client_id_x0027_>1<_x0027_client_id_x0027_>
      < _x0027_user_id_x0027_>2<_x0027_user_id_x0027_>
      <_x0027_site_name_x0027_>RamEngine<_x0027_site_name_x0027_>
    </Table>
</newdataset>

I've been raking my head for days now trying to solve this so I canh move on to a new piece. Can someone please help.

" In the next millennium there are two kinds of business, those on the Internet and those out of business"
Bill Gates

"Be nice to nerds. Chances are you'll end up working for one."
Bill Gates

"Let's face it, the average computer user has the brain of a Spider Monkey."
Bill Gates

Leoapa wrote:
What should I do?

Show us the XPath expression and relevant parts of your XML file.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

how to parse an xml file using c code. pls help me

Arise Awake Stop Not Till ur Goal is Reached.

Ever tried google
http://www.google.com/search?hl=en&q=xml+parser+c&btnG=Search[^]

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

ok but i have to write c code in linux. i cant use any downloaded code

Arise Awake Stop Not Till ur Goal is Reached.

deeps_cute wrote:
ok but i have to write c code in linux. i cant use any downloaded code

The second hit from google states that "Libxml2 is known to be very portable, the library should build and work without serious troubles on a variety of systems (Linux, Unix, Windows, CygWin, MacOS, MacOS X, RISC Os, OS/2, VMS, QNX, MVS, ...)" The XML C parser and toolkit of Gnome - libxml[^]

If you mean that you want to write your own XML parser that will be a very challenging task and most probably no one here can give you complete code for this. Your best bet would be to take a look at the sources of the available parsers to see how they tackle the problem.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Stefan Troschuetz wrote:
If you mean that you want to write your own XML parser that will be a very challenging task and most probably no one here can give you complete code for this.

If memory serves well there are some articles... At least one XML parser in C++ - probably portable to linux.

"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

Hi,

I want to create a XSD schema to use for validating XML files like the following:
top>
top>
top>
top>
/top>
link> link> mid>
mid>
/top>
top>
bottom>
/top>
/top>

A "top" element can contain any number of "top" elements or any number of "link" elements or any number of "mid" elements. A "top" element can contain only one "bottom" element and no other element if it contains a "bottom" element. A "link" or "mid" or "bottom" element cannot contain any elements.

Any advice, please help?

-- modified at 2:51 Wednesday 2nd May, 2007

Not tested, but should be at least a good starting point:

<?xml version="1.0" encoding="utf-8" ?> 
<xs:schema targetNamespace="http://tempuri.org/XMLSchema.xsd"
                  elementFormDefault="qualified"
                  xmlns="http://tempuri.org/XMLSchema.xsd"
                  xmlns:mstns="http://tempuri.org/XMLSchema.xsd"
                  xmlns:xs="http://www.w3.org/2001/XMLSchema">
	<xs:element name="link">
		<xs:complexType></xs:complexType>
	</xs:element>

	<xs:element name="mid">
		<xs:complexType></xs:complexType>
	</xs:element>

	<xs:element name="bottom">
		<xs:complexType></xs:complexType>
	</xs:element>

	<xs:element name="top">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:element ref="mstns:bottom"></xs:element>
				</xs:sequence>
				<xs:sequence>
					<xs:choice minOccurs="0" maxOccurs="unbounded">
						<xs:element ref="mstns:top"></xs:element>
						<xs:element ref="mstns:link"></xs:element>
						<xs:element ref="mstns:mid"></xs:element>
					</xs:choice>
				</xs:sequence>
			</xs:choice>
		</xs:complexType>
	</xs:element>
</xs:sche

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Or even simpler...

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xs:complexType name="top">
    <xs:sequence>
      <xs:element name="top" type="xs:string" minOccurs="0" maxOccurs="unbounded" />
      <xs:element name="link" type="xs:string" minOccurs="0" maxOccurs="unbounded" />
      <xs:element name="mid" type="xs:string" minOccurs="0" maxOccurs="unbounded" />
      <xs:element name="bottom" type="xs:string" minOccurs="0" maxOccurs="unbounded" />
    </xs:sequence>
  </xs:complexType>

  <xs:element name="top" type="top" />
</xs:schema>

Try code model generation tools at BoneSoft.com.