INSERT data into a column of XML datatype

Question

I have a SQL Server database with a column of type XML. I've been looking about for ways to populate it using an INSERT query / stored procedure from asp.net.

So far all I can find is ways to get (SELECT) the XML data and execute an SqlDataReader / XMLReader (such as this example)

How can I go about populating the column from ASP.NET? The xml will look something like the following:

<remarks>
    <remark>
        <author>...</author>
        <date>...</date>
        <content>...</content>
    </remark>
    <remark>
        <author>...</author>
        <date>...</date>
        <content>...</content>
    </remark>
</remarks>

The 'content' will be entered by a user in a textbox, and the other columns will be populated using DateTime.Now() and User.Identity.Name.

I am looking to be able to:

Enter a first remark into an empty XML column.
Enter additional remarks at a later time.

Can this be done? I can't manage to find any information on this.

Community · Accepted Answer · 2017-05-23 10:32:00Z

3

This should do the trick for INSERT

INSERT INTO YourTable(idCol,xmlCol)
values(1,'<?xml version="1.0" encoding="utf-8"?>
<remarks>
    <remark>
        <author>...</author>
        <date>...</date>
        <content>...</content>
    </remark>
    <remark>
        <author>...</author>
        <date>...</date>
        <content>...</content>
    </remark>
</remarks>')

For UPDATE, I won't give a better answer than https://stackoverflow.com/a/1440688/1236044

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Feb 14, 2013 at 16:41

jbl

15.5k3 gold badges37 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

INSERT data into a column of XML datatype

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related