c# - Reading XML dynamic data in SQL Server -
i have xml column in table contains collection of data. every record may hold different collection type customers data , invoices data etc. how can read cell & convert table in order bind data grid, collection times looks that <arrayofreceipttransfer_receipt xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema"> <receipttransfer_receipt> <receipttransfer_receipt_id>77491</receipttransfer_receipt_id> <receipttransferid>17839</receipttransferid> <receiptid>74080</receiptid> <amount>500.00</amount> </receipttransfer_receipt> </arrayofreceipttransfer_receipt> and looks like <arrayofinvoicebudgetitem xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema"> <invoicebudgetitem> <invoiceid>21978</invoiceid> <budgetitemid>1...