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

  • Thread starter Thread starter Thirsty Traveler
  • Start date Start date
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?
 
you would need to bring back this column value as an XML String and then do
DataSet.ReadXml(theString) on it.
Peter
 
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
Dump SQL Server database to XML through C# 2
Question on XML and Dataset 5
How to populate a DataSet schema with data from and XML string? 3

Back
Top