convert string to datatable

  • Thread starter Thread starter Hemant
  • Start date Start date
H

Hemant

Hi,

I have a string it contain following string .

<taSopLineIvcInsert><SOPTYPE>2</SOPTYPE><SOPNUMBE>123456
</SOPNUMBE><CUSTNMBR>345</CUSTNMBR><DOCDATE>10/10/2009</DOCDATE><ITEMNMBR>2342</ITEMNMBR><UNITPRCE>5.20</UNITPRCE><XTNDPRCE>10.40</XTNDPRCE><QUANTITY>2.000</QUANTITY><ITEMDESC>Story
Book</ITEMDESC><TAXAMNT>0.81</TAXAMNT><LNITMSEQ>2343</LNITMSEQ></taSopLineIvcInsert>

i want to select this string and want to show this in csv file . for this i
and doing string manuplation and find this substring and than add this to a
xml file and that converting this xml file to table and than showing the
data in csv file.

Is there another easy method?

Thanks,

Hemant
 
Hi,

I have a string it contain following string .

<taSopLineIvcInsert><SOPTYPE>2</SOPTYPE><SOPNUMBE>123456
</SOPNUMBE><CUSTNMBR>345</CUSTNMBR><DOCDATE>10/10/2009</DOCDATE><ITEMNMBR>2­342</ITEMNMBR><UNITPRCE>5.20</UNITPRCE><XTNDPRCE>10.40</XTNDPRCE><QUANTITY>­2.000</QUANTITY><ITEMDESC>Story
Book</ITEMDESC><TAXAMNT>0.81</TAXAMNT><LNITMSEQ>2343</LNITMSEQ></taSopLineI­vcInsert>

i want to select this string and want to show this in csv file . for thisi
and doing string manuplation and find this substring and than add this toa
xml file and that converting this xml file to table and than showing the
data in csv file.

Is there another easy method?

Thanks,

Hemant
Click to expand...

I think you can also do it making a loop through the document

Something like this

XmlNode p = xmlDoc.SelectSingleNode("//taSopLineIvcInsert");
foreach (XmlNode n in p)
{
Response.Write(n.Name + "/t" + n.InnerText + "/n");
}

if you add

Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=doc.csv");
Response.ContentType = "application/vnd.ms-excel";

you should get an xml

Hope this helps
 
Back
Top