467,188 Members | 1,419 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Convert XML String to Dataset

I have used XMLDataToString = DataSetForXML.GetXml() to get an XML string
from a dataset. I am looking for a way to create a dataset from this XML
string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received error
messages. Does anyone know how to do this without creating a file (disk
copy) of this XML data? Thanks for your help.
Marc
Nov 21 '05 #1
  • viewed: 23350
Share:
12 Replies
Mark,
Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml from
the named file.

Have you tried ReadXml(TextReader)? Specifically with a StringReader?

Something like:

Dim reader As New System.Io.StringReader(XMLDataToString)
DataSetForXML.ReadXml(reader)

For details see:

http://msdn.microsoft.com/library/de...ClassTopic.asp

http://msdn.microsoft.com/library/de...dXmlTopic3.asp

Hope this helps
Jay
"Marc" <Ma**@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
|I have used XMLDataToString = DataSetForXML.GetXml() to get an XML string
| from a dataset. I am looking for a way to create a dataset from this XML
| string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received
error
| messages. Does anyone know how to do this without creating a file (disk
| copy) of this XML data? Thanks for your help.
| Marc
Nov 21 '05 #2
Jay,
That worked great! Just when you think you have tried everything. Thanks
so much for your help.
Marc

"Jay B. Harlow [MVP - Outlook]" wrote:
Mark,
Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml from
the named file.

Have you tried ReadXml(TextReader)? Specifically with a StringReader?

Something like:

Dim reader As New System.Io.StringReader(XMLDataToString)
DataSetForXML.ReadXml(reader)

For details see:

http://msdn.microsoft.com/library/de...ClassTopic.asp

http://msdn.microsoft.com/library/de...dXmlTopic3.asp

Hope this helps
Jay
"Marc" <Ma**@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
|I have used XMLDataToString = DataSetForXML.GetXml() to get an XML string
| from a dataset. I am looking for a way to create a dataset from this XML
| string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received
error
| messages. Does anyone know how to do this without creating a file (disk
| copy) of this XML data? Thanks for your help.
| Marc

Nov 21 '05 #3
I know this is almost a month old, but I was having the same challenges and
tried your suggestions. They worked fine, but now, how do I get to the
fields in the Dataset?? Do they 'magically' appear as
".Fields(<Fieldname>).Value" once the XML String is read??

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Mark,
Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml from
the named file.

Have you tried ReadXml(TextReader)? Specifically with a StringReader?

Something like:

Dim reader As New System.Io.StringReader(XMLDataToString)
DataSetForXML.ReadXml(reader)

For details see:

http://msdn.microsoft.com/library/de...ClassTopic.asp

http://msdn.microsoft.com/library/de...dXmlTopic3.asp

Hope this helps
Jay
"Marc" <Ma**@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
|I have used XMLDataToString = DataSetForXML.GetXml() to get an XML string
| from a dataset. I am looking for a way to create a dataset from this
XML
| string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received
error
| messages. Does anyone know how to do this without creating a file (disk
| copy) of this XML data? Thanks for your help.
| Marc

Nov 21 '05 #4
Any help? Bueller? Bueller? NE1? NE1?
"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:u4**************@TK2MSFTNGP15.phx.gbl...
I know this is almost a month old, but I was having the same challenges and
tried your suggestions. They worked fine, but now, how do I get to the
fields in the Dataset?? Do they 'magically' appear as
".Fields(<Fieldname>).Value" once the XML String is read??

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Mark,
Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml from
the named file.

Have you tried ReadXml(TextReader)? Specifically with a StringReader?

Something like:

Dim reader As New System.Io.StringReader(XMLDataToString)
DataSetForXML.ReadXml(reader)

For details see:

http://msdn.microsoft.com/library/de...ClassTopic.asp

http://msdn.microsoft.com/library/de...dXmlTopic3.asp

Hope this helps
Jay
"Marc" <Ma**@discussions.microsoft.com> wrote in message
news:D3**********************************@microsof t.com...
|I have used XMLDataToString = DataSetForXML.GetXml() to get an XML
string
| from a dataset. I am looking for a way to create a dataset from this
XML
| string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received
error
| messages. Does anyone know how to do this without creating a file
(disk
| copy) of this XML data? Thanks for your help.
| Marc


Nov 21 '05 #5
Bryan,
You can get the DataColumns of a DataTable via the DataTable.Columns
property.

For a complete explanation of Datasets, DataTables, & DataAdapters along
with how to use them. I would strongly recommend you read David Sceppa's
book "Microsoft ADO.NET - Core Reference" from MS Press. As it is both a
good tutorial on ADO.NET as well as a good desk reference once you know
ADO.NET.

Hope this helps
Jay
"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:u4**************@TK2MSFTNGP15.phx.gbl...
|I know this is almost a month old, but I was having the same challenges and
| tried your suggestions. They worked fine, but now, how do I get to the
| fields in the Dataset?? Do they 'magically' appear as
| ".Fields(<Fieldname>).Value" once the XML String is read??
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
| news:%2****************@TK2MSFTNGP12.phx.gbl...
| > Mark,
| > Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml
from
| > the named file.
| >
| > Have you tried ReadXml(TextReader)? Specifically with a StringReader?
| >
| > Something like:
| >
| > Dim reader As New System.Io.StringReader(XMLDataToString)
| > DataSetForXML.ReadXml(reader)
| >
| > For details see:
| >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| >
| > Hope this helps
| > Jay
| >
| >
| > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > news:D3**********************************@microsof t.com...
| > |I have used XMLDataToString = DataSetForXML.GetXml() to get an XML
string
| > | from a dataset. I am looking for a way to create a dataset from this
| > XML
| > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but I received
| > error
| > | messages. Does anyone know how to do this without creating a file
(disk
| > | copy) of this XML data? Thanks for your help.
| > | Marc
| >
| >
|
|
Nov 21 '05 #6
Do you know of anything online docs that might tell me something similar?

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:O%***************@TK2MSFTNGP12.phx.gbl...
Bryan,
You can get the DataColumns of a DataTable via the DataTable.Columns
property.

For a complete explanation of Datasets, DataTables, & DataAdapters along
with how to use them. I would strongly recommend you read David Sceppa's
book "Microsoft ADO.NET - Core Reference" from MS Press. As it is both a
good tutorial on ADO.NET as well as a good desk reference once you know
ADO.NET.

Hope this helps
Jay
"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:u4**************@TK2MSFTNGP15.phx.gbl...
|I know this is almost a month old, but I was having the same challenges
and
| tried your suggestions. They worked fine, but now, how do I get to the
| fields in the Dataset?? Do they 'magically' appear as
| ".Fields(<Fieldname>).Value" once the XML String is read??
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
message
| news:%2****************@TK2MSFTNGP12.phx.gbl...
| > Mark,
| > Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml
from
| > the named file.
| >
| > Have you tried ReadXml(TextReader)? Specifically with a StringReader?
| >
| > Something like:
| >
| > Dim reader As New System.Io.StringReader(XMLDataToString)
| > DataSetForXML.ReadXml(reader)
| >
| > For details see:
| >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| >
| > Hope this helps
| > Jay
| >
| >
| > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > news:D3**********************************@microsof t.com...
| > |I have used XMLDataToString = DataSetForXML.GetXml() to get an XML
string
| > | from a dataset. I am looking for a way to create a dataset from
this
| > XML
| > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but I
received
| > error
| > | messages. Does anyone know how to do this without creating a file
(disk
| > | copy) of this XML data? Thanks for your help.
| > | Marc
| >
| >
|
|

Nov 21 '05 #7
Bryan,
MSDN (http://msdn.microsoft.com) although I prefer the online local help
over the web help, however the content is the same.

Plus a plethora of other sites, google on DataSet and/or DataTable...

I would strongly recommend Sceppa's book! As its both a good tutorial & a
good desk reference. Far "better" & more "complete" then anything thing else
I've seen on ADO.NET.

Hope this helps
Jay

"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
| Do you know of anything online docs that might tell me something similar?
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
| news:O%***************@TK2MSFTNGP12.phx.gbl...
| > Bryan,
| > You can get the DataColumns of a DataTable via the DataTable.Columns
| > property.
| >
| > For a complete explanation of Datasets, DataTables, & DataAdapters along
| > with how to use them. I would strongly recommend you read David Sceppa's
| > book "Microsoft ADO.NET - Core Reference" from MS Press. As it is both a
| > good tutorial on ADO.NET as well as a good desk reference once you know
| > ADO.NET.
| >
| > Hope this helps
| > Jay
| >
| >
| > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > news:u4**************@TK2MSFTNGP15.phx.gbl...
| > |I know this is almost a month old, but I was having the same challenges
| > and
| > | tried your suggestions. They worked fine, but now, how do I get to
the
| > | fields in the Dataset?? Do they 'magically' appear as
| > | ".Fields(<Fieldname>).Value" once the XML String is read??
| > |
| > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
| > message
| > | news:%2****************@TK2MSFTNGP12.phx.gbl...
| > | > Mark,
| > | > Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads Xml
| > from
| > | > the named file.
| > | >
| > | > Have you tried ReadXml(TextReader)? Specifically with a
StringReader?
| > | >
| > | > Something like:
| > | >
| > | > Dim reader As New System.Io.StringReader(XMLDataToString)
| > | > DataSetForXML.ReadXml(reader)
| > | >
| > | > For details see:
| > | >
| > | >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| > | >
| > | >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| > | >
| > | > Hope this helps
| > | > Jay
| > | >
| > | >
| > | > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > | > news:D3**********************************@microsof t.com...
| > | > |I have used XMLDataToString = DataSetForXML.GetXml() to get an XML
| > string
| > | > | from a dataset. I am looking for a way to create a dataset from
| > this
| > | > XML
| > | > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but I
| > received
| > | > error
| > | > | messages. Does anyone know how to do this without creating a file
| > (disk
| > | > | copy) of this XML data? Thanks for your help.
| > | > | Marc
| > | >
| > | >
| > |
| > |
| >
| >
|
|
Nov 21 '05 #8
Oh, and I meant to answer with another question yesterday (but was at home
sick yesterday): I didn't find any "DataTable" or "DataColumn"
properties/methods on the Dataset class. So what am I not seeing?

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:uK**************@TK2MSFTNGP10.phx.gbl...
Bryan,
MSDN (http://msdn.microsoft.com) although I prefer the online local help
over the web help, however the content is the same.

Plus a plethora of other sites, google on DataSet and/or DataTable...

I would strongly recommend Sceppa's book! As its both a good tutorial & a
good desk reference. Far "better" & more "complete" then anything thing
else
I've seen on ADO.NET.

Hope this helps
Jay

"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
| Do you know of anything online docs that might tell me something
similar?
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
message
| news:O%***************@TK2MSFTNGP12.phx.gbl...
| > Bryan,
| > You can get the DataColumns of a DataTable via the DataTable.Columns
| > property.
| >
| > For a complete explanation of Datasets, DataTables, & DataAdapters
along
| > with how to use them. I would strongly recommend you read David
Sceppa's
| > book "Microsoft ADO.NET - Core Reference" from MS Press. As it is both
a
| > good tutorial on ADO.NET as well as a good desk reference once you
know
| > ADO.NET.
| >
| > Hope this helps
| > Jay
| >
| >
| > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > news:u4**************@TK2MSFTNGP15.phx.gbl...
| > |I know this is almost a month old, but I was having the same
challenges
| > and
| > | tried your suggestions. They worked fine, but now, how do I get to
the
| > | fields in the Dataset?? Do they 'magically' appear as
| > | ".Fields(<Fieldname>).Value" once the XML String is read??
| > |
| > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
| > message
| > | news:%2****************@TK2MSFTNGP12.phx.gbl...
| > | > Mark,
| > | > Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads
Xml
| > from
| > | > the named file.
| > | >
| > | > Have you tried ReadXml(TextReader)? Specifically with a
StringReader?
| > | >
| > | > Something like:
| > | >
| > | > Dim reader As New System.Io.StringReader(XMLDataToString)
| > | > DataSetForXML.ReadXml(reader)
| > | >
| > | > For details see:
| > | >
| > | >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| > | >
| > | >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| > | >
| > | > Hope this helps
| > | > Jay
| > | >
| > | >
| > | > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > | > news:D3**********************************@microsof t.com...
| > | > |I have used XMLDataToString = DataSetForXML.GetXml() to get an
XML
| > string
| > | > | from a dataset. I am looking for a way to create a dataset from
| > this
| > | > XML
| > | > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but I
| > received
| > | > error
| > | > | messages. Does anyone know how to do this without creating a
file
| > (disk
| > | > | copy) of this XML data? Thanks for your help.
| > | > | Marc
| > | >
| > | >
| > |
| > |
| >
| >
|
|

Nov 21 '05 #9
Bryan,
DataTable & DataColumn are types.

Remember that a DataSet contains zero or more DataTables, that a DataTable
has one or more DataColumns, and zero or more DataRows.

In other words the DataSet has a Tables property that returns a
DataTableCollection type. The DataTableCollection contains a collection of
DataTables. The DataTable has a Columns property that returns a
DataColumnCollection type. The DataColumnCollection contains a collection of
DataColumns.

You may want to review this section of MSDN:

http://msdn.microsoft.com/library/de...withadonet.asp

Specifically:

http://msdn.microsoft.com/library/de...ewofadonet.asp

http://msdn.microsoft.com/library/de...netdataset.asp

http://msdn.microsoft.com/library/de...ngdatasets.asp

http://msdn.microsoft.com/library/de...datatables.asp

http://msdn.microsoft.com/library/de...gdataviews.asp

However I would strongly recommend you read the entire section & Sceppa's
book.

Hope this helps
Jay

"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
| Oh, and I meant to answer with another question yesterday (but was at home
| sick yesterday): I didn't find any "DataTable" or "DataColumn"
| properties/methods on the Dataset class. So what am I not seeing?
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
| news:uK**************@TK2MSFTNGP10.phx.gbl...
| > Bryan,
| > MSDN (http://msdn.microsoft.com) although I prefer the online local help
| > over the web help, however the content is the same.
| >
| > Plus a plethora of other sites, google on DataSet and/or DataTable...
| >
| > I would strongly recommend Sceppa's book! As its both a good tutorial &
a
| > good desk reference. Far "better" & more "complete" then anything thing
| > else
| > I've seen on ADO.NET.
| >
| > Hope this helps
| > Jay
| >
| > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > news:%2****************@TK2MSFTNGP09.phx.gbl...
| > | Do you know of anything online docs that might tell me something
| > similar?
| > |
| > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
| > message
| > | news:O%***************@TK2MSFTNGP12.phx.gbl...
| > | > Bryan,
| > | > You can get the DataColumns of a DataTable via the DataTable.Columns
| > | > property.
| > | >
| > | > For a complete explanation of Datasets, DataTables, & DataAdapters
| > along
| > | > with how to use them. I would strongly recommend you read David
| > Sceppa's
| > | > book "Microsoft ADO.NET - Core Reference" from MS Press. As it is
both
| > a
| > | > good tutorial on ADO.NET as well as a good desk reference once you
| > know
| > | > ADO.NET.
| > | >
| > | > Hope this helps
| > | > Jay
| > | >
| > | >
| > | > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > | > news:u4**************@TK2MSFTNGP15.phx.gbl...
| > | > |I know this is almost a month old, but I was having the same
| > challenges
| > | > and
| > | > | tried your suggestions. They worked fine, but now, how do I get
to
| > the
| > | > | fields in the Dataset?? Do they 'magically' appear as
| > | > | ".Fields(<Fieldname>).Value" once the XML String is read??
| > | > |
| > | > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
| > | > message
| > | > | news:%2****************@TK2MSFTNGP12.phx.gbl...
| > | > | > Mark,
| > | > | > Notice that DataSet.ReadXml is overloaded. ReadXml(String) reads
| > Xml
| > | > from
| > | > | > the named file.
| > | > | >
| > | > | > Have you tried ReadXml(TextReader)? Specifically with a
| > StringReader?
| > | > | >
| > | > | > Something like:
| > | > | >
| > | > | > Dim reader As New System.Io.StringReader(XMLDataToString)
| > | > | > DataSetForXML.ReadXml(reader)
| > | > | >
| > | > | > For details see:
| > | > | >
| > | > | >
| > | >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| > | > | >
| > | > | >
| > | >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| > | > | >
| > | > | > Hope this helps
| > | > | > Jay
| > | > | >
| > | > | >
| > | > | > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > | > | > news:D3**********************************@microsof t.com...
| > | > | > |I have used XMLDataToString = DataSetForXML.GetXml() to get an
| > XML
| > | > string
| > | > | > | from a dataset. I am looking for a way to create a dataset
from
| > | > this
| > | > | > XML
| > | > | > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but I
| > | > received
| > | > | > error
| > | > | > | messages. Does anyone know how to do this without creating a
| > file
| > | > (disk
| > | > | > | copy) of this XML data? Thanks for your help.
| > | > | > | Marc
| > | > | >
| > | > | >
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|
Nov 21 '05 #10
Jay,

However I would strongly recommend you read the entire section & Sceppa's
book.

Nothing wrong with your message and advice, however we missed this probably
for more than a year now.

To let you deal in my friendly smile.

:-)

Cor
Nov 21 '05 #11
Ah, said the blind man as he stumbled merrily along his way! I found them.
Thx!

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...
Bryan,
DataTable & DataColumn are types.

Remember that a DataSet contains zero or more DataTables, that a DataTable
has one or more DataColumns, and zero or more DataRows.

In other words the DataSet has a Tables property that returns a
DataTableCollection type. The DataTableCollection contains a collection of
DataTables. The DataTable has a Columns property that returns a
DataColumnCollection type. The DataColumnCollection contains a collection
of
DataColumns.

You may want to review this section of MSDN:

http://msdn.microsoft.com/library/de...withadonet.asp

Specifically:

http://msdn.microsoft.com/library/de...ewofadonet.asp

http://msdn.microsoft.com/library/de...netdataset.asp

http://msdn.microsoft.com/library/de...ngdatasets.asp

http://msdn.microsoft.com/library/de...datatables.asp

http://msdn.microsoft.com/library/de...gdataviews.asp

However I would strongly recommend you read the entire section & Sceppa's
book.

Hope this helps
Jay

"Bryan Dickerson" <tx******@netscape.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
| Oh, and I meant to answer with another question yesterday (but was at
home
| sick yesterday): I didn't find any "DataTable" or "DataColumn"
| properties/methods on the Dataset class. So what am I not seeing?
|
| "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
message
| news:uK**************@TK2MSFTNGP10.phx.gbl...
| > Bryan,
| > MSDN (http://msdn.microsoft.com) although I prefer the online local
help
| > over the web help, however the content is the same.
| >
| > Plus a plethora of other sites, google on DataSet and/or DataTable...
| >
| > I would strongly recommend Sceppa's book! As its both a good tutorial
&
a
| > good desk reference. Far "better" & more "complete" then anything
thing
| > else
| > I've seen on ADO.NET.
| >
| > Hope this helps
| > Jay
| >
| > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > news:%2****************@TK2MSFTNGP09.phx.gbl...
| > | Do you know of anything online docs that might tell me something
| > similar?
| > |
| > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in
| > message
| > | news:O%***************@TK2MSFTNGP12.phx.gbl...
| > | > Bryan,
| > | > You can get the DataColumns of a DataTable via the
DataTable.Columns
| > | > property.
| > | >
| > | > For a complete explanation of Datasets, DataTables, & DataAdapters
| > along
| > | > with how to use them. I would strongly recommend you read David
| > Sceppa's
| > | > book "Microsoft ADO.NET - Core Reference" from MS Press. As it is
both
| > a
| > | > good tutorial on ADO.NET as well as a good desk reference once you
| > know
| > | > ADO.NET.
| > | >
| > | > Hope this helps
| > | > Jay
| > | >
| > | >
| > | > "Bryan Dickerson" <tx******@netscape.net> wrote in message
| > | > news:u4**************@TK2MSFTNGP15.phx.gbl...
| > | > |I know this is almost a month old, but I was having the same
| > challenges
| > | > and
| > | > | tried your suggestions. They worked fine, but now, how do I get
to
| > the
| > | > | fields in the Dataset?? Do they 'magically' appear as
| > | > | ".Fields(<Fieldname>).Value" once the XML String is read??
| > | > |
| > | > | "Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote
in
| > | > message
| > | > | news:%2****************@TK2MSFTNGP12.phx.gbl...
| > | > | > Mark,
| > | > | > Notice that DataSet.ReadXml is overloaded. ReadXml(String)
reads
| > Xml
| > | > from
| > | > | > the named file.
| > | > | >
| > | > | > Have you tried ReadXml(TextReader)? Specifically with a
| > StringReader?
| > | > | >
| > | > | > Something like:
| > | > | >
| > | > | > Dim reader As New System.Io.StringReader(XMLDataToString)
| > | > | > DataSetForXML.ReadXml(reader)
| > | > | >
| > | > | > For details see:
| > | > | >
| > | > | >
| > | >
| >
http://msdn.microsoft.com/library/de...ClassTopic.asp
| > | > | >
| > | > | >
| > | >
| >
http://msdn.microsoft.com/library/de...dXmlTopic3.asp
| > | > | >
| > | > | > Hope this helps
| > | > | > Jay
| > | > | >
| > | > | >
| > | > | > "Marc" <Ma**@discussions.microsoft.com> wrote in message
| > | > | > news:D3**********************************@microsof t.com...
| > | > | > |I have used XMLDataToString = DataSetForXML.GetXml() to get
an
| > XML
| > | > string
| > | > | > | from a dataset. I am looking for a way to create a dataset
from
| > | > this
| > | > | > XML
| > | > | > | string. I tried DataSetForXML.ReadXml(XMLDataToString) but
I
| > | > received
| > | > | > error
| > | > | > | messages. Does anyone know how to do this without creating
a
| > file
| > | > (disk
| > | > | > | copy) of this XML data? Thanks for your help.
| > | > | > | Marc
| > | > | >
| > | > | >
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|

Nov 21 '05 #12
Jay,

I use deal to often, when I mean share.
To let you deal in my friendly smile.

To let you share my friendly smile.

:-)

Cor
Nov 21 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Nathan | last post: by
3 posts views Thread by Petr Jakes | last post: by
5 posts views Thread by needin4mation@gmail.com | last post: by
3 posts views Thread by Ursula | last post: by
3 posts views Thread by Shawn Ferguson | last post: by
12 posts views Thread by Peter | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.