Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am passing XML data as string from want read this string and insert data into oracle table.provide a soln

1 solution


try this,
Dim strReader As New StringReader(StrXmlValue)
'StrXmlValue is the xml string
Dim xmlreader As New XmlTextReader(strReader)
Dim xmlDoc As New XmlDocument

using this XmlDocument object you can read the nodes and attributes of XML data and save it in DB.

refer the link.[^]!4/d41d8/932[^]

hope it helps.
Share this answer
Vijay Walunj,Navi mumbai 11-Feb-13 4:45am    
thanx frnd.i am passing the string containg xml doc and parsing it to xml in store procedure.Using XMLTable i am able read xmldata with single record but i am not able to get entire data.provide soln.

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