Need help with xml

Ruchita Kumar

(Type your message here)

--------------------------------
From: ruchita kumar
hi friends
its my first time working with xml and dot net i have to work on data migration
but i m having problems converting this xml code to dataset table the xml code
is as follows

Expand|Select|Wrap|Line Numbers

 <ENVELOPE>

 <HEADER>

  <TALLYREQUEST>Import Data</TALLYREQUEST>

 </HEADER>

 <BODY>

  <IMPORTDATA>

   <REQUESTDESC>

    <REPORTNAME>All Masters</REPORTNAME>

    <STATICVARIABLES>

     <SVCURRENTCOMPANY>SAHARA CONTAINER P.LTD</SVCURRENTCOMPANY>

    </STATICVARIABLES>

   </REQUESTDESC>

   <REQUESTDATA>

    <TALLYMESSAGE xmlns:UDF="TallyUDF">

     <VOUCHER REMOTEID="766a4181-162f-11da-bd9f-00409533948b-00000a6c"

VCHTYPE="Payment" ACTION="Create">

      <ISOPTIONAL>No</ISOPTIONAL>

      <USEFORGAINLOSS>No</USEFORGAINLOSS>

      <USEFORCOMPOUND>No</USEFORCOMPOUND>

      <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>

      <DATE>20040402</DATE>

      <EFFECTIVEDATE>20040402</EFFECTIVEDATE>

      <ISCANCELLED>No</ISCANCELLED>

      <USETRACKINGNUMBER>No</USETRACKINGNUMBER>

      <ISPOSTDATED>No</ISPOSTDATED>

      <ISINVOICE>No</ISINVOICE>

      <DIFFACTUALQTY>No</DIFFACTUALQTY>

      <PARTYLEDGERNAME>THE MUMBAI C0-OP BANK LTD</PARTYLEDGERNAME>

      <NARRATION>Ch. No. :256514 S.B.I. INCOME TAX A/C TOWARDS PAYMENT OF I.TAX FOR THE MONTH OF FEB. 04 AS PER DETAIL ATTACHED</NARRATION>

      <ENTEREDBY>Jadav</ENTEREDBY>

      <ASPAYSLIP>No</ASPAYSLIP>

      <GUID>766a4181-162f-11da-bd9f-00409533948b-00000a6c</GUID>

      <ALTERID>2963</ALTERID>

      <ALLLEDGERENTRIES.LIST>

       <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>

       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>

       <LEDGERFROMITEM>No</LEDGERFROMITEM>

       <LEDGERNAME>T.D.S. ON SALARY</LEDGERNAME>

       <AMOUNT>-21635.00</AMOUNT>

       <CATEGORYALLOCATIONS.LIST>

        <CATEGORY>INCOME TAX</CATEGORY>

        <COSTCENTREALLOCATIONS.LIST>

         <NAME>STAFF.</NAME>

         <AMOUNT>-21635.00</AMOUNT>

        </COSTCENTREALLOCATIONS.LIST>

       </CATEGORYALLOCATIONS.LIST>

      </ALLLEDGERENTRIES.LIST>

      <ALLLEDGERENTRIES.LIST>

       <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>

       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>

       <LEDGERFROMITEM>No</LEDGERFROMITEM>

       <LEDGERNAME>THE MUMBAI C0-OP BANK LTD</LEDGERNAME>

       <AMOUNT>21635.00</AMOUNT>

      </ALLLEDGERENTRIES.LIST>

      <UDF:BANKERSDATE.LIST DESC="`BANKERSDATE`" ISLIST="YES">

       <UDF:BANKERSDATE DESC="`BANKERSDATE`">20040407</UDF:BANKERSDATE>

      </UDF:BANKERSDATE.LIST>

     </VOUCHER>

    </TALLYMESSAGE>

    <TALLYMESSAGE xmlns:UDF="TallyUDF">

     <VOUCHER REMOTEID="766a4181-162f-11da-bd9f-00409533948b-00000afc"

VCHTYPE="NEW SALES" ACTION="Create">

      <ISOPTIONAL>No</ISOPTIONAL>

      <USEFORGAINLOSS>No</USEFORGAINLOSS>

      <USEFORCOMPOUND>No</USEFORCOMPOUND>

      <VOUCHERTYPENAME>NEW SALES</VOUCHERTYPENAME>

      <DATE>20040430</DATE>

      <EFFECTIVEDATE>20040430</EFFECTIVEDATE>

      <ISCANCELLED>No</ISCANCELLED>

      <USETRACKINGNUMBER>No</USETRACKINGNUMBER>

      <ISPOSTDATED>No</ISPOSTDATED>

      <ISINVOICE>No</ISINVOICE>

      <DIFFACTUALQTY>No</DIFFACTUALQTY>

      <VOUCHERNUMBER>37/NMALL</VOUCHERNUMBER>

      <PARTYLEDGERNAME>SKY SHIPPING</PARTYLEDGERNAME>

      <ENTEREDBY>Jadav</ENTEREDBY>

      <ASPAYSLIP>No</ASPAYSLIP>

      <GUID>766a4181-162f-11da-bd9f-00409533948b-00000afc</GUID>

      <ALTERID>3107</ALTERID>

      <ALLLEDGERENTRIES.LIST>

       <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>

       <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>

       <LEDGERFROMITEM>No</LEDGERFROMITEM>

       <LEDGERNAME>SKY SHIPPING</LEDGERNAME>

       <AMOUNT>-51680.00</AMOUNT>

       <BILLALLOCATIONS.LIST>

        <NAME>37/NMALL</NAME>

        <BILLTYPE>New Ref</BILLTYPE>

        <BILLCREDITPERIOD />

        <AMOUNT>-51680.00</AMOUNT>

       </BILLALLOCATIONS.LIST>

      </ALLLEDGERENTRIES.LIST>

      <ALLLEDGERENTRIES.LIST>

       <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>

       <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>

       <LEDGERFROMITEM>No</LEDGERFROMITEM>

       <LEDGERNAME>CR.SALES TRANSPORTATION</LEDGERNAME>

       <AMOUNT>51680.00</AMOUNT>

      </ALLLEDGERENTRIES.LIST>

     </VOUCHER>

    </TALLYMESSAGE>

   </REQUESTDATA>

  </IMPORTDATA>

 </BODY>

</ENVELOPE>

the code i wrote to access it is
Dim filePath As String

filePath = "C:Documents and SettingsPrasannaMy DocumentsVisual Studio
ProjectsDayBook.xml"

dsAuthors.ReadXml(filePath)
With DataGrid1
.DataSource = dsAuthors
.DataMember = "VOUCHER"
.CaptionText = .DataMember
End With
the problem is that the daybook is a report not a table that i have exported
from a destination n the allledgerentries.list and billallocation.list are generated
by a query in the odbc layer at runtime, i m able to acess all info into the
dataset except the ones present under these two sets which are very relvant....
i would really like to get a soultion to this problem by someone..
waiting for a reply
ruchita

gv.kishore

KISHORE

Hello Ruchitha,
which version of Visual studio u are using ?

Need help with xml

re: Need help with xml

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about