469,336 Members | 5,787 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

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

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?
Apr 25 '06 #1
2 3223
you would need to bring back this column value as an XML String and then do
DataSet.ReadXml(theString) on it.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Thirsty Traveler" wrote:
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?

Apr 26 '06 #2
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.

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:53**********************************@microsof t.com...
you would need to bring back this column value as an XML String and then
do
DataSet.ReadXml(theString) on it.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Thirsty Traveler" wrote:
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?

Apr 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Thaddeus | last post: by
22 posts views Thread by Arne | last post: by
3 posts views Thread by Datatable Dataset Datagrid help | last post: by
reply views Thread by xmail123 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.