Reply to thread

Message: [QUOTE="ruchitakumar, post: 26890, member: 5829"] hi every one i m trying to access a hierarchy of tables i accessed the table from xml file and its imported in the set of 16 tables the hierarchy can be seen in the following coda [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ENVELOPE[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]HEADER[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]TALLYREQUEST[/COLOR][COLOR=#0000ff]>[/COLOR][B]Import Data[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]TALLYREQUEST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]HEADER[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]BODY[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]IMPORTDATA[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]REQUESTDESC[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]REPORTNAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]All Masters[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]REPORTNAME[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]STATICVARIABLES[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]SVCURRENTCOMPANY[/COLOR][COLOR=#0000ff]>[/COLOR][B]SAHARA CONTAINER P.LTD[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]SVCURRENTCOMPANY[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]STATICVARIABLES[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]REQUESTDESC[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]REQUESTDATA[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]TALLYMESSAGE[/COLOR][COLOR=#ff0000] xmlns:UDF[/COLOR][COLOR=#0000ff]="[/COLOR][B][COLOR=#ff0000]TallyUDF[/COLOR][/B][COLOR=#0000ff]">[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]VOUCHER REMOTEID[/COLOR][COLOR=#0000ff]="[/COLOR][B]766a4181-162f-11da-bd9f-00409533948b-00000a6c[/B][COLOR=#0000ff]"[/COLOR][COLOR=#990000] VCHTYPE[/COLOR][COLOR=#0000ff]="[/COLOR][B]Payment[/B][COLOR=#0000ff]"[/COLOR][COLOR=#990000] ACTION[/COLOR][COLOR=#0000ff]="[/COLOR][B]Create[/B][COLOR=#0000ff]">[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISOPTIONAL[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISOPTIONAL[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]USEFORGAINLOSS[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]USEFORGAINLOSS[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]USEFORCOMPOUND[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]USEFORCOMPOUND[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]VOUCHERTYPENAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]Payment[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]VOUCHERTYPENAME[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]DATE[/COLOR][COLOR=#0000ff]>[/COLOR][B]20040402[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]DATE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]EFFECTIVEDATE[/COLOR][COLOR=#0000ff]>[/COLOR][B]20040402[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]EFFECTIVEDATE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISCANCELLED[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISCANCELLED[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]USETRACKINGNUMBER[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]USETRACKINGNUMBER[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISPOSTDATED[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISPOSTDATED[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISINVOICE[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISINVOICE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]DIFFACTUALQTY[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]DIFFACTUALQTY[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]PARTYLEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]THE MUMBAI C0-OP BANK LTD[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]PARTYLEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]NARRATION[/COLOR][COLOR=#0000ff]>[/COLOR][B]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[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]NARRATION[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ENTEREDBY[/COLOR][COLOR=#0000ff]>[/COLOR][B]Jadav[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ENTEREDBY[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ASPAYSLIP[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ASPAYSLIP[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]GUID[/COLOR][COLOR=#0000ff]>[/COLOR][B]766a4181-162f-11da-bd9f-00409533948b-00000a6c[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]GUID[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ALTERID[/COLOR][COLOR=#0000ff]>[/COLOR][B]2963[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ALTERID[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ALLLEDGERENTRIES.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]REMOVEZEROENTRIES[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]REMOVEZEROENTRIES[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISDEEMEDPOSITIVE[/COLOR][COLOR=#0000ff]>[/COLOR][B]Yes[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISDEEMEDPOSITIVE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]LEDGERFROMITEM[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]LEDGERFROMITEM[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]LEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]T.D.S. ON SALARY[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]LEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR][B]-21635.00[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]CATEGORYALLOCATIONS.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]CATEGORY[/COLOR][COLOR=#0000ff]>[/COLOR][B]INCOME TAX[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]CATEGORY[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]COSTCENTREALLOCATIONS.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]NAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]STAFF.[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]NAME[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR][B]-21635.00[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]COSTCENTREALLOCATIONS.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]CATEGORYALLOCATIONS.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]ALLLEDGERENTRIES.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ALLLEDGERENTRIES.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]REMOVEZEROENTRIES[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]REMOVEZEROENTRIES[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]ISDEEMEDPOSITIVE[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]ISDEEMEDPOSITIVE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]LEDGERFROMITEM[/COLOR][COLOR=#0000ff]>[/COLOR][B]No[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]LEDGERFROMITEM[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]LEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR][B]THE MUMBAI C0-OP BANK LTD[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]LEDGERNAME[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR][B]21635.00[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]AMOUNT[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]ALLLEDGERENTRIES.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [URL="file:///C:/Documents%20and%20Settings/Prasanna/My%20Documents/Visual%20Studio%20Projects/DayBook.xml#"][B][FONT=Courier New][COLOR=#ff0000]-[/COLOR][/FONT][/B][/URL] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]UDF:BANKERSDATE.LIST DESC[/COLOR][COLOR=#0000ff]="[/COLOR][B]`BANKERSDATE`[/B][COLOR=#0000ff]"[/COLOR][COLOR=#990000] ISLIST[/COLOR][COLOR=#0000ff]="[/COLOR][B]YES[/B][COLOR=#0000ff]">[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]<[/COLOR][COLOR=#990000]UDF:BANKERSDATE DESC[/COLOR][COLOR=#0000ff]="[/COLOR][B]`BANKERSDATE`[/B][COLOR=#0000ff]">[/COLOR][B]20040407[/B][COLOR=#0000ff]</[/COLOR][COLOR=#990000]UDF:BANKERSDATE[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]UDF:BANKERSDATE.LIST[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]VOUCHER[/COLOR][COLOR=#0000ff]>[/COLOR] [B][FONT=Courier New][COLOR=#ff0000] [/COLOR][/FONT][/B] [COLOR=#0000ff]</[/COLOR][COLOR=#990000]TALLYMESSAGE[/COLOR][COLOR=#0000ff]>[/COLOR] [COLOR=#0000ff]table number 8 is voucher n i m trying to access allledgerentries which is the child table[/COLOR] [COLOR=#0000ff]i m doin it using the given code[/COLOR] [SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] dsAuthors [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] DataSet("VOUCHER") [/SIZE][SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] TextBox1_TextChanged([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles[/COLOR][/SIZE][SIZE=2] TextBox1.TextChanged [/SIZE][SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub [/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] btnReadXML_Click([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles[/COLOR][/SIZE][SIZE=2] btnReadXML.Click [/SIZE][SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] filePath [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]String [/COLOR][/SIZE][SIZE=2]filePath = "C:\Documents and Settings\Prasanna\My Documents\Visual Studio Projects\DAYBOOK.xml" dsAuthors.ReadXml(filePath) [/SIZE][SIZE=2][COLOR=#0000ff]With[/COLOR][/SIZE][SIZE=2] DataGrid1 .DataSource = dsAuthors.Tables.Item(8).Rows(0).GetChildRows(dsAuthors.Tables.Item(8).ChildRelations.Item(0).ToString) .DataMember = dsAuthors.Tables.Item(8).ChildRelations(0).ToString .CaptionText = .DataMember [/SIZE][SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]With [/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub [/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] btnShowSchema_Click([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles[/COLOR][/SIZE][SIZE=2] btnShowSchema.Click [/SIZE][SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] swXML [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] System.IO.StringWriter() dsAuthors.WriteXmlSchema(swXML) TextBox1.Text = swXML.ToString [/SIZE][SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Sub End[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Class[/COLOR][/SIZE] [SIZE=2][COLOR=#0000ff]here the data grid is supposed to print the child table allledgerentries for the first record of vouchers[/COLOR][/SIZE] [SIZE=2][COLOR=#0000ff]i m getting the following error"cannot creat child list for ALLLEDGERENTRIES"[/COLOR][/SIZE] [SIZE=2][COLOR=#0000ff]can someone please help[/COLOR][/SIZE] [SIZE=2][COLOR=#0000ff]regards ruchita [/COLOR][/SIZE] [/QUOTE]

Verification