use XMLDocument class in Axapta
if u know Xml format in advance , u can get the values of the tag by using
getElementByTagName
say for suppose XML is
say for suppose u have table with EmployeeTable with EmpId and Name as fields..
<Data>
<EmpDetails>
<EmpId>4063</EmpId>
<Name>Sreenath</Name>
</EmpDetails>
<EmpDetails>
<EmpId>4063</EmpId>
<Name>Sreenath</Name>
</EmpDetails>
</Data>
code will ne similar to this
xmldocument xmldoc;
EmployeeTable emptable;
;
xmldoc = xmldocument();
u have to load xml
xmldoc.load(path);// from where u want to load xml
//now if u want to insert the XML data in to table..
emptable.EmpId = xmldoc.getElementByTagName("EmpId").item(0).text();
emptable.Name = xmldoc.getElementByTagName("Name").item(0).text();
empltable.insert();
i am not sure about the syntax as i am mailing from home..i am not infront of Axapta.
the tag name and the getelementbytagname shud be simliar and its case sensitive..
in tha above XML it has two records...
For Multiple Record insertion in the table.
inorder to do that u have to get the count of childs in the tagnames..
like..
int xmlchildrencount = xmldoc.getElementByTagName("EmpDetails").item(0).childnodes().count();//Not sure of the syntax..u can find it out
the u can loop thru as many records..
for(i = 0;i <= xmlchildrencount ; i++)
{
emptable.EmpId = xmldoc.getElementByTagName("EmpId").item(0).text();
emptable.Name = xmldoc.getElementByTagName("Name").item(0).text();
empltable.insert();
}
if u want clear working ...in.out XML..i shall give u tomorrow ..
[EMAIL PROTECTED] wrote:
Hi,
i want to store some values in xml and retrieve it. how to do? provide the
solution. thank u.
regs,
Hema. S
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Sneak preview the all-new Yahoo.com. It's not radically different. Just radically better.
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
