Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML to datarow
Message
From
13/05/2013 13:04:39
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01573699
Message ID:
01573705
Views:
41
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform