(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
the code i wrote to access it is
Dim filePath As String
filePath = "C:Document s and SettingsPrasann aMy DocumentsVisual Studio
ProjectsDayBook .xml"
dsAuthors.ReadX ml(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 allledgerentrie s.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
--------------------------------
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
Code:
<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>
Dim filePath As String
filePath = "C:Document s and SettingsPrasann aMy DocumentsVisual Studio
ProjectsDayBook .xml"
dsAuthors.ReadX ml(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 allledgerentrie s.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
Comment