"JIGNESH" wrote:

> Hi Lubomir,
>
> XML type is essentially a string so following statement is valid.
>
> INSERT INTO Customer VALUES (1,'Lubomir',
> '<order>
> <item>
> <id>20</id>
> <name>Widgets</name>
> <units>3</units>
> </item>
> </order>')
>
> Note: if you are using generic accessor methods of SqlReader, it will
> always return .NET String class for XML type columns.
>
> Regards
> JIGNESH
>
>
> "Lubomir" wrote:
>
> > Hi,
> >
> > I have an XML document that I want to store in the SQL Server/Exprss
> > database. The database table has a column of type XML.
> >
> > I saw examples how to read XML column, but I haven't seen any ADO.NET way
> > how to store XML data in the database.
> >
> > Could anybody give me a hint?
> >
> > Thanks for help,