_TAD_
asked on
XML and DataSets
I am receiving an xml string into a web service from some 3rd party software. I need to read that XML, change a value based on other values within the text and then return the xml string.
I can read the data into a data set just fine, but I'm having problems updating the data. Further, when I send the output the schema looks different. I can only assume that what I am receiving must be a SOAP string and what I am sending out is not. However, I don't know much about xml and data sets to really speak intelligently on the subject.
So.... Given that I recieve an xml string, I want to change values stored in the string and then return the "corrected" string, what is the best way to go about this? DataSet, xmlDocument, ADO recordset??
well written web sites or code snippets are all acceptable answers.
I can read the data into a data set just fine, but I'm having problems updating the data. Further, when I send the output the schema looks different. I can only assume that what I am receiving must be a SOAP string and what I am sending out is not. However, I don't know much about xml and data sets to really speak intelligently on the subject.
So.... Given that I recieve an xml string, I want to change values stored in the string and then return the "corrected" string, what is the best way to go about this? DataSet, xmlDocument, ADO recordset??
well written web sites or code snippets are all acceptable answers.
while your waiting for some solution to be posted might want to check this out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemxmlxmlnodeclassselectnodestopic1.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemxmlxmlnodeclassselectnodestopic1.asp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Mandalorian4. I'll take your suggestion into considderation.
quick question though.... How would I get the XML back out? I assume it would be using the WriteContentTo() funciton.
One of the hurdles I'm running into is that the program that I'm getting this info from is sending it as text, and I need to return the resultant as text. I'm sure I can pass everything to a memorystream and convert it to ascii from there, but I rather thought that there must be a direct way to output xml as text right from the xml objects (instead of always duming them to a file somewhere, which seems to be the standard).
i've been trying to figure out a solution using xmlDoc.SelectNodes(Xpath,N
but i can't seem to figure out the right Xpath to list the nodes, but maybe someone out there could..
i've tried this approach before and it works with a very few lines needed, the problem is that in that code i made, i didnt have namespaces
but i can't seem to figure out the right Xpath to list the nodes, but maybe someone out there could..
i've tried this approach before and it works with a very few lines needed, the problem is that in that code i made, i didnt have namespaces
TAD,
to return your XML document back to text without any pesky IO activity try this:
MemoryStream ms = new MemoryStream()
//After you tweak your doc
xmldoc.Save(ms);
I also looked for a way to go from XMLDocument -> string without saving to a file but could not find a way.
Going from MemoryStream to string shouldn't be too difficult and I did not notice any preformance hit when I developed an application that required XMLDoc -> MemoryStream -> String
Hope that helps
Mandalorian
to return your XML document back to text without any pesky IO activity try this:
MemoryStream ms = new MemoryStream()
//After you tweak your doc
xmldoc.Save(ms);
I also looked for a way to go from XMLDocument -> string without saving to a file but could not find a way.
Going from MemoryStream to string shouldn't be too difficult and I did not notice any preformance hit when I developed an application that required XMLDoc -> MemoryStream -> String
Hope that helps
Mandalorian
ASKER
mandalorian,
I got the expected output. Thanks!
Instead of writing to a memory stream, I just wrote out to a stringbuilder object.
(I only added the last 3 lines the rest is your code)
XmlDocument xmlDoc = new XmlDocument();
try
{
xmlDoc.LoadXml(xmlText);
Traverse(xmlDoc.DocumentEl
}
catch(Exception err)
{
MessageBox.Show("Blow-up " + err.Message);
}
StringBuilder xmlOutput = new StringBuilder();
xmlDoc.WriteContentTo(new XmlTextWriter(new StringWriter((xmlOutput)))
return xmlOutput.ToString();
ASKER
I still feel a bit put out that I can't just drop this in a dataset, make my changes and send the output back to the source. A dataset would have been a lot easier.... unfortunately the dataset technique seems to change the text of the schema (different standard perhaps??), and that is simply unacceptable for this situation.
Using a xmlDocument is clearly the way I need to go, unfortunately creating it in such a fashion as to be usable for many different applications is going to be difficult or perhaps even impossible given the limitations of the third party tool that I need to use.
any way... thanks for all of your help!
hi, im really intrigued by you problem because my solution (XmlDocument, Dataset and Xpath) can't work with your situation.
is it ok if i ask for the webservice address?
is it ok if i ask for the webservice address?
ASKER
You won't be able to get to the web service, it's on our internal network.
As for getting your type of solution to work....
I provided the input xml string. The output needs to look *exactly* like the input. The only difference is the VALUE_TEXT="John" needs to look like: VALUE_TEXT="Bob".
The reason the xml output needs to look exacty like the input is because the third party tool I'm getting the data from expects the xml file to have the exact schema returned to it.
FYI.... I am using Adobe Acrobat and I am parsing the adobe FDF file (the xml file behind the pdf template that holds all data on the pdf form).
As for getting your type of solution to work....
I provided the input xml string. The output needs to look *exactly* like the input. The only difference is the VALUE_TEXT="John" needs to look like: VALUE_TEXT="Bob".
The reason the xml output needs to look exacty like the input is because the third party tool I'm getting the data from expects the xml file to have the exact schema returned to it.
FYI.... I am using Adobe Acrobat and I am parsing the adobe FDF file (the xml file behind the pdf template that holds all data on the pdf form).
// -- TAD just wanted to share this, i have seeked the help of another expert to solve why i didn't get my solution that i was
// -- supposed to suggest for this problem
--------------------------
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"C:\wherever\
XmlNode root = xmlDoc.DocumentElement;
XmlNamespaceManager nsmngr = new XmlNamespaceManager(xmlDoc
nsmngr = GetNamespaces(xmlDoc); // -- a function (definition on the bottom part)
// -- the next line of code searches for a <z:row > nodes with attrbute PARAM = "txtRequesterFName"
// -- irregardless which node level it maybe, the Xpath expression can be modified for any node or attribute you want to find
XmlNodeList nodeList = root.SelectNodes("//z:row[
foreach (XmlNode node in nodeList)
{
node["txtRequesterFName"] = "<New Value you want to assign>";
}
// ... the rest of your code
--------------------------
// -- function mentioned above getting the namespaces defined in the XML
public static XmlNamespaceManager GetNamespaces(XmlDocument doc)
{
XmlNamespaceManager namespaceManager =
new XmlNamespaceManager(new NameTable());
XPathNavigator nav2 = doc.DocumentElement.Create
if (nav2.MoveToFirstNamespace
{
do
{
if (! nav2.Name.StartsWith("xml"
{
namespaceManager.AddNamesp
}
} while (nav2.MoveToNextNamespace(
}
return namespaceManager;
}
// -- code ends
// -- hope that might be of use
// -- supposed to suggest for this problem
--------------------------
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"C:\wherever\
XmlNode root = xmlDoc.DocumentElement;
XmlNamespaceManager nsmngr = new XmlNamespaceManager(xmlDoc
nsmngr = GetNamespaces(xmlDoc); // -- a function (definition on the bottom part)
// -- the next line of code searches for a <z:row > nodes with attrbute PARAM = "txtRequesterFName"
// -- irregardless which node level it maybe, the Xpath expression can be modified for any node or attribute you want to find
XmlNodeList nodeList = root.SelectNodes("//z:row[
foreach (XmlNode node in nodeList)
{
node["txtRequesterFName"] = "<New Value you want to assign>";
}
// ... the rest of your code
--------------------------
// -- function mentioned above getting the namespaces defined in the XML
public static XmlNamespaceManager GetNamespaces(XmlDocument doc)
{
XmlNamespaceManager namespaceManager =
new XmlNamespaceManager(new NameTable());
XPathNavigator nav2 = doc.DocumentElement.Create
if (nav2.MoveToFirstNamespace
{
do
{
if (! nav2.Name.StartsWith("xml"
{
namespaceManager.AddNamesp
}
} while (nav2.MoveToNextNamespace(
}
return namespaceManager;
}
// -- code ends
// -- hope that might be of use
ASKER
<xml xmlns:s="uuid:BDC6E3F0-6DA
All I want to do is locate the PARAM element that equals "txtRequesterFName" and change the VALUE_TEXT elements's value to something else (e.g. 'Bob' instead of 'John')