473,382 Members | 1,717 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

DataSets and xs:any

I am trying to specify an xsd schema for a dataset (using
dataset.readxmlschema), before filling the dataset from an xml document
(using dataset.readxml), in order to define relationships between tables.
This gets me a dataset with the relevant relationships between tables etc.

However, I specify in the xsd that an element of a complexType can be
"xs:any". i.e "Allow any other elements to appear here, in addition to those
specified in the schema"
The dataset seems to ignore this, and therefore ignores any data from the
loaded xml.

If I dont specify a dtd at all, the dataset quite happily reads all the
elements in the xml - so why does it not read all elements when xs:any is
specified?

Can I use a schema to define relationships between tables, but also have
some columns in the resulting tables be created from elements not spcified
in the schema?

Thanks in advance,
Chris
Nov 12 '05 #1
0 1255

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dinesh | last post by:
Currently we use a data adapter and a dataset for fetching data from multiple data source. Once we populate the data from each data source we merge all datasets into a single dataset. Hence if...
3
by: Kaveri | last post by:
Currently we use a data adapter and a dataset for fetching data from multiple data source. Once we populate the data from each data source we merge all datasets into a single dataset. Hence if...
0
by: Erik | last post by:
Hi I'm writing a schema for a particular soap message. In the soap schema any content is allowed in the header and body elements. Is it possible to define the elements allowed in the header and...
0
by: CJ | last post by:
I started with this schema: <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="response"> <xs:complexType> <xs:sequence> <xs:element...
0
by: Peter Aberline | last post by:
Hi all, I'm trying to write a schema which defines the following document. <root> <letters> <a>A</a> <dog>DOG<dog> <b>B</b> <fish>FISH</fish>
2
by: Clarence | last post by:
Hi, here is an XML schema excerpt for an employees details. <xs:element name="ADDRESS"> <xs:complexType> <xs:sequence> <xs:element name="ADDRESSLINE" type="xs:string" maxOccurs="6"/>...
2
by: Tjerk Wolterink | last post by:
I've a element definition like this: -- <xs:element name="content"> <xs:complexType> <xs:sequence> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:any...
3
by: Robert Rolls | last post by:
I've got the following really simple schema : <?xml version="1.0" ?> <xs:schema targetNamespace="urn:503A2B4E-B364-47a4-AE5C-16E727275A70" xmlns:mstns="urn:503A2B4E-B364-47a4-AE5C-16E727275A70"...
2
by: Matthew | last post by:
I have implemented the xmlSchemaCollection object to cache commonly used schemas, as follows: =============================================================================== public void...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.