|
|
| Joe Pannone 2005-11-22, 10:34 pm |
| I am relatievly new to XML. I am writing an application in VB.NET/ASP.NET
(VS 2k5) where I receive an XML message from my client. the XML message is
data that needs to be INSERTed into my SQL Server. all fields are referenced
in the XML message with the corresponding data. Do I have to parse out the
XML mssage to create the INSERT statement? Isnt there an easier way to
INSERT the data?
I noticed that VS Studio 2k5 comes with MSXML Parser v6, I cant find any
documentation on this. Should this be used to solve my issue?
| |
| Martin Honnen 2005-11-23, 6:36 pm |
|
Joe Pannone wrote:
> I am relatievly new to XML. I am writing an application in VB.NET/ASP.NET
> (VS 2k5) where I receive an XML message from my client. the XML message is
> data that needs to be INSERTed into my SQL Server. all fields are referenced
> in the XML message with the corresponding data. Do I have to parse out the
> XML mssage to create the INSERT statement? Isnt there an easier way to
> INSERT the data?
If you have the XML and a schema then this
<http://www.dotnetjunkies.com/quicks...ss.aspx#xmldata>
should help.
> I noticed that VS Studio 2k5 comes with MSXML Parser v6, I cant find any
> documentation on this.
MSXML is a COM based solution, if you are developing with .NET then use
the managed classes the .NET framework offers for XML and data access.
It is correct that MSXML 6 has been released together with .NET 2.0
respectively Visual Studio 2005 but only the give both the COM world and
the .NET world tools that have the same power and strictness for stuff
like schema validation for instance. Thus if you do not only .NET but
have also script code (e.g. JScript or VBScript in WSH or classic ASP)
or classic VB 6 then using MSXML 6 there should ease and improve XML
data exchange to .NET 2.0.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
| |
| Steven Livingstone 2005-11-23, 6:36 pm |
| Look into SqlXml and UpdateGrams.
steven
Joe Pannone wrote:
> I am relatievly new to XML. I am writing an application in
> VB.NET/ASP.NET (VS 2k5) where I receive an XML message from my
> client. the XML message is data that needs to be INSERTed into my
> SQL Server. all fields are referenced in the XML message with the
> corresponding data. Do I have to parse out the XML mssage to create
> the INSERT statement? Isnt there an easier way to INSERT the data?
> I noticed that VS Studio 2k5 comes with MSXML Parser v6, I cant find
> any documentation on this. Should this be used to solve my issue?
--
| |
| Joe Pannone 2005-11-23, 6:36 pm |
| Thnaks. so MSVML Parser is not my solution. Is there vb.net (.net v2)
command(s) that will get a string with an xmlmessage in it and INSERT into a
SQL table, without haveing to parse every field?
"Martin Honnen" wrote:
>
>
> Joe Pannone wrote:
>
>
> If you have the XML and a schema then this
> <http://www.dotnetjunkies.com/quicks...ss.aspx#xmldata>
> should help.
>
>
> MSXML is a COM based solution, if you are developing with .NET then use
> the managed classes the .NET framework offers for XML and data access.
>
> It is correct that MSXML 6 has been released together with .NET 2.0
> respectively Visual Studio 2005 but only the give both the COM world and
> the .NET world tools that have the same power and strictness for stuff
> like schema validation for instance. Thus if you do not only .NET but
> have also script code (e.g. JScript or VBScript in WSH or classic ASP)
> or classic VB 6 then using MSXML 6 there should ease and improve XML
> data exchange to .NET 2.0.
>
> --
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/
>
|
|
|
|
| Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |