Thanks for your reply William
I have made several attempts and all fails to enforce the constraint. Creating a strongly typed dataset using the designer, then adding (drag and drop) an instance of this dataset to a form together with a datagrid and setting up datagrids datamember and datasource properties in usual manner. No coding required this way, and all works fine except for enforcing the constraints. Have tried various constraints also but to no avail
My example for you follows a different approach. Starting with clean windows application, then adding two items "XML Schema" and "XML File", instead of the usual "Data Set" item, to the application. Then adding a datagrid and a few buttons to the form
*****************************************
***following is the code
*****************************************
***XML Schema, named "EmployeesSchema.xsd"
*********************************
<?xml version="1.0" encoding="utf-8" ?><xs:schema id="EmployeesSchema" targetNamespace="
http://tempuri.org/EmployeesSchema.xsd" elementFormDefault="qualified
xmlns="
http://tempuri.org/EmployeesSchema.xsd" xmlns:mstns="
http://tempuri.org/EmployeesSchema.xsd
xmlns:xs="
http://www.w3.org/2001/XMLSchema"><xs:simpleType name="ZipCode"><xs:restriction base="xs
ositiveInteger"><xs
attern value="\d{5}" /></xs:restriction></xs:simpleType><xs:complexType name="Address"><xs:sequence><xs:element name="Name" type="xs:string" /><xs:element name="Street" type="xs:string" /><xs:element name="State" type="xs:string" /><xs:element name="Zip" type="ZipCode" /></xs:sequence></xs:complexType><xs:element name="EmployeeList"><xs:complexType><xs:sequence><xs:element name="Employee"><xs:complexType><xs:sequence><xs:element name="Email" type="xs:string" /><xs:element name="Password" type="xs:string" /><xs:element name="HomeAddress" type="Address" /><xs:element name="OtherAddress" type="Address" /></xs:sequence></xs:complexType></xs:element></xs:sequence></xs:complexType></xs:element></xs:schema
*************************************
***XML File named "Employees.xml"
***properties for this set to use the EmployeesSchema.xs
*********************************************
<?xml version="1.0" encoding="utf-8" ?><EmployeeList xmlns="
http://tempuri.org/EmployeesSchema.xsd"></EmployeeList
*************************************************************
***cod
***in addition to defining dataset as part of form and creating in form constructor as usual
***private DataSet ds = new DataSet()
*************************************************************
private void btnLoadXML_Click(object sender, System.EventArgs e
// Read the XML Schema into the DataSe
ds.ReadXmlSchema(@"../../EmployeesSchema.xsd")
// Read the XML file into the DataSe
ds.ReadXml(@"../../Employees.xml")
// Bind the grid to the DataSe
dataGrid1.DataSource = ds
private void btnDisplaySchema_Click(object sender, System.EventArgs e
// Call the GetXmlSchema method to display the loaded schem
MessageBox.Show(ds.GetXmlSchema())
private void btnGetXMLSchema_Click(object sender, System.EventArgs e
// Read the XML Schema into the DataSe
ds.ReadXmlSchema(@"../../EmployeesSchema.xsd")
private void btnSaveXML_Click(object sender, System.EventArgs e
// Write out the data in the grid to a new XML fil
ds.WriteXml(@"NewXmlFile.xml")
*****************************code end****************************************
Still constraints are not enforced; ZipCode rejects non integer values as expected but does not enforce the /d{5} constraint.
The Employees.xml have the option of creating a schema file, Employees.xsd. I also added a display schema button that displays the xsd created from the dataset. Using this I have found the following which may indicate cause of error. I would expect the xsd files to be identical as they are all defined from EmployeesSchema.xsd, but they are not
Employees.xsd
<xs:element name="EmployeeList" msdata:IsDataSet="true" msdata:EnforceConstraints="False"
EmployeesSchema.xsd
<xs:element name="EmployeeList">
Schema from Dataset:
<xs:element name="EmployeeList" msdata:IsDataSet="true" >
Also the Schema from Dataset and Employees.xsd:
<xs:simpleType name="ZipCode"><xs:restriction base="xs
ositiveInteger" /></xs:simpleType>
Whilst the EmployeesSchema.xsd is:
<xs:simpleType name="ZipCode"><xs:restriction base="xs
ositiveInteger"><xs
attern value="\d{5}" /></xs:restriction></xs:simpleType>
Rgds,
OJ
**********************************
----- William Ryan eMVP wrote: -----
Frosty:
You're declaring/instantiating a strongly typed dataset or applying the
Schema and the grid is allowing it in ? Normally it just kicks out the
value to whatever it was originally if you put in something that violates
the rules. I've never seen this behavior --- can you show me the code that
makes the dataset (or the declaration of the STD) and the code you use to
bind it?
Howto make datagrid enforce rules of xml schema??
value="\d{5}" /></xs:restriction></xs:simpleType>>> Datagrid does not enforce this rule, even though dataGrid1_Validating() is
called.
