asked on 8/28/2013

Read and Write XML Content into SQL Server

I have an XML file 'D:/Message.XML' with contents as follows

<MessageList>
<Message>
<Description>Test for Message</Description>
<User>ABC123</User>
</Message>
</MessageList>

I have a SQL table 'tblMessages' with
- Id (Identity column)
- Description nvarchar(max)
- User nchar(10)

I have a c# class file which has a function (InsertXMLContent()). I would like to read the XML file and write the content into the SQL table.

Thanks in advance.

C#Microsoft SQL Server 2008 ASP.NET

Last Comment

VBdotnet2005

9/24/2013

ASKER CERTIFIED SOLUTION

guru_sami

8/28/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Monica P

8/29/2013

Hi

Read the XML Data and pass it into the SQL ..

Read XML Data :http://www.dotnetperls.com/xmlreader-vbnet

http://www.simplevb.net/content/read-data-from-an-xml-file-in-vbnet-ID42.aspx

Read XML data and save it in the varaible.

After .,making use of the Insert statement to enter the saved values in to Database

Monica P

8/29/2013

Check this.,I think it may suit your need...

https://www.experts-exchange.com/blogs/samirbhogayta/B_7167-Pass-XML-as-Parameter-from-C-to-SQL-Stored-Procedure-in-VB-NET.html

VBdotnet2005

9/24/2013

thank you