Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML to datarow
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
XML to datarow
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01573699
Message ID:
01573699
Views:
59
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.

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.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform