XML Dataset Schema and Required Fields

[Matthew Hood]

I'm just starting to learn VB.NET (comming from VB6) and I'm having a little
difficulty with datasets.

I have created an XML Schema Dataset by dragging and dropping MS Access
tables onto the design view.
In Access, I designed the fields to have 1 primary Key field (GUID) and
several "Required" fields.

I'm using the Janus GridEX.NET bound to the dataset to view and edit my
data. I discovered that I am able to create new records to the "In-Memory"
dataset as long as I have a primary key.
How do I go about defining the tables on the XML Schema to use required
fields, and thus get an error when the grid adds a new record without the
required data?

Any help is appreciated,
TIA,
-Matt

 

[Cor]

Hi Matthew,

What is the reason you are not using the normal datagrid from dotNet, it is
much easier to answer you if the one in the newsgroup who helps you knows
about what he is talking.

Now you have to find that needle in the bottle of hay, which maybe uses also
that Janus GridEX.net with MS Access using the designer, which can help you.

Just my thought,

Cor

 

[Jay B. Harlow [MVP - Outlook]]

Matthew,
I have the Janus GridEX.NET, however I have not used it for a lot of data
binding yet...

However this sounds more like a XML Schema questions then a GridEX.NET
question.

After you drag the Access table to the DataSet have you tried to select each
field in the designer and change the 'nillable' and 'minOccurs' and
'maxOccurs' properties?

I don't have the reference handy, I seem to remember a minOccurs of blank
means optional.

Post if changing the above properties are still causing you problems, I will
try to look closer this evening.

Hope this helps
Jay

 

[Matthew Hood]

The minOccurs to blank did the trick.

Thanks alot for the help. It's greatly appreciated.
-Matt