XML and Database

  • Thread starter Thread starter momo
  • Start date Start date
M

momo

Is there a way to import an XML file into a database like MSSQL or MS Access
using ASP.NET?
 
SQL Server has support for parsing XML.

You just need to pass your XML string to stored procedure as TEXT
 
This is piece of SP I have:(@_iXML is TEXT type input parameter for stored
procedure)


DECLARE @Answers Table (SurveyDetlKey Int NOT NULL,
SurveyKey Int NULL)

-- assume failure
SELECT @_oRetVal = 0


EXEC sp_xml_preparedocument @XMLDoc OUTPUT, @_iXML

INSERT @Answers (SurveyDetlKey)
SELECT SurveyDetlKey FROM OPENXML (@XMLDoc , '/ROOT/Array', 1 )
WITH (SurveyDetlKey INT) AS tAnswers

EXEC sp_xml_removedocument @XMLDoc


Reed SQL Server Books Online for descriptions of sp_xml_preparedocument

Hope it helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Asp.Net and XML 3
How do I output stored procedure to XML? 2
newbie: accessing xml values 2
Specify a Specific Folder for ASP.NET Debugging? 0
XML with international characters 1
XML and SQL database 2
encode send and recieve xml data across asp.net pages 3
Replace aspnetdb with an Access Database 3

Back
Top