469,358 Members | 1,659 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Datset mapping to element/attribute

mid
Hello!
First please understand tha my xml knowledge is very very short. I'm new at
xml world.

I need to understand how do I map a given sqlColumn to a xml element or
attribute.
I was given a XSD that has a certain number of elements and attibutes. This
XSD was provided by another company so that my company can create a xml
file filled with data that comes from my database.

In order to acomplish this I think I will have to query my database and
stream the results to the xml file that will be validated by the XSD. Am I
correct? But my collumn names that are in the tables inside my dataset are
different of those specified in the XSD.

How can I dinamically create the correct xml element/node with the correct
name as specified in the XSD?

What is the correct path / logic to this goal?

Please point me to the correct way

I am using vb.net,vs2003
TIA
mid

Nov 12 '05 #1
2 2044
You have to do the mapping yourself between the db schema and the XSD
provided to you.

There is a nifty capability in SQL Server 2000 to help you here, but still
it is not automatic. It cannot magically map between the two disparate
schema. Also it works with SQL Server only of course. Other DB's may have
similar capabilities, I don't know.

See here
http://www.extremeexperts.com/Expert...abilities.aspx
http://www.samspublishing.com/articl...le.asp?p=99813

-Dino
"mid" <mi*********@midbarnospam.org> wrote in message
news:6s**************@midbarnospam.org...
Hello!
First please understand tha my xml knowledge is very very short. I'm new at xml world.

I need to understand how do I map a given sqlColumn to a xml element or
attribute.
I was given a XSD that has a certain number of elements and attibutes. This XSD was provided by another company so that my company can create a xml
file filled with data that comes from my database.

In order to acomplish this I think I will have to query my database and
stream the results to the xml file that will be validated by the XSD. Am I
correct? But my collumn names that are in the tables inside my dataset are
different of those specified in the XSD.

How can I dinamically create the correct xml element/node with the correct
name as specified in the XSD?

What is the correct path / logic to this goal?

Please point me to the correct way

I am using vb.net,vs2003
TIA
mid

Nov 12 '05 #2
You have to do the mapping yourself between the db schema and the XSD
provided to you.

There is a nifty capability in SQL Server 2000 to help you here, but still
it is not automatic. It cannot magically map between the two disparate
schema. Also it works with SQL Server only of course. Other DB's may have
similar capabilities, I don't know.

See here
http://www.extremeexperts.com/Expert...abilities.aspx
http://www.samspublishing.com/articl...le.asp?p=99813

-Dino
"mid" <mi*********@midbarnospam.org> wrote in message
news:6s**************@midbarnospam.org...
Hello!
First please understand tha my xml knowledge is very very short. I'm new at xml world.

I need to understand how do I map a given sqlColumn to a xml element or
attribute.
I was given a XSD that has a certain number of elements and attibutes. This XSD was provided by another company so that my company can create a xml
file filled with data that comes from my database.

In order to acomplish this I think I will have to query my database and
stream the results to the xml file that will be validated by the XSD. Am I
correct? But my collumn names that are in the tables inside my dataset are
different of those specified in the XSD.

How can I dinamically create the correct xml element/node with the correct
name as specified in the XSD?

What is the correct path / logic to this goal?

Please point me to the correct way

I am using vb.net,vs2003
TIA
mid

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Gordon Dickens | last post: by
1 post views Thread by Lee Atkinson | last post: by
reply views Thread by magister | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.