|
 |
ado_dotnet thread: Saving XML to multiple tables
Message #1 by "Jae Hou" <jae@s...> on Tue, 11 Mar 2003 20:50:51
|
|
Ok...so my asp.net page just received a XML stream via HTTP. That's all
good and dandy...but now how do I strip out the data that I need and put
them in multiple tables? Some of the data goes here and some of the data
goes there. Can anyone help or direct me to any resources on the web that
I can use to figure this out?
Thx, Jae.
Message #2 by "Kailas Tare" <kailast@i...> on Tue, 11 Mar 2003 12:42:29 -0800
|
|
What kind of xml is that?
1) If you can put it in DataSet format, then your table updations become
very easy.
2) If you can divide the XML in fragments and each fragment is going to
a table, then you can create SQL stored procedure, pass the xml fragment
as parameter and using OPENXML command, insert into table directly.
3) Worst solution would be to traverse the xml and put required data in
multiple tables.
Search on perfectxml.com, you will find number of articles.
Thanks,
Kailas.
-----Original Message-----
From: Jae Hou [mailto:jae@s...]
Sent: Tuesday, March 11, 2003 12:51 PM
To: ADO.NET
Subject: [ado_dotnet] Saving XML to multiple tables
Ok...so my asp.net page just received a XML stream via HTTP. That's all
good and dandy...but now how do I strip out the data that I need and put
them in multiple tables? Some of the data goes here and some of the
data
goes there. Can anyone help or direct me to any resources on the web
that
I can use to figure this out?
Thx, Jae.
=3D=3D=3D
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm
Message #3 by "Kevin Ayers" <kevin@f...> on Tue, 11 Mar 2003 15:46:45 -0500
|
|
would the dataset.readxml funcion help?
----- Original Message -----
From: "Jae Hou" <jae@s...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Tuesday, March 11, 2003 8:50 PM
Subject: [ado_dotnet] Saving XML to multiple tables
> Ok...so my asp.net page just received a XML stream via HTTP. That's all
> good and dandy...but now how do I strip out the data that I need and put
> them in multiple tables? Some of the data goes here and some of the data
> goes there. Can anyone help or direct me to any resources on the web that
> I can use to figure this out?
>
> Thx, Jae.
> ===
> Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using ADO.NET
in your applications. The book covers DataSets and Typed DataSets, accessing
data using DataReaders and DataAdaptors, the close relationship between
ADO.NET and XML, how and where to use ADO.NET in your enterprise
applications, and how to use Web Services and ADO.NET to easily pass data
between applications.
> http://www.wrox.com/books/1861007604.htm
Message #4 by "Jae Hou" <jae@s...> on Tue, 11 Mar 2003 21:03:51
|
|
Kailas, thank you for responding.
I'm not sure I understand what you mean by "what kind of xml". It is very
basic xml containing order header info, order detail info, and payment
info.
I will take a look at the site you suggested. TY.
Jae.
> What kind of xml is that?
1) If you can put it in DataSet format, then your table updations become
very easy.
2) If you can divide the XML in fragments and each fragment is going to
a table, then you can create SQL stored procedure, pass the xml fragment
as parameter and using OPENXML command, insert into table directly.
3) Worst solution would be to traverse the xml and put required data in
multiple tables.
Search on perfectxml.com, you will find number of articles.
Thanks,
Kailas.
-----Original Message-----
From: Jae Hou [mailto:jae@s...]
Sent: Tuesday, March 11, 2003 12:51 PM
To: ADO.NET
Subject: [ado_dotnet] Saving XML to multiple tables
Ok...so my asp.net page just received a XML stream via HTTP. That's all
good and dandy...but now how do I strip out the data that I need and put
them in multiple tables? Some of the data goes here and some of the
data
goes there. Can anyone help or direct me to any resources on the web
that
I can use to figure this out?
Thx, Jae.
=3D=3D=3D
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm
Message #5 by "Brian Smith" <bsmith@l...> on Wed, 12 Mar 2003 09:16:26 -0000
|
|
Take a look at the Microsoft XSD schema inference tool
(http://apps.gotdotnet.com/xmltools/xsdinference/)
This will take a sample of your xml and generate a valid xsd schema.
This schmea definition can then be loaded into a DataSet using
ReadXmlSchema() and hey presto, you have tables defined! Just load your
actual data using DataSet.ReadXml().
Brian
-----Original Message-----
From: Jae Hou [mailto:jae@s...]
Sent: Tue, 11 Mar 2003 20:51
To: ADO.NET
Subject: [ado_dotnet] Saving XML to multiple tables
Ok...so my asp.net page just received a XML stream via HTTP. That's all
good and dandy...but now how do I strip out the data that I need and put
them in multiple tables? Some of the data goes here and some of the
data
goes there. Can anyone help or direct me to any resources on the web
that
I can use to figure this out?
Thx, Jae.
===
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
Message #6 by "Rodney Majola" <MajolaR@a...> on Thu, 13 Mar 2003 13:46:51 +0200
|
|
If u have the .Net documentation installed, have a look at the topic: "
"Synchronizing a DataSet with an XmlDataDocument"
Hope it helps ...
-----Original Message-----
From: Brian Smith [mailto:bsmith@l...]
Sent: Wednesday, March 12, 2003 11:16 AM
To: ADO.NET
Subject: [ado_dotnet] RE: Saving XML to multiple tables
Take a look at the Microsoft XSD schema inference tool
(http://apps.gotdotnet.com/xmltools/xsdinference/)
This will take a sample of your xml and generate a valid xsd schema.
This schmea definition can then be loaded into a DataSet using
ReadXmlSchema() and hey presto, you have tables defined! Just load your
actual data using DataSet.ReadXml().
Brian
-----Original Message-----
From: Jae Hou [mailto:jae@s...]
Sent: Tue, 11 Mar 2003 20:51
To: ADO.NET
Subject: [ado_dotnet] Saving XML to multiple tables
Ok...so my asp.net page just received a XML stream via HTTP. That's all
good and dandy...but now how do I strip out the data that I need and put
them in multiple tables? Some of the data goes here and some of the
data
goes there. Can anyone help or direct me to any resources on the web
that
I can use to figure this out?
Thx, Jae.
=3D=3D=3D
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
=3D=3D=3D
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm
|
|
|
View Cart
