Click here to Skip to main content
15,897,187 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have made aDynamic HTML table Now I have to save in Database How Could I do that I made xml function so that all values will come in xml table and then save in database am I doing write please give some hint of codes so that I can save it in database or path where I can see example
Posted

 
Share this answer
 
Are You want to save html table or its record. If saving html table than save this as text in database, if saving only record of html table than include all record in a list and serialize as xml and send this xml to database to save. In database save using this

xmlObj.Item.query('./FieldLabel').value('.','NVARCHAR(100)') FieldLabel
From @xmlTemplateDetail.nodes('your xml outer tags') AS xmlObj(Item)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900