|
|
I am having a hard time converting a string representation of a xml-document into a dataset.
The case is:
1. I send a request to a server which answers with a xml-document in the form of a string.
2. Next I want to convert this string into a System.Data.DataSet and display it in a datagrid or some other.
It is giving me a really hard time figuring out how to do this.
I have tríed the following:
{
System.Xml.XmlDataDocument xmlDD = new System.Xml.XmlDataDocument();
System.Data.DataSet dsXML = new System.Data.DataSet();
xmlDD.LoadXml(strXml);
dsXml = xmlDD.DataSet;
}
This will generate following error "The IListSource does not contain any data sources."
I have tried the following, it works, but is a VERY bad idea for a webpage:
{
xmlDD.LoadXml(strXml);
xmlDD.Save(Server.MapPath("log") + "\\out.xml");
dsXml.ReadXml("\\out.xml");
}
Why can't I go directly from a string through a xmldocument to a dataset?
Any comments appreciated.
Preben Rasmussen
IT-consultant
|
|
|
|
|
One of the overloads of the ReadXml method accepts a TextReader object. The StringReader class is derived from TextReader, so you can just do:
System.IO.StringReader sr = new System.IO.StringReader(strXml);
System.Data.DataSet dsXML = new System.Data.DataSet();
dsXML.ReadXml(sr);
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Thanks a lot - it works great. Just what I wanted.
Preben Rasmussen
|
|
|
|
|
I also find it annoying that there isn't a simple way of loading a dataset from a string. Here's one way that's a bit of a rigmarole but it does the job:
Dim srForData As System.IO.StringReader = New System.IO.StringReader(StringToLoadFrom)
Dim rdrForData As System.Xml.XmlReader = New System.Xml.XmlTextReader(srForData)
DataSetToLoad = New DataSet()
DataSetToLoad.ReadXml(rdrForData)
|
|
|
|
|
This one also works fine - thanks.
Preben Rasmusen
|
|
|
|
|
Ok, so I have this app that you fill in your subject and then the message and then it formats it in the particular way i told it to, onto my webserver as a .xml file....
XmlTextWriter writer = new XmlTextWriter("poofacedjohn.xml", null);
But, what I need is for the name of the xml file not to be poofacedjohn.xml, but rather the year, month, day, hour, and minute of the local machine...
like.....
20030426_1718.xml
2003 04 26 17 18
|year||month||day|_|hour||minute|
how would I acheive this...? I can do it in asp.net, but it's not working for me as just a regular windows app.
/\ |_ E X E GG
|
|
|
|
|
How are you trying do it, and what errors are you getting?
|
|
|
|
|
Im not getting an error, because I don't know how to do it.... that's my problem... any suggestions?
/\ |_ E X E GG
|
|
|
|
|
Try:
string name = DateTime.Now.ToString("yyyyMMdd_hhmm") + ".xml";
XmlTextWriter writer = new XmlTextWriter(name, null);
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
ok, i'll try it when I get home.
/\ |_ E X E GG
|
|
|
|
|
Wow, I can't believe I didn't think of that myselft...
that's just what I needed, thanks dude.
/\ |_ E X E GG
|
|
|
|
|
Wait, one more thing...
I have this programed saved in ...
C:\Inetpub\wwwroot\WebLog\Entries\bin
and it's working fine, but I need the .xml to be saved in....
C:\Inetpub\wwwroot\WebLog\Entries
How can I change the following to save the .xml file in the \Entries folder?
string fileName = DateTime.Now.ToString("yyyyMMdd_hhmm") + ".xml";<br />
XmlTextWriter writer = new XmlTextWriter(fileName, null);
/\ |_ E X E GG
|
|
|
|
|
Wait, nevermind... I figured it out myself...
string fileName = DateTime.Now.ToString("yyyyMMdd_hhmm") + ".xml";<br />
XmlTextWriter writer = new XmlTextWriter("C:/inetpub/wwwroot/weblog/entries/"+ fileName, null);
/\ |_ E X E GG
|
|
|
|
|
I have a xml file which has at the top but the file contains all printable ascii characters except one line.(This line is optional)
I am converting this file into html using xsl.
My xsl files top line is like this
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
However, when this non-printable ascii character exists xslt conversion does not work. When it is absent it works.
I searched google but no luck. How can I solve this?
Orcun Colak
|
|
|
|
|
I have a weblog thing I made in C#, ASP.NET, it works fine and everthing and stores each entry into and .xml file. Now usually I edit and make new entrys though internet explorer, but then I though how cool would it be to make an application in C# to take the .xml file edit it in the program, then click the save button and have it update the .xml!
Does anybody have any tips or places to look, for help on this???
/\ |_ E X E GG
|
|
|
|
|
Hi,
I need process two nodelists. so I have to open two
XmlDocuments at the same time.
Why does this code crash?
string filename = "D:\test.xml";
XmlDocument doc = new XmlDocument();
doc.Load(filename);
XmlNodeList nl = doc.SelectNodes("TestSequence");
string filenameOpt = "D:\Options.xml";
XmlDocument docOpt = new XmlDocument();
docOpt.LoadXml(filename);
readXML(nl);
|
|
|
|
|
One thing that is wrong is that the filename strings are not properly escaped.
Try changing
string filename="D:\test.xml"
to
string filename=@"D:\test.xml"
or
string filename=@"D:\\test.xml"
You will also need to do the same for "D:\Options.xml"
"\t" will translate to a tab character, which will cause the load of the first document to fail as it can not find the file, or possibly that the filename is invalid.
Another problem is that when you are loading the second document you are using LoadXml and not Load. "D:\Options.xml" is not a valid xml string.
I have made both these mistakes far too many times myself 
Regards
Mark Smithson
|
|
|
|
|
thanks for your fast help!!
but i made an incomplete request - sorry
you were of course right but my problem appears
after i load my 2nd XmlDocument (see now a completer version)
string filename = @"D:\test.xml";
XmlDocument doc = new XmlDocument();
doc.Load(filename);
XmlNodeList nl = doc.SelectNodes("TestSequence");
string filenameOpt = @"D:\Options.xml";
XmlDocument docOpt = new XmlDocument();
docOpt.Load(filenameOpt);
//crash 
readXML(nl);
|
|
|
|
|
Have you made sure that the second document is valid xml? The best way to do this would be to load the document in internet explorer. You will get an error if the document is not valid.
What exception message are you getting when the code crashes? This can usually lead you to the source of the problem.
Regards
Mark Smithson
|
|
|
|
|
you are right again - the XML was not valid
thanks and regards
|
|
|
|
|
:-Oyou are right again - the XML was not valid
thanks and regards
|
|
|
|
|
in the web are too many tutorials about that, see this
GO TO[^]
(spanish)
Para seguir la trayectoria:
mira al maestro,
sigue al maestro,
camina junto con el maestro,
mira a través del maestro,
conviértete en el maestro
(this is a poor traduction)
To make you trayectory:
Look your master
Follow your master
walk whit your master
look across you master
become in your master
|
|
|
|
|
I have put off learning XML for as long as I could. I don't know why, I just did.  Anyhow, everywhere I turn, there it is, so it's high time I get my butt in gear and read up on it.
Any suggestions on a good place to start? Books? Web sites (besides w3c - already started reading the spec)? CP articles?
[EDIT]
Web site: http://www.w3schools.com/[^]
[/EDIT]
Thanks,
Jon Sagara
They gave me penicillin because I have sniffilis.
-- A friend's response when asked why he went to the doctor
|
|
|
|
|
I've worked with XML a lot, but I've only read the XML Parser SDK. It also has info about XSL, but I'm finding that part a little hard to digest. So I'd be interested in both XML and XSL books/websites/etc. too, but especially about XSL.
"Do unto others as you would have them do unto you." - Jesus
"An eye for an eye only makes the whole world blind." - Mahatma Gandhi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
