How to use the xml sql server datatype with c#

A

Andy B

Just wondering, How do you use the xml sql server datatype with c#? When I
made a dataset the xml column showed up in c# as a string. Do I have to
write valid xml code into the string in order for it to work right?
 
M

Marc Gravell

I general, you have acces to DbType.Xml and
SqlCommand.ExecuteXmlReader - however, it is entirely possible that
you need to treat it as a string within a DataSet. I've never really
properly used DataSet so I can't really guess...

Marc
 

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

Store XML/XSD in SQL Server 2008 3
Insert xml VS2008 3
XML vs SQL Server 22
Problem with reading .xml file using Dataset method 1
Binding XML Data to WPF 1
XML to Dictionary using LINQ 2
XML and collectionbase 3
ReadXML and WriteXML contains byte[] 1

Top