Re: Multiple group using Muenchian Method - XML / XSL Discussion Boards

Re: Display a image in picturebox

Stuart Dootson23-Feb-10 20:50

Stuart Dootson

23-Feb-10 20:50

kpuneeth7 wrote:
GIve examples

Without knowing a little about the structure of your XML file and what technology you're using, that would be difficult to do...

But it's simply a case of reading the XML file with an XML parser (think XmlReader in .NET), and finding the node containing the image file's path.

The rest of it (displaying the image in the picture box) is nothing to do with XML.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: Display a image in picturebox [modified]

kpuneeth723-Feb-10 21:01

kpuneeth7

23-Feb-10 21:01

I am using a simple xml file.....

<path>C:\Documents and Settings\Imran\Desktop\Picture\apple.jpg

And i am using visual studio 2008
C# language.
.net framework

modified on Wednesday, February 24, 2010 3:20 AM

Re: Display a image in picturebox

Stuart Dootson23-Feb-10 21:36

Stuart Dootson

23-Feb-10 21:36

Here's a short C# program that will read the bit of XML you want and write it to the console.

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

namespace ConsoleApplication1
{
   class Program
   {
      static void Main(string[] args)
      {
         // The XML file is specified as the first command line argument
         // imagePath will contain the image path contained in the XML file
         string imagePath = new XPathDocument(new StreamReader(args[0])).CreateNavigator().SelectSingleNode("/image/img").Value;
         System.Console.WriteLine(imagePath);
      }
   }
}

I've used XPath to navigate to the required element in the XML file (that's the .SelectSingleNode("/image/img") bit) and read the text there (the .Value bit). Simples.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: Display a image in picturebox

kpuneeth723-Feb-10 23:53

kpuneeth7

23-Feb-10 23:53

Thanks for the code....

BUt its giving indexoutofrange exception......

HElp

Re: Display a image in picturebox

Stuart Dootson24-Feb-10 0:08

Stuart Dootson

24-Feb-10 0:08

You need to give a command line argument that specifies the XML file...the code comments DO say that....

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: Display a image in picturebox

kpuneeth724-Feb-10 1:26

kpuneeth7

24-Feb-10 1:26

Thanks dude..... Smile | :)

I got it

Thank u very much

Multiple group using Muenchian Method [modified]

ONeil Tomlinson23-Feb-10 4:15

ONeil Tomlinson

23-Feb-10 4:15

I have the following input XML. I want to group all unique Code/ID combination.

<List>
 <Section>
  	<Code>AA</Code>
  	<ID>11</ID>
 <Section>
 <Section>
  	<Code>AA</Code>
  	<ID>11</ID>
 <Section>
 <Section>
  	<Code>CC</Code>
  	<ID>11</ID>
 <Section>
 <Section>
  	<Code>AA</Code>
  	<ID>22</ID>
 <Section>
 <Section>
  	<Code>AA</Code>
  	<ID>11</ID>
 <Section>
<List>

So result should be as shown below.

<Code>AA</Code>
<ID>11</ID>

<Code>CC</Code>
<ID>11</ID>

<Code>AA</Code>
<ID>22</ID>

Im using the Muenchian Method. Currely my XSL (below) is grouping by Code (and not Code/ID combination)

<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var" version="1.0" xmlns:ns0="http://A4C.Interface.HRP.Payroll.Schemas">
	<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />

	<xsl:key name="CCids" match="/List/Section" use="Code"/>

	<xsl:template match="/">
		<xsl:apply-templates select="/ns0:Payroll" />
	</xsl:template>
	<xsl:template match="/ns0:Payroll">
		<ns0:List>
			<xsl:for-each select="/List/Section [generate-id(.)=generate-id(key('CCids',Code))]">
				<Section>
					<Code>
						<xsl:value-of select="code/text()" />
					</Code>
					<ID>
						<xsl:value-of select="id/text()" />
					</ID>
				</Section>
			</xsl:for-each>
		</ns0:List>
	</xsl:template>
</xsl:stylesheet>

How do i get this to use a Code/ID combination? I tried nested for-each loop but no luck. Thanks

modified on Tuesday, February 23, 2010 11:40 AM

Re: Multiple group using Muenchian Method

Stuart Dootson23-Feb-10 20:47

Stuart Dootson

23-Feb-10 20:47

Firstly, your key needs to have an expression which reflects what you want to retrieve:

<xsl:key name="CCids" match="/List/Section" use="concat(Code,'|',ID)"/>

And then you need to use that same expression when accessing items referenced by the key.

Oh - and in addition, I would suggest not using a for loop - it's not idiomatic XSL. Here's the file I'd use:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var" version="1.0" xmlns:ns0="http://A4C.Interface.HRP.Payroll.Schemas">
   <xsl:output omit-xml-declaration="yes" method="xml" version="1.0" encoding="utf-8"/>

   <xsl:key name="CCids" match="/List/Section" use="concat(Code,'|',ID)"/>

   <xsl:template match="/">
      <ns0:List>
         <xsl:apply-templates select="/List/Section [generate-id(.)=generate-id(key('CCids',concat(Code,'|',ID)))]"/>
      </ns0:List>
   </xsl:template>
            
   <xsl:template match="Section">
      <Section>
         <Code>
            <xsl:value-of select="Code/text()" />
         </Code>
         <ID>
            <xsl:value-of select="ID/text()" />
         </ID>
      </Section>
   </xsl:template>
</xsl:stylesheet>

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: Multiple group using Muenchian Method

ONeil Tomlinson24-Feb-10 0:05

ONeil Tomlinson

24-Feb-10 0:05

Thanks..Really helpful Wink | ;)

How Do I deserialize the following Xml string? [modified]

ashishtango22-Feb-10 23:05

ashishtango

22-Feb-10 23:05

Hi,
I am getting this error There is an error in XML document (1, 2)
When i Deserialize following Xml.

<EnvironmentConfigurations>
<EnvironmentConfiguration>
<EnvironmentName>ABC</EnvironmentName>
<CMSConfiguration>
<Address>net.tcp://localhost:9000/Manager</Address>
<Binding>netTcpBinding</Binding>
<Contract>Common.Interfaces.Server</Contract>
</CMSConfiguration>
</EnvironmentConfiguration>
<EnvironmentConfiguration>
<EnvironmentName>XYZ</EnvironmentName>
<CMSConfiguration>
<Address>net.tcp://localhost:9000/Manager</Address>
<Binding>netTcpBinding</Binding>
<Contract>Common.Interfaces.Server</Contract>
</CMSConfiguration>
</EnvironmentConfiguration>
</EnvironmentConfigurations>

modified on Tuesday, February 23, 2010 5:11 AM

Re: How Do I deserialize the following Xml string?

Stuart Dootson22-Feb-10 23:54

Stuart Dootson

22-Feb-10 23:54

Deserialize to what? The way in which it's deserialized depends on the type you think it is.

Are you sure this was serialized from .NET? That's not the only way to read and write XML, you know - maybe you should be using an XMLReader and parsing the XML yourself?

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: How Do I deserialize the following Xml string?

ashishtango23-Feb-10 16:52

ashishtango

23-Feb-10 16:52

I have serialized using XmlSerializer.
I have removed Xml version and namespace information from the XML.
I have changed the root node from
<ArrayOfEnvironmentConfigurations> to <EnvironmentConfigurations>
I want to desrialize this xml.
Thank you.

Re: How Do I deserialize the following Xml string?

Stuart Dootson23-Feb-10 20:27

Stuart Dootson

23-Feb-10 20:27

The answer to your problem is very, very clear - don't mess with the XML that the serializer produces - all of the things you changed are in there for a reason!!!!

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Re: How Do I deserialize the following Xml string?

ashishtango24-Feb-10 18:35

ashishtango

24-Feb-10 18:35

The problem was with the root node element which i changed.
I kept the root name as ArrayOfEnvironmentConfigurations and the problem was solved.
Thanks for replying.

Accessing a image from a xml file and display in visual studio picture box

kpuneeth722-Feb-10 21:15

kpuneeth7

22-Feb-10 21:15

Hi everyone,

I came across this prob...
I am a beginner in xml.
I wanted to create a xml file which stores the location of the images.
This xml file must be accessed in visual studio picture box and it must display each image wen i click the next button and back wen i press the previous button...

Please help

Re: Accessing a image from a xml file and display in visual studio picture box

Richard MacCutchan22-Feb-10 22:31

Richard MacCutchan

22-Feb-10 22:31

kpuneeth7 wrote:
I am a beginner in xml.

Then you should study some of the tutorials here and on MSDN on the use of XML. From the remainder of your question it appears that you are asking for a complete image viewer solution. If you have no idea how to start on this problem then you have a lot of studying still to complete.

txtspeak is the realm of 9 year old children, not developers. Christian Graus

xsd to entity [modified]

pokiri22-Feb-10 17:45

pokiri

22-Feb-10 17:45

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" id="BookEasy">

<xsd:element name="BookEasy">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Control">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="ControlID" type="xsd:int"/>

<xsd:element name="ReservationRequest">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="InDate" type="xsd:dateTime"/>
<xsd:element name="Period" type="xsd:int"/>
<xsd:element name="Adults" type="xsd:int"/>
<xsd:element name="Children" type="xsd:int"/>
<xsd:element name="Infants" type="xsd:int"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>

<xsd:element name="Operators">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Operator" minOccurs="0" maxOccurs="unbounded">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="OperatorID" type="xsd:int"/>

<xsd:element name="Rooms">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Room" minOccurs="0" maxOccurs="unbounded">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="RoomID" type="xsd:int"/>

<xsd:element name="Availability">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="IsAvailable" type="xsd:boolean"/>

<xsd:element name="Days">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Day" maxOccurs="unbounded">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="Date" type="xsd:dateTime"/>
<xsd:element name="IsAvailable" type="xsd:boolean"/>

<xsd:element name="Rates">

<xsd:complexType>

<xsd:sequence>
<xsd:element name="FullRate" type="xsd:decimal"/>
<xsd:element name="LastMinuteRate" type="xsd:decimal"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>

modified on Tuesday, February 23, 2010 12:29 AM

Re: xsd to entity

Not Active22-Feb-10 21:01

Not Active

22-Feb-10 21:01

Do you have a question? Confused | :confused:

I know the language. I've read a book. - _Madmatt

How to delete duplicate nodes from XML throgh C#?

deadlyabbas18-Feb-10 19:12

deadlyabbas

18-Feb-10 19:12

Hi,
I want to delete the duplicate and some hard coded XML node in XMLDocument throgh C#.
What is the method to do the same?
I am new to the use of XML in C#.
Please help me out.....!!!!!!!!!!!

Thanks

Problem with MSXML6 + namespace + XPath

Patrice Espie18-Feb-10 4:57

Patrice Espie

18-Feb-10 4:57

Hi All,

I try to use MSXML with xml files which contains namespaces. But I can't figure out how to do!

Here is an excerpt of my XML file:

<?xml version="1.0" encoding="utf-8"?>
<BENCH xmlns:VODPC_VOD="urn:VODPC:VOD:schema:20060809">
<VODPC_VOD:GRAPH state="running" currentFlowID="1" removeOnExit="FALSE">
</VODPC_VOD:GRAPH>
</BENCH>

When I load the file with MSXML6, no problem.
I try to access node BENCH with XPath "/BENCH" : no problem.
But when I try to access node VODPC_VOD:GRAPH with XPath "/BENCH/VODPC_VOD:GRAPH", I get an exception, which contain no valuable information:

First-chance exception at 0x75ac9617 in XXXXXX.exe: 0xE0000001: 0xe0000001.
First-chance exception at 0x75ac9617 in XXXXXX.exe: 0xE0000001: 0xe0000001.
First-chance exception at 0x75ac9617 in XXXXXX.exe: 0xE0000001: 0xe0000001.
First-chance exception at 0x75ac9617 in XXXXXX.exe: 0xE0000001: 0xe0000001.
First-chance exception at 0x75ac9617 in XXXXXX.exe: Microsoft C++ exception: _com_error at memory location 0x0025dac4..

I set these flags before to load:

m_pXMLDoc->async = VARIANT_FALSE;
m_pXMLDoc->preserveWhiteSpace = VARIANT_TRUE;
m_pXMLDoc->validateOnParse = VARIANT_TRUE;
m_pXMLDoc->resolveExternals = VARIANT_TRUE;

As you can understand, I work in C++. I'm an IT profesionnal since 18 year.

My problem is that I do not know what namespace is used in the file, so I don't want to have to tell MSXML6 what namespaces are used IN THE FILE. I guess it's its job, no ?

If anybody have an idea ...
Thanks a lot

Patrice

Re: Problem with MSXML6 + namespace + XPath

Stuart Dootson23-Feb-10 0:10

Stuart Dootson

23-Feb-10 0:10

You have to tell MSXML what namespace prefixes your XPath expressions use. When parsing XML, the parser remmebers the namespace URIs, NOT the prefixes used in the documents. That means that your code has to define the prefix to URI mappings used in your XPaths.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Problem with loading a xml to DataSet

alireza_shokoie15-Feb-10 23:42

alireza_shokoie

15-Feb-10 23:42

Hi all,

I've xml string and I can load it with XmlDataDocument.LoadXml successfully,
so that OuterXml shows the real xml string. But when I want to load in a dataset, the result dataset has no table(Tables.Count=0).
Typical code is as follows:

...
XmlDataDocument Doc = new XmlDataDocument();

/*
string Str = "<Result><DN>22800661</DN><ID>1</ID><Status><Line>Idle</Line></Status></Result>";
*/

Doc.LoadXml(Str);
DataSet datasetResult = Doc.DataSet;
if(datasetResult.Tables.Count == 0) return;
...

and it returns that means datasetResult.Tables.Count is always 0.

Can anyone help me, what is wrong?

Thanks in advance

Re: Problem with loading a xml to DataSet

daveyerwin18-Feb-10 2:51

daveyerwin

18-Feb-10 2:51

Maybe this is what you want ?

string Str = "<Result><DN>22800661</DN><ID>1</ID><Status><Line>Idle</Line></Status></Result>";
System.IO.StringReader sr = new System.IO.StringReader(Str);
XmlDataDocument Doc = new XmlDataDocument();
Doc.DataSet.ReadXml(sr);
DataSet datasetResult = Doc.DataSet;
if (datasetResult.Tables.Count == 0) return;

XSL help

Member 39976067-Feb-10 0:13

Member 3997606

7-Feb-10 0:13

Hello all you wonderful people

<br />
<br />
<?xml version="1.0" encoding="unicode"?><br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:osxml="osxml" version="1.0"><br />
<_locDefinition><br />
      <_locDefault _loc="locData"/><br />
      <_locTag _locAttrData="pad-left,pad-right">p</_locTag><br />
      <_locTag _locAttrData="height,width">textarea</_locTag><br />
      <_locTag _locAttrData="minsize,noindent">select</_locTag><br />
      <_locTag _locAttrData="size">progressbar</_locTag><br />
      <_locTag _locAttrData="size,maxlen">input</_locTag><br />
      <_locTag _locAttrData="value">osxml:update</_locTag><br />
</_locDefinition><br />
<xsl:template match="fve-bad-pcr-registers"><br />
<osxml:text-mode-ui><br />
  <head><br />
    <footer color="RGBIXXXX"><xsl:text> ENTER=Continue</xsl:text></footer><br />
    <meta key="ENTER" action="continue"/><br />
  </head><br />
  <body background-color="XXXX" foreground-color="RGBX"><br />
    <font foreground-color="RGBI"><br />
    Windows BitLocker Drive Encryption Information<br/><br />
    </font><br />
    <br/><br />
    <br/><br />
    The system boot information has changed since BitLocker was enabled.<br/><br />
    <br/><br />
    You must supply a BitLocker recovery key to start this system.<br/><br />
    <br/><br />
    Confirm that the changes to the system boot information are authorized.<br/><br />
    <br/><br />
    If the changes to the system boot information are trusted, then suspend and resume BitLocker. This will reset BitLocker to use the new boot information.<br/><br />
    <br/><br />
    Otherwise restore the system boot information.<br/><br />
    <br/><br />
  </body><br />
</osxml:text-mode-ui><br />
</xsl:template><br />
<br />
if User presses continue it goes to next line, if user press the "B" key then it goes to "progress-bar", otherwise quit.<br />
<br />
<xsl:template match="fve-bad-code-id"><br />

How do I prompt the user, trap a keypress and act upon the input in XML? What scripting language would you recommend to do this?
What do the loc lines do?

I am a newbie! John

I Need VB.net help

Re: XSL help

Stuart Dootson7-Feb-10 1:09

Stuart Dootson

7-Feb-10 1:09

XML is not a prgramming language - it's more a data format.

So…why are you using XML and what are you trying to achieve?

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

CodeProject MVP for 2010 - who'd'a thunk it!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.