Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XML to datarow
Message
De
13/05/2013 13:04:39
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
Versions des environnements
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01573699
Message ID:
01573705
Vues:
40
>Hi everybody,
>
>We're passing XML like this
>
>
>"<tcactionlist><BACKCOLOR>16496253</BACKCOLOR><BarIndex>1</BarIndex>
><BarKeyID>YEM918Z</BarKeyID><BARTYPE></BARTYPE><Base_ID>0</Base_ID>
><Booking_ID></Booking_ID><category>SNOWBOARD</category><CLIP_LOC></CLIP_LOC>
><CLIP_SP></CLIP_SP><Clipboard></Clipboard><CRITERIA1>0</CRITERIA1><CRITERIA2>.F.</CRITERIA2><CRITERIA3>.F.</CRITERIA3>
><CRITERIA4>0</CRITERIA4><CRITERIA5>0</CRITERIA5><CRITERIA6>0</CRITERIA6>
><CRITERIA7>2</CRITERIA7><Date_time>04/30/2013 16:59:00</Date_time></tcactionlist>"
>
>
>Basically, it's a table's row. We don't necessary pass every column with value.

But you do have an XML element for each column ? And the values, where supplied, are quaranteed to be the correct type ?

>I am wondering what will be the best way to get it into table's row? I can get the table's structure, but I am not sure how to convert the above into that table's row.
>
>Any ideas?
>
>Thanks in advance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform