Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XML to Dataset/Datatable
Message
Information générale
Forum:
ASP.NET
Catégorie:
XML
Titre:
XML to Dataset/Datatable
Versions des environnements
Environment:
C# 1.1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01124860
Message ID:
01124860
Vues:
58
Hi all,

I'm doing some work with SharePoint and I'm extracting information from some of its lists.
Below is an example (reduced version) of what I get.
Is it possible to covert it to a Dataset or Datatable without manually parsing it?

TIA
<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<rs:data ItemCount="6">
   <z:row ows_Attachments="0" ows_CQId="CMC_U00001333" ows_Title="frmAdRegistration - additional selection criteria for suggested students" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Show_x0020_stopper_x003f_="Term Registration" ows_Module="Academic Records" ows_Record_x0020_Type="Enhancement" ows_Analyst_u="TBD" ows_PlannedRelease_u="4.2" ows_Priority_u="4 - Low Priority" ows_Status_u="Reevaluate" ows_School="AIUFT" ows_Date_Rqst="2001-10-25 18:11:23" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="288" ows_owshiddenversion="8" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00001854" ows_Title="Possible Duplicate Prospects - Add Lead Date and Adm. Rep. Name to grid" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Comments="  <div>Set Priority and Re-Evaluate per xxx Corp</div>    " ows_Module="Admissions" ows_Record_x0020_Type="Enhancement" ows_Priority_u="3 - Normal Queue" ows_Status_u="Reevaluate" ows_School="AIU-DUNWOO" ows_Date_Rqst="2001-12-21 17:01:08" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="289" ows_owshiddenversion="6" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00002009" ows_Title="Master Student Listing Detail should include selection for Original Adm Rep" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Show_x0020_stopper_x003f_="31134" ows_Module="Academic Records" ows_Record_x0020_Type="Enhancement" ows_Priority_u="4 - Low Priority" ows_Status_u="Reevaluate" ows_School="AIU-LA" ows_Date_Rqst="2002-01-16 19:32:59" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="290" ows_owshiddenversion="7" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00002111" ows_Title="Start Date - Add column for FA Packaging Status to report" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Comments="  <div>FA Status Report? This may meet their needs set priority and reevaluate per xxx Corp</div>    " ows_Module="Admissions" ows_Record_x0020_Type="Enhancement" ows_Priority_u="3 - Normal Queue" ows_Status_u="Reevaluate" ows_School="AIUFT" ows_Date_Rqst="2002-01-29 16:55:21" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="291" ows_owshiddenversion="6" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00002218" ows_Title="Ledger Cards->Print Ledger needs to show student version/shift information" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Comments="  <div>Combined several items into one request CQ #2218 - included cq # 2996, 3874,5148,6386</div>    " ows_Module="Student Accounts" ows_Record_x0020_Type="Enhancement" ows_Priority_u="4 - Low Priority" ows_Status_u="Reevaluate" ows_School="KATYG2" ows_Date_Rqst="2002-02-14 21:27:51" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="292" ows_owshiddenversion="6" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00002272" ows_Title="Activities - Add missing documents fields as merge fields to batch email" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Comments="  <div>Set to Reevaluate per xxx Corp</div>    " ows_Module="Contact Manager" ows_Record_x0020_Type="Enhancement" ows_Priority_u="3 - Normal Queue" ows_Status_u="Reevaluate" ows_School="AIU-SAP" ows_Date_Rqst="2002-02-25 18:32:57" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="293" ows_owshiddenversion="6" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00002327" ows_Title="Need ability to Waive Fees charged to a student" ows_Priority_x0020__x002f__x0020_Ris="3 - Low" ows_Module="Academic Records" ows_Record_x0020_Type="Enhancement" ows_PlannedRelease_u="future" ows_Priority_u="4 - Low Priority" ows_Status_u="Requirements" ows_School="KATYG6" ows_Date_Rqst="2002-03-04 15:07:41" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Updated - 05-19-2006 Updated - 05-15-2006 Updated - 04-24-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="294" ows_owshiddenversion="6" />
     <z:row ows_Attachments="0" ows_CQId="CMC_U00033189" ows_Title="Error 3265 on frmAdEnrollGrades" ows_Priority_x0020__x002f__x0020_Ris="5 - Not reviewed" ows_Module="System" ows_Record_x0020_Type="Defect" ows_Priority_u="1 - Resolve Immediately" ows_Severity_u="2 - Major" ows_Status_u="New" ows_School="CORP" ows_Date_Rqst="2006-05-19 18:59:52" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Added - 05-19-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="5718" ows_owshiddenversion="2" />
   <z:row ows_Attachments="0" ows_CQId="CMC_U00033190" ows_Title="Error 3265 on  frmAdEnrollSched" ows_Priority_x0020__x002f__x0020_Ris="5 - Not reviewed" ows_Module="System" ows_Record_x0020_Type="Defect" ows_Priority_u="1 - Resolve Immediately" ows_Severity_u="2 - Major" ows_Status_u="New" ows_School="CORP" ows_Date_Rqst="2006-05-19 19:06:56" ows_Corp="xxx" ows_Product_u="CampusVue" ows_ChangesStack="Updated - 05-19-2006 Added - 05-19-2006" ows_CMC_x0020_Status_x0020_Updates="Updated - 05-19-2006" ows_ID="5719" ows_owshiddenversion="2" />
</rs:data>
</listitems>

...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....                       

...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
 

Ismael Rivera "Oye cosita linda"
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform