minOccurs in XML Schema for Datset

[Lee Atkinson]

Hi

What effect does the presence of minOccurs attribute with columns
defining the tables for a dataset? I understand that, if it is set to
minOccurs=0, then the element does not have to appear in XML using the
XSD, but how does that effect the dataset? Does it allow a dataset to
be filled with a DataAdapter that does not provide that particular
column as output?

Many thanks, Lee

[Ross Donald]

Hi Lee,

If your XSD has minOccurs="1" then DBNull values are not allowed in the
column in the strongly-typed DataSet.

The xsd.exe tool generates code like this:
this.MyRequiredColumn.AllowDBNull = false;

The Set<columnname>Null() and Is<columnname>Null() methods are also not
generated.

--
Ross Donald
Rad Software
Get Intellisense when working with XSL in Visual Studio .NET
http://www.radsoftware.com.au/web/Co...ualStudio.aspx

"Lee Atkinson" <le**************@hotmail.com> wrote in message
news:ab**************************@posting.google.c om...
| Hi
|
| What effect does the presence of minOccurs attribute with columns
| defining the tables for a dataset? I understand that, if it is set to
| minOccurs=0, then the element does not have to appear in XML using the
| XSD, but how does that effect the dataset? Does it allow a dataset to
| be filled with a DataAdapter that does not provide that particular
| column as output?
|
| Many thanks, Lee