How to Create an XML Editor application tool in C#.NET - XML / XSL Discussion Boards

First Prev Next

Qualified XML Root, InvalidOperationException while deserializing

abcxyz8220-Aug-08 9:49

abcxyz82

20-Aug-08 9:49

Class declaration:

[XmlRoot(Namespace="http://www.example.com/Person")]
class Person
{
 [XmlElement(Form=System.Xml.Schema.XmlSchemaForm.Unqualified)]
 Public string Name;
}

Serialized XML using XMLSerializer and XMLSerializerNamespace

<ns0:person xmlns:ns0="http://www.example.com/Person">
    <name>Bill</name>
</ns0:person>
</pre>

I am having trouble deserializing above XML and create an instance of Person class with Name property. Also I did not find a way to pass "ns0" namespace prefix to deserialization.

Any help or direction will greatly be appreciated in any .NET compliant language.

XSL Nesting Problem!

Saul Johnson19-Aug-08 6:00

Saul Johnson

19-Aug-08 6:00

Hi All!

I need to emulate the HTML and tags complete with all attributes and event handlers for a little project of mine and everything works fine when these elements are seperate, Here's my xsl stylesheet:

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

<xsl:template match="/HTML/BODY/EM">
		<EM ID="{@ID}" CLASS="{@CLASS}" TITLE="{@TITLE}" STYLE="{@STYLE}" DIR="{@DIR}" LANG="{@LANG}" ONCLICK="{@ONCLICK}" ONDBLCLICK="{@ONDBLCLICK}" ONMOUSEDOWN="{@ONMOUSEDOWN}" ONMOUSEUP="{@ONMOUSEUP}" ONMOUSEOVER="{@ONMOUSEOVER}" ONMOUSEMOVE="{@ONMOUSEMOVE}" ONMOUSEOUT="{@ONMOUSEOUT}" ONKEYPRESS="{@ONKEYPRESS}" ONKEYDOWN="{@ONKEYDOWN}" ONKEYUP="{@ONKEYUP}"><xsl:value-of select="self::EM"/></EM>
	</xsl:template>

<xsl:template match="/HTML/BODY/B">
		<B ONCLICK="{@ONCLICK}" ONDBLCLICK="{@ONDBLCLICK}" ONMOUSEDOWN="{@ONMOUSEDOWN}" ONMOUSEUP="{@ONMOUSEUP}" ONMOUSEOVER="{@ONMOUSEOVER}" ONMOUSEMOVE="{@ONMOUSEMOVE}" ONMOUSEOUT="{@ONMOUSEOUT}" ONKEYPRESS="{@ONKEYPRESS}" ONKEYDOWN="{@ONKEYDOWN}" ONKEYUP="{@ONKEYUP}" ID="{@ID}" CLASS="{@CLASS}" TITLE="{@TITLE}" STYLE="{@STYLE}" DIR="{@DIR}" LANG="{@LANG}" ><xsl:value-of select="self::B"/></B>
	</xsl:template>

</xsl:stylesheet>

Now this works fine when and are seperate, however when one tag is inside the other the result is no formatting at all!

The problem is that the match attribute of each xsl:template tag is only neing applied to B and EM tags in the BODY, is there any way I can apply the B and EM templates to the BODY and to all infinetly deeper nesting levels?

Thanks!

MrWolfy Big Grin | :-D

Re: XSL Nesting Problem!

led mike19-Aug-08 11:11

led mike

19-Aug-08 11:11

MrWolfy wrote:
the result is no formatting at all!

No formatting in what? A Browser? If so, looking at your XSL isn't helping us at all.

Post the HTML that is not rendering correctly and the browser version you are using.

led mike

Re: XSL Nesting Problem!

Frank Horn19-Aug-08 21:16

Frank Horn

19-Aug-08 21:16

<xsl:template match="/HTML/BODY/descendant::EM">

Re: XSL Nesting Problem!

Saul Johnson20-Aug-08 3:25

Saul Johnson

20-Aug-08 3:25

Hi and Thanks!

Thanks Frank! The code works perfectly! Problem Solved!

Thanks Again!

MrWolfy Big Grin | :-D

Re: XSL Nesting Problem!

Frank Horn20-Aug-08 8:05

Frank Horn

20-Aug-08 8:05

You're welcome. In case you can read German or French, this is where I learnt it all:

http://selfhtml.org/

I hardly ever use websites in my native language when it comes to software development cause anglophone sites are abundant and (when they have a forum) well populated, but this one is so good I took it on as my default HTML and XSL reference.

Re: XSL Nesting Problem!

led mike20-Aug-08 8:32

led mike

20-Aug-08 8:32

wow, I did not understand that was what he was asking at all. OMG | :OMG:

Nice catch!

led mike

How to Create an XML Editor application tool in C#.NET

debobrata18-Aug-08 23:56

debobrata

18-Aug-08 23:56

Hi,

I want to create an XML Editor Tool in C#.NET (similar to what we currently have in Visual Studio).
I want this editor tool to be integrated in my project.

The intention in creating the tool is that I want to view and edit the XML in this tool itself. I should
be able to directly modify the XML in this XML editor and thereby persist it back. And the changes should be
reflected accordingly.
It should have a collapse-Expand feature. And if possible it should also support Syntax based colours.

Hence, the tool should be able to open any XML in the proper format(proper parsing check should be there)
and edit them and save it back.

I currently work in VS 2008 in C#.

It will be really helpful if someone put the code in implementing the same and thanks in advance for any kind of suggestions.

Thanks,
Deb Wink | ;)

Re: How to Create an XML Editor application tool in C#.NET

tptshepo19-Aug-08 3:27

tptshepo

19-Aug-08 3:27

Hi debobrata

You could use an open source text editor component called FireBall. It has features like syntax highlighting for different languages XML being one of them and it also supports collapse-expand feature. You can open any XML with file with it. As for the validation, I'm afraid you gonna have to implement that your self but the rest should be easy enough.

Regards
tptshepo

Re: How to Create an XML Editor application tool in C#.NET

debobrata19-Aug-08 4:46

debobrata

19-Aug-08 4:46

Hi,

Can you please provide me the link for the "FireBall" text editor component so that i can download the source code for the same. And whether the source code is available for download or not.

I was trying googling for the same, but was not able to download the source code.

Please help me in that. Atleast i need to check the editor with the source code and then i can revert you back whether it has been helpful for me or not.

Thanks and Regards,
Deb

Re: How to Create an XML Editor application tool in C#.NET

tptshepo19-Aug-08 9:12

tptshepo

19-Aug-08 9:12

this link should get you started with the component

http://www.codeproject.com/KB/miscctrl/fireballcodeeditor.aspx[^]

Re: How to Create an XML Editor application tool in C#.NET

blackjack215019-Aug-08 20:21

blackjack2150

19-Aug-08 20:21

XML Notepad[^] (from MS) is now open source. Maybe it'll help you.

Re: How to Create an XML Editor application tool in C#.NET

debobrata20-Aug-08 0:27

debobrata

20-Aug-08 0:27

the source code I got for the XML Notepad from the Codeplex.com is not building.
Can you please zip and send me the entire source code for the XML Notepad in my email id
which is debobrata.bose@gmail.com

Thanks and Regards,
Deb

More than one xsd for a xml validation

vicky0000017-Aug-08 20:36

vicky00000

17-Aug-08 20:36

Hi,
I have a problem that i have three XSD for validate a XML. I use VC++
for validate the xml

IXMLDOMSchemaCollectionPtr pSchemaCache;
pSchemaCache.CreateInstance(__uuidof(XMLSchemaCache40));

//Add schema to schemacache

hr = pSchemaCache->add(L"",_variant_t(_T("Path\\xdm1.xsd")));

//xdm1.xsd is the XSD in which i import the other two xsd.

this code always fail I don't know why this is happend, can anyone know the reason,pleasse help me.

Thanks & regards
Vicky00000

How to generate XML File from table

Abdullah S. Abdelhay17-Aug-08 11:14

Abdullah S. Abdelhay

17-Aug-08 11:14

I have a table in database :

CREATE TABLE [LeftMenu] (
	[NodeID] [int] NOT NULL ,
	[ParentNodeID] [int] NULL ,
	[FK_LangID] [int] NULL ,
	[Text] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[lastlevel] [bit] NULL ,
	[linkLevel] [bit] NULL ,
	CONSTRAINT [PK_LeftMenu] PRIMARY KEY  CLUSTERED 
	(
		[NodeID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

and i want to generate XML file from this table with relation between 'NodeID' column and 'ParentNodeID' to fill ASP.net 2 Menu Control or TreeView Control
like this example:

<menu>
  <sub NodeID="1" ParentNodeID="" Text="aaa" />
  <sub NodeID="2" ParentNodeID="" Text="aaa" >
    <sub NodeID="3" ParentNodeID="2" Text="aaa" >
      <sub NodeID="20" ParentNodeID="3" Text="aaa" />
      <sub NodeID="20" ParentNodeID="3" Text="aaa" />
    </sub>
    <sub NodeID="10" ParentNodeID="2" Text="aaa" />
    <sub NodeID="12" ParentNodeID="2" Text="aaa" />
  </sub>
  <sub NodeID="4" ParentNodeID="" Text="aaa" />
  <sub NodeID="5" ParentNodeID="" Text="aaa" />
  <sub NodeID="6" ParentNodeID="" Text="aaa">
    <sub NodeID="14" ParentNodeID="6" Text="aaa" />
  </sub>
  <sub NodeID="7" ParentNodeID="" Text="aaa" />
  <sub NodeID="8" ParentNodeID="" Text="aaa" />
  <sub NodeID="9" ParentNodeID="" Text="aaa" />
</menu>

plz reply me.

Thank you
Abdullah Abdelhay

Re: How to generate XML File from table

tptshepo19-Aug-08 20:50

tptshepo

19-Aug-08 20:50

HI
Run this in a console app and change the connection string!

<pre>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace MenuGen
{
class Program
{
public static string Crlf = System.Environment.NewLine;

private class LeftMenuNode
{
public int NodeID = 0;
public string ParentNodeID = string.Empty;
public int FK_LangID = 0;
public string Text = string.Empty;
public bool LastLevel = false;
public bool LinkLevel = false;

public List<LeftMenuNode> SubMenus;

public LeftMenuNode()
{
SubMenus = new List<LeftMenuNode>();
}
}

//get the menu data from the database
static void GetDBMenus(ref DataSet ds)
{
string sql = "SELECT * FROM LeftMenu";
SqlCommand cmd = new SqlCommand(sql, new SqlConnection(@"data source=***;initial catalog=***;Integrated Security=True"));
cmd.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
ds.Clear();
using (adapter)
{
adapter.Fill(ds);
}
}

static void Main(string[] args)
{
DataSet dsMenus = new DataSet("Menu");
//get the list of menus
GetDBMenus(ref dsMenus);

//make sure we have a table to work with
if (dsMenus.Tables.Count == 0)
return;

//kick off the menu gen process
BuilMenuXML(ref dsMenus);

//now that we've buld a class structure we can work with
//all we have to do now if
}

static void BuilMenuXML(ref DataSet ds)
{
int tab = 0;
string xml = string.Empty;

xml = "<Menu>"
+ Crlf;

//populate our custom menu class
List<LeftMenuNode> menus = new List<LeftMenuNode>();
foreach (DataRowView row in ds.Tables[0].DefaultView)
{
LeftMenuNode menuItem = new LeftMenuNode();
menuItem.NodeID = Convert.ToInt32(row["NodeID"]);
menuItem.ParentNodeID = Convert.ToString(row["ParentNodeID"] == DBNull.Value ? "" : row["ParentNodeID"]);
menuItem.Text = Convert.ToString(row["Text"]);

tab++;

xml += TabChar(tab)
+ ""
+ Crlf;

//build sub menu items
BuilSubMenuItem(menuItem, ref ds, ref tab, ref xml);

xml += TabChar(tab)
+ ""
+ Crlf;

tab--;

//add main menu
menus.Add(menuItem);
}

xml += "</Menu>"
+ Crlf;

System.Diagnostics.Debug.Write(xml);

//output xml
Console.Write(xml);
Console.ReadLine();
}

//build sub menus - we need the dataset so we can search for sub menus
static void BuilSubMenuItem(LeftMenuNode node, ref DataSet ds, ref int tab, ref string xml)
{
//get a list of sub menus for the node we just passed at the top
DataView view = new DataView(ds.Tables[0], "ParentNodeID = " + node.NodeID,
"ParentNodeID", DataViewRowState.CurrentRows);

//add sub menus to the collection
foreach (DataRowView row in view)
{
LeftMenuNode menuItem = new LeftMenuNode();
menuItem.NodeID = Convert.ToInt32(row["NodeID"]);
menuItem.ParentNodeID = Convert.ToString(row["ParentNodeID"]);
menuItem.Text = Convert.ToString(row["Text"]);

tab++;

xml += TabChar(tab)
+ ""
+ Crlf;

//build sub menus for this sub menu
BuilSubMenuItem(menuItem, ref ds, ref tab, ref xml);

xml += TabChar(tab)
+ ""
+ Crlf;

tab--;

//add sub menu to collection
node.SubMenus.Add(menuItem);
}

}

private static string TabChar(int instance)
{
string text = "";

if (instance == 0) { return ""; }

for (int i = 0; i < instance; i++)
{
text += (char)9;
}
return text;
}
}
}

</pre>

xsl not formating xml file correctly into csv file

CodingLover15-Aug-08 16:54

CodingLover

15-Aug-08 16:54

Hi all,

I want to collect some data(not all) from an xml file and write them into a csv file. I used a xsl file formatting for that. Here is my xml file content.

<br />
<?xml version="1.0" encoding="ISO-8859-1"?><br />
<MAIN><br />
<CATALOG><br />
    <PLANT Tag="no"><br />
    <LIGHT>Time may differ</LIGHT><br />
        <PRICE>$2.44</PRICE><br />
    </PLANT><br />
    <PLANT Tag="no"><br />
    <LIGHT>Fixed time</LIGHT><br />
        <PRICE>$9.37</PRICE><br />
    </PLANT><br />
</CATALOG><br />
<CHAT><br />
    <SOME>Some Text</SOME><br />
    <MORE>More Text</MORE>    <br />
</CHAT><br />
</MAIN><br />
<br />

I want to get data on CATALOG element. So here is my style sheet.

<br />
<?xml version="1.0"?><br />
<xsl:stylesheet version = "1.0"<br />
    xmlns:xsl = "http://www.w3.org/1999/XSL/Transform"><br />
  <xsl:output method="text"/><br />
  <!--<xsl:strip-space elements = "CATALOG"/>--><br />
  <xsl:template match="/MAIN/CATALOG/PLANT"><br />
    <!--<xsl:text/><xsl:value-of select="normalize-space(PLANT)"/>"<xsl:text/>--><br />
    <xsl:value-of select="normalize-space(LIGHT)"/>";"<xsl:text/><br />
    <xsl:value-of select="normalize-space(PRICE)"/>" <xsl:text/><br />
    <xsl:text disable-output-escaping = "yes" ></xsl:text><br />
  </xsl:template><br />
</xsl:stylesheet><br />

But what happened here is, data on CHAT element also added to the file. I only want data on <LIGHT> and <PRICE> elements. But my style sheet gives data on <SOME> and <MORE> elements. How can I correct this.

Please help me too fix this. I'm stuck with this for two days.

Thanks

I appreciate your help all the time...
CodingLover Smile | :)

The 'http://schemas.xmlsoap.org/soap/envelope/:Envelope' element is not declared

^That's Aragon14-Aug-08 0:57

^That's Aragon

14-Aug-08 0:57

Hi All,

I am sending a SOAP based XML file to a web service.For that I have to validate this XML file to it's schema(XSD) file. But I am getting error like

The 'http://schemas.xmlsoap.org/soap/envelope/:Envelope' element is not declared

However there is a envelop in the XML file.

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
               xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
 <soap:Header>
    //Some nodes
 </soap:Header>
 <soap:Body>
   //Some nodes
 </soap:Body>
  </soap:Envelope>

Please assist me about this issue.

Regards Smile | :)

How to define the font types in xsl output.

CodingLover14-Aug-08 0:06

CodingLover

14-Aug-08 0:06

Hi all,

I've written a xsl file to convert xml content to word document. It's working fine. Now I want to change the font type. All text written in Times New Roman type, and I want to change them into Arial. How can I do it?

I appreciate your help all the time...
CodingLover Smile | :)

How to convert an xml file to sql table by C# ?

kakaleyte13-Aug-08 21:22

kakaleyte

13-Aug-08 21:22

I have an Test.xml file. I need to convert it to sql table and save all data by C#.How can i do it ??

Re: How to convert an xml file to sql table by C# ?

^That's Aragon14-Aug-08 1:09

^That's Aragon

14-Aug-08 1:09