XML / XSL

how select and update delete data form xml

27-May-09 5:21

Russell Jones wrote:
Does anyone have an easy way of transforming a document into another document?

It's been a few years but there were methods that returned XmlSource or maybe XmlNode or some such thing in early versions of the BCL. However even if you use something like that with XSLT that is producing illegal XML ( Not well formed ), it will produce a similar error that LoadXML() does.

Russell Jones wrote:
but I get errors about matching tags

So I imagine you need to fix your XSLT either way. I've never tried it but if you set the XSLT output type to XML the XSLT processor might error and not even produce the string output.

Suhail Ali26-May-09 13:59

Suhail Ali

26-May-09 13:59

i am using this code required result is not obtained

DECLARE @DataColumnListInXML XML

SELECT @DataColumnListInXML='

<columnfeature>

<feature>

<featureid>1

<columns>

<id>1<id>
<id>2

DECLARE @IColumnList int

--Create an internal representation of the XML document.

EXEC sp_xml_preparedocument @IColumnList OUTPUT, @DataColumnListInXML

SELECT featureID,ID FROM OPENXML (@IColumnList, '/ColumnFeature/Feature/Columns',3)

WITH (ID varchar(19),

featureID varchar(19)

)

HELP...Transforming Basic XML Tree Menu to HTML

Salvatore Conti Jr26-May-09 8:19

Salvatore Conti Jr

26-May-09 8:19

I am very new to xml...so please bear that in mind as I ask this question.

I worte a very simple tee menu in xml, and my goal is to transform this to HTML so that it can be viewed through the browser.

I have done some reading on this subject and know that I can use either XSLT or possibly parsing the XML with Windows...but I have not been successful on my own.

Below is a snippet of the xml menu:

<menu><br />
 <style>left menu</style>  <br />
<br />
 <name>BIMI Menu</name>  <br />
<br />
 <entry><br />
 <name>Home</name>  <br />
<br />
 <url>index.htm</url>  <br />
<br />
</entry> <br />
	<menu><br />
	<name>HBCA</name><br />
		<menu><br />
		<name>Actuate</name><br />
			<menu><br />
			<name>Direct Weekly</name><br />
				<entry><br />
					<name>DR03w - Direct Weekly</name><br />
					<url>#</url><br />
				</entry><br />
			</menu><br />
			<menu>

This tree menu is to be 3 levels deep...and I when it is viewed in HTML I want the users to be able to click on the entries to view the next level.

I know I can add customization to this like gif images and expand/collapse, which I can code in javascript....but I can not seem to at least view this menu outside of default xml.

Please assist me...it would be greatly appreciated!

Re: HELP...Transforming Basic XML Tree Menu to HTML

led mike27-May-09 7:36

27-May-09 7:36

Salvatore Conti Jr wrote:
I am very new to xml...so please bear that in mind as I ask this question.

Salvatore Conti Jr wrote:
I have done some reading on this subject and know that I can use either XSLT or possibly parsing the XML with Windows...but I have not been successful on my own.

That doesn't tell us what specific help you need.

Possibly you need to do more studying of the XML technology space. Try the tutorials at www.w3schools.com. Also remember that the XML technologies don't care that you want to produce valid HTML, that's up to you to understand what HTML you need your XML and XSLT to produce.

Output not obtained

Fadi Yoosuf26-May-09 5:33

26-May-09 5:33

Hi...

when I apply xsl transformation, no output is obtained. Can anyone help me?

My xml file is
---------------------
<?xml version="1.0" encoding="utf-8"?>
<Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<MySpace>Testing</MySpace>
</Data>
---------------------

My xslt file is
-----------------------
<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text" indent="yes"/>

<xsl:template match="/">
<value-of select="MySpace"/>
</xsl:template>
</xsl:stylesheet>
-----------------------

Thanks

Fadi

led mike27-May-09 7:37

27-May-09 7:37

Fadi Yoosuf wrote:
when I apply xsl transformation, no output is obtained.

When you apply it how? In what context?

Fadi Yoosuf27-May-09 21:41

27-May-09 21:41

You can paste the xml and xslt I gave in w3schools' xslt tester. I have pasted the link below

http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog[^]

thanks
fadi

led mike28-May-09 5:01

28-May-09 5:01

Fadi, the bad news is you don't appear to have the requisite knowledge of the technologies you are working with to be attempting this task. A Web Browser is only going to display HTML.

Fadi Yoosuf28-May-09 22:56

28-May-09 22:56

Thanks alot for the effective criticism.

I overestimated (mistook) like the system had the facility to convert xml/text formats to html.

Anyway "alerted hereafter" Smile | :)

thanks
Fadi

Fadi Yoosuf29-May-09 21:39

29-May-09 21:39

Led,

You argued like "A Web Browser is only going to display HTML."

Was it a blind response?

When you get time, make an html file, open it in edit mode and paste plain text in that. Try viewing in a browser and you can still see the plain text (which was written without html markups).

Now try creating another .html file and paste some xml conent in that. Try viewing in a browser and you can still see the innertext of html nodes in a non formatted manner.

Can you pls. explain the reason for this w.r.t. your argument??

Also can you try the default xml given in http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog[^].

Just change the xslt content as follows
----------------------------
<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="/">

<xsl:for-each select="catalog/cd">

<xsl:value-of select="title"/>
<xsl:value-of select="artist"/>

</xsl:for-each>

</xsl:template>
</xsl:stylesheet>
----------------------------

Now can you pls explain why the output is displayed in the browser even if it is in text format??

If you find a solution, can you pls. explain what is wrong with my code in the first post??

Sorry for disturbing you again

It would be nice of you, if you can convince me with a good answer

Thanks
Fadi

led mike1-Jun-09 10:37

Re: Output not obtained [modified]

1-Jun-09 10:37

Fadi Yoosuf wrote:
Now can you pls explain why the output is displayed in the browser even if it is in text format??

It's not displayed in my browser. That is why I posted what I did and it's as far as I got in debugging your error. I was wrong. Thankfully George Jackson has backed me up and hopefully provided you with the solution.

[modified]
What is wrong with this post? You asked me to explain and I did?

George L. Jackson1-Jun-09 7:21

George L. Jackson

1-Jun-09 7:21

The "MySpace" element is not the child of the root node as indicated in: <xsl:template match="/">. Also, "value-of" needs to be "xsl:value-of".

"We make a living by what we get, we make a life by what we give." --Winston Churchill

modified on Monday, June 1, 2009 2:12 PM

Fadi Yoosuf1-Jun-09 22:39

ASP.NET : Get Attribute Value from XML

1-Jun-09 22:39

thank you very much George.... it is really helpful @ this situation...

led, lemme thank u also for ur efforts.(but you should understand the seriousness of misguiding someone(and all who read the post) with respect to a temporary output. there were errors in my xslt. you didn't even point out that. What if I had blindly believed you!!!!!)

Vijay Jadhav, India.25-May-09 23:36

Vijay Jadhav, India.

25-May-09 23:36

Hi Experts,

My Xml is :

<?xml version="1.0" encoding="utf-8"?>
<Sis xsi:noNamespaceSchemaLocation="Sis.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Student>
    <StudentID>1</StudentID>
    <AcademicDetails>2008-2009</AcademicDetails>
    <PersonalDetails>
      <FirstName>Vijay</FirstName>
      <MiddleName>Laxmanrao</MiddleName>
      <LastName>Jadhav</LastName>
    </PersonalDetails>
  </Student>
</Sis>

I need to extract the value of xsi:noNamespaceSchemaLocation (ie. Sis.xsd).

How to get it ?

I have try below snippet, but it will show sXSDFile always null. Why ?

public static bool ValidateXml(Stream oXmlStream)
{
    string sXsdPath = "";
    string sXSDFile = "";
    try
    {
        XmlTextReader xmlTextReader = new XmlTextReader(oXmlStream);
        sXSDFile = xmlTextReader.GetAttribute("xsi:noNamespaceSchemaLocation");
    }

    catch (Exception ex)
    {
        _isValied = false;
    }
    return _isValied;
 }

Sample code would be greatly appreciated. Thumbs Up | :thumbsup:

Thanks.

Vijay Jadhav.

Re: ASP.NET : Get Attribute Value from XML

Vijay Jadhav, India.26-May-09 3:59

Vijay Jadhav, India.

26-May-09 3:59

Hi All,

I got it.

Code snippet :

XmlTextReader xmlTextReader = new XmlTextReader(oXmlStream);
xmlTextReader.MoveToContent();
sGetXsdFileName = xmlTextReader.GetAttribute("xsi:noNamespaceSchemaLocation");

Thanks. Laugh | :laugh:

Vijay Jadhav.

Render the custom server side control using XSL

Brij25-May-09 19:08

Brij

25-May-09 19:08

Hi
How can I render the custom server side control like user controls etc using XSLT on my webpage?

Cheers!!
Brij

Check My Latest Article

Print XSLT?

notarry24-May-09 23:24

notarry

24-May-09 23:24

I want to print XSLT(HTML and PDF) file, in my file has many paragraph
and i dont know how many line in paragraph. My problem is i dont want
want to print any paragraph in split pages.

Thanks

Re: Print XSLT? I want to print XSLT(HTML and PDF) file.

adatapost26-May-09 1:38

adatapost

26-May-09 1:38

Copy the content of XSLT file into MSWORD and print it.

A DATAPOST COMPUTER CENTRE
(K.V Prajapati)

Re: Print XSLT?

notarry27-May-09 16:06

notarry

27-May-09 16:06

Thanks, but it not solve my solution. Smile | :)

Reading XML

M_Aurelius23-May-09 22:20

M_Aurelius

23-May-09 22:20

I orginally posted this in the C# forum as I did not notice there was a xml forum... Big Grin | :-D

I am trying to read an xml file into a dataset and have been met with nothing but problems.

The xml file is in the following format:

<?xml version="1.0"?><br />
<Catalog xmlns:dt="dt"><br />
<Rec><br />
<ITEM dt:dt="string"></ITEM><br />
<QTY dt:dt="string">1</QTY><br />
<SUB dt:dt="string"></SUB><br />
<CATALOG dt:dt="string">ABC123</CATALOG><br />
</Rec><br />
</Catalog>

I have tried this code in C#:

<br />
Dataset ds = new DataSet("Test");<br />
ds.ReadXML(OFD.FileName);<br />

When I set a breakpoint just after this code and examine ds, all have is a table called "Rec" and one column called "Rec_Id", clearly this is not what I want!!

Someone else has tried this and gets finds that ds has changed from "Test" to "Catalog", which is believed to have been picked up from the xml file. Expanding the Tables node reveals have 5 tables:
[0] Rec
[1] ITEM
[2] QTY
[3] SUB
[4] CATALOG

I think this can be done by specifing a schema, but I do not know how you do this whilst reading into a dataset nor do I know enough about schemas to know what to specify where!!

If I remove the dt:dt="String" datatypes then everything is fine. I do not want to manually do this so if this is the only way then how can I do it programatically? I need an automated solution.

Can anyone help?

Thanks

Re: Reading XML

harold aptroot23-May-09 23:46

harold aptroot

23-May-09 23:46

XSLT would be overkill for this.. maybe just iterate over everything and delete all dt:dt attributes?

Help for newbie

Konstantin Yazvinski21-May-09 12:28

Konstantin Yazvinski

21-May-09 12:28

I need to represent hierarchy of people who work under over persons I did it next way:

<?xml version="1.0" encoding="utf-8"?>
<person>
  <name>Al</name>
  <title>God</title>
  <employees>
    <person>
      <name>Bart</name>
      <title>Human</title>
      <employees></employees>
    </person>
    <person>
      <name>Lisa</name>
      <title>Woman</title>
      <employees></employees>
    </person>
    <person>
      <name>Lionardo</name>
      <title>Father</title>
      <employees>
        <person>
          <name>Jim</name>
          <title>Son</title>
          <employees>
            <person>
              <name>Jim 2nd</name>
              <title>Sub son</title>
              <employees></employees>
            </person>
          </employees>
        </person>
      </employees>
    </person>
  </employees>
</person>

Is that right way to do that?

any help will appreciated!

Re: Help for newbie

led mike22-May-09 4:31