How do I populate a DataSet from a SQL Server 2005 xml datatype

T

Thirsty Traveler

I have an xml column in a SQL Server 2005 table that was populated with a
DataSet. I would like to read that column back into a DataSet object but am
not quire sure how.

Any ideas?
 
G

Guest

you would need to bring back this column value as an XML String and then do
DataSet.ReadXml(theString) on it.
Peter
 
T

Thirsty Traveler

What is an xml string? Is this a type?

What is returned to me from a stored procedure call is a DataSet with
several columns of metadata that also includes the xml dataset column
associated with the metadata. I need to attach the dataset column to a
crystal report as a datasource and do other things with the metadata (such
as the file server/folder destination of the pdf created by the crystal
report component) but am not sure how to do this.
 

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

How to use the xml sql server datatype with c# 1
Store XML/XSD in SQL Server 2008 3
How to use Xml feature for a DataSet when XmlDataDocument is obsolete 3
DataSet to SQL Server 2005 1
Write XML with all columns/fields 2
Question on XML and Dataset 5
Dump SQL Server database to XML through C# 2
How to populate a DataSet schema with data from and XML string? 3

Top