XML / XSL

Re: Show XML as excel sheet

11-Feb-05 23:33

Hi,

There isn't an XmlTextWriter constructor that takes a FileInfo as a parameter. There's a choice of three constructors, it looks like you probably want to use this one:
public XmlTextWriter(string filename, Encoding encoding);

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

Show XML as excel sheet

Anonymous11-Feb-05 8:10

Anonymous

11-Feb-05 8:10

I have a program that creates xml that can be loaded into excel and viewed as a spreadsheet. It is to be viewed as a web page and I set the mime type, no problem. But garbage is output - something is being lost in translation. Any ideas?

Wilbur J. Pereira13-Feb-05 8:21

Problem while Working with XmlValidatingReader!!!!!

13-Feb-05 8:21

Could u possibly attach a snippet of ur code or just mail it to me so as to get a clear picture of what's actually happening. this would help me identify the glitch.

Regards
Wilbur

abcxyz8211-Feb-05 5:00

abcxyz82

11-Feb-05 5:00

I am experimenting with "XmlValidatingReader" and want to create a event handler which gets called there occurs some validation error(schema mismatch etc..) But could not find where this class is located??

I am using .NET framework 2.0, VS 2005 beta1..

Is there any other way to validate xml with schema?

REgards.
MaulikCE

Re: Problem while Working with XmlValidatingReader!!!!!

Phil Hobgen12-Feb-05 2:24

Re: Problem while Working with XmlValidatingReader!!!!!

12-Feb-05 2:24

Hi,

The XmlValidatingReader class is obsolete in v2.0.

You can read about validating xml in v2.0 here:
http://msdn2.microsoft.com/library/hdf992b8.aspx[^]

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

abcxyz8214-Feb-05 4:17

abcxyz82

14-Feb-05 4:17

Phil,

Thanks for posting the link, meanwhile i have done with XmlValidatingREader.

But surprisingly Newer version i.e. XMLReaderSettings is not catching any XML errors, that are caught by XmlValidatingReader.

Can you throw some light!!!!

REgards.
MaulikCE

Re: Problem while Working with XmlValidatingReader!!!!!

Phil Hobgen14-Feb-05 23:06

problems with IXMLDOMDocumentPtr ->loadXML

14-Feb-05 23:06

Hi,

Sorry, I haven't started working with it yet. I'd merely made myself a note that XmlValidatingReader will have to be replaced when I move some existing code to v2.0

Good Luck

Phil Hobgen
barbari.co.uk
Southampton, UK

mc.george11-Feb-05 2:26

mc.george

11-Feb-05 2:26

hey,

I have wrote an application. In this I get a XML-Stream witch is stored in LPSTR-Variable. Is the StreamSize very great (more than 500k), I get an exception during:
loadXML(LPSTR XMLStream)

//************ code *******************//

LPSTR XMLStream; //get from external programm

if(!XMLStream)
return E_FAIL;

IXMLDOMDocumentPtr pDOMDoc(__uuidof(DOMDocument));
pDOMDoc->put_async(VARIANT_FALSE);

//load XML-Stream
//this will cause the exception
varResult = pDOMDoc->loadXML((_bstr_t)(XMLStream));

if(VARIANT_FALSE == varResult)
{
//do somthing
}
else if(VARIANT_TRUE == varResult)
{
//do somthing
}
//*****************************************************//

Is it possible, that there is some troubleshooting with the Header-Identifier
"encoding="ISO-8859-1" ??????

Thanks

Re: problems with IXMLDOMDocumentPtr ->loadXML

Wilbur J. Pereira13-Feb-05 8:07

making the XML files more unique

13-Feb-05 8:07

Could u possibly give me a better description of ur error or say the error message. Please chk for the well formedness or ur xml data. Most of the errors are caused becoz of the fact that the xml data or file does not contain well formed xml data and that the encoding sure is no big deal.

Regards Wilbur

equit11-Feb-05 0:36

equit

11-Feb-05 0:36

Ive got an rather big problem...
While customers are editing there profiles there XML-files containing the mutations created.
(see code below)

///

/// Creates XML doc and sends it to remote system
///

/// <param name="objMelding" />
private void CreateAndSendXml(Werknemer objWerknemer)
{
const string tableName = "Werknemer";
string xmlFilePath;
string xmlpath;

//try
//{
System.Xml.XmlDocument doc = objWerknemer.CreateXml();

xmlpath = ConfigurationSettings.AppSettings["mailDir"];
if (File.Exists(xmlpath+"busy.txt"))
xmlpath=xmlpath + "ifbusy\\";

xmlFilePath = xmlpath + tableName +
DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() +
DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() +
DateTime.Now.Minute.ToString() + DateTime.Now.Millisecond.ToString()+".xml";

//Delete xml file if it already exists
if ( File.Exists(xmlFilePath) )
File.Delete(xmlFilePath);
doc.Save(xmlFilePath);
//}
/*catch (Exception e)
{
Log.WriteEntry(new System.Exception("Fout bij schrijven XML\r\n"+e.Message));
throw new System.Exception("Kan XML bestand om wijzigingen te verzenden niet aanmaken, probeer later nog eens te verzenden");
}
*/

}

My problem is that WHEN there more than one customer editing at the EXACT same time one of the doubles are being deleted.
(see code below)

//Delete xml file if it already exists
if ( File.Exists(xmlFilePath) )
File.Delete(xmlFilePath);
doc.Save(xmlFilePath);
//}
/*catch (Exception e)

I want to make this XML-files more unique by adding an sessionid or userid to creationdate (see code below)

xmlFilePath = xmlpath + tableName +
DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() +
DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() +
DateTime.Now.Minute.ToString() + DateTime.Now.Millisecond.ToString()+".xml";

It is here in this piece of code above i want to make an adjustment to set the SessionID or UserID to the String.
I just cant find the proper code to do this can someone help me????
The only thing i want is to prevent the XML-Files from beeing deleted!
You can mail me for an answer aswell by mailing: ferry@verzuimdata.nl
THANK YOU VERY MUCH

http://www.verzuimdata.nl

Re: making the XML files more unique

Wilbur J. Pereira13-Feb-05 8:01

msxml error in creating xml

13-Feb-05 8:01

is'nt tha above code working for u ?. if not then let me know what's actually goin wrong using the above piece of code to create ur filename. if not gimme a better description of ur error or whatever the output is when using the above piece of code to generate a unique filename.

Regards Wilbur

cj_rahul10-Feb-05 22:20

cj_rahul

10-Feb-05 22:20

Hello , iam a new vc++ programmer,
I want to creaet an xml file using mxxml3.0
I had used every possible way 2 do that , every time
the functionc
CreateProcessingInstruction
&
raw_CreateProcessingInstruction

are throughing the run time exception.
plz help me i am trying 4 that since last 6 days. any sugestion would be helpful.
any place 2 find the proper code rather than msdn ,
i don't want 2use wrapper class 4 this.

Rahul Agarwal

Re: msxml error in creating xml

Wilbur J. Pereira13-Feb-05 7:54

Custom UsernameTokenManager Problem

13-Feb-05 7:54

have u tried checking the well formedness of the xml file or xml data. please chk for the well formed ness of ur xml data and then try getting ur work done. I'm not sure as to whether u've done some exception handling stuff say like try..catch..finally n stuff. this would give u the correct output for ur error.

Regards Wilbur

Gizz10-Feb-05 5:03

Gizz

10-Feb-05 5:03

Hi all.

WSE 2.0 on .Net 1.1 SP1, C#, Win XP Pro.

In a web service, I have a custom UsernameTokenManager, override AuthenticateToken, set up all the relevant stuff to make it use the WSE, but it never calls AuthenticateToken, simply fails on the standard default AuthenticateToken.

Microsoft.Web.Services2.Security.SecurityFault: The security token could not be authenticated or authorized at Microsoft.Web.Services2.Security.Tokens.UsernameTokenManager.OnLogonUserFailed(UsernameToken token)

Am I missing anything simple?

My custom UsernameTokenManager:

[SecurityPermissionAttribute(SecurityAction.Demand, Flags=SecurityPermissionFlag.UnmanagedCode)]<br />
	public class UsernameManager : UsernameTokenManager<br />
	{<br />
		protected override string AuthenticateToken(UsernameToken token)<br />
		{<br />
			// Ensure the SOAP message contained a UsernameToken.<br />
			if (token == null)<br />
				throw new ArgumentNullException();<br />
			return "password";<br />
		}<br />
	}<br />

In my web service web.config file I have

<microsoft.web.services2><br />
    <diagnostics /><br />
    <security><br />
      <securityTokenManager type="WebServiceNamespace.UsernameManager, WebServiceDllName" xmlns:wsse="http://schemas.xmlsoap.org/ws/2003/06/secext" qname="wsse:UsernameToken" /><br />
    </security><br />
  </microsoft.web.services2>

My proxy class for the service is derived from WebServicesClientProtocol.

In my call to the web service, I do this:

Myservice svc = new Myservice();<br />
UsernameToken tok = new UsernameToken("admin", "password", <br />
		PasswordOption.SendPlainText);<br />
svc.RequestSoapContext.Security.Tokens.Add(tok);<br />
svc.AFunctiononTheService();

I guess its something simple that I'm missing, but I'm struggling to identify it!

Help! D'Oh! | :doh:

Re: Custom UsernameTokenManager Problem

doogie10-Feb-05 6:32

doogie

10-Feb-05 6:32

hi!!!

Try changing your xmlns for this one :

xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"

bye

Re: Custom UsernameTokenManager Problem

Gizz24-Feb-05 2:56

Gizz

24-Feb-05 2:56

Thanks, that was spot on! Big Grin | :-D

Problem in inserting tabindex for column Header in data grid

Member 17164038-Feb-05 3:20

Member 1716403

8-Feb-05 3:20

i m facing the Problem in inserting tabindex for column Header in data grid
Actually i want to move thr cursor on column header in data grid .
Help me.
Amit

XML/XSL Books

Brendan Vogt6-Feb-05 22:55

Brendan Vogt

6-Feb-05 22:55

I looking for a good beginners to advanced book on the XML/XSL. It should have thorough explanations and working examples (with ISBN numbers please). I'm intending using it either with Java or C#. Any comment on this?

Brendan

Phil Hobgen7-Feb-05 19:00

7-Feb-05 19:00

Hi,

I bought Wrox (Programmer to Programmer) Professional XML in the year 2000, and I would recomend it. I don't think it's available now but has been split into various versions aimed at Java, Apache, ASP, etc. I'm guessing that most of the content is much the same in the other books.

FYI the authors of my copy are:
Didier Martin, Mark Birbeck, Michael Kay, Brian Loesgen, Jon Pinnock, Steven Livingstone, Peter Stark, Kevin Williams, Richard Anderson, Stephen Mohr, David Baliles, Bruce Peat,Nikola Ozu.

I would think that anything with a combination of some of these authors would be good.

If you're doing XSLT then Michael Kay's book (Wrox) XSLT Programmers Reference is one of the best programmers books that I've ever come across.

Cheers

Phil Hobgen
Southampton, UK

Brendan Vogt7-Feb-05 21:22

Brendan Vogt

7-Feb-05 21:22

Can you maybe supply me the ISBN number of this book you mentioned?

What skills do you specialise in?

Phil Hobgen7-Feb-05 22:39

7-Feb-05 22:39

Brendan Vogt wrote:
Can you maybe supply me the ISBN number of this book you mentioned?

1-861003-11-0
I think it's out of print but still listed on Amazon (UK) as available "used and new" very cheaply. A few parts of the book will be outdated, unless there was a 2nd edition. An alternative might be Professional ASP.NET 1.0 XML with C# (1-861007-24-8), which has some of the same authors involved - but I haven't read it!

Brendan Vogt wrote:
What skills do you specialise in?

Delphi for Win32 apps and C# for Web & Windows Forms; + XML, SQL Server, etc.

Cheers

Phil Hobgen
Southampton, UK