Need help with xml

[ruchitakumar]

(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

- <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

 

[prabhukalyan]

Pls help me

Hi RuchitaKumar,
Its not an answer to your problem. When i look at your XML code it looks like you are doing something with tally. Actually i dont know anything about XML or Tally. here many of my clients were asking for a link between tally and my sqlserver database so that they can avoid making double entry ( for their invoices and purchases ) one from our sofware ( developed with vb.net/sql2000 ) and the other with tally. I know its possible to export the invoices from the sql database to tally database but i dont know how to do it. if you know please help me to learn these things.

Thanks in Advance
prabhu. ( you can mail me if possible prabhoo_k@yahoo.co.in )

Note: Any one who read this and and knows the solution pls mail me to the above mail-id