示例#1
0
        static void Main(string[] args)
        {
            test_oneDataSet tst1DS = 
                new test_oneDataSet();
                
            
            test_oneDataSetTableAdapters.ConfigurationsTableAdapter configsTA = 
                new DataWiz2.test_oneDataSetTableAdapters.ConfigurationsTableAdapter();
                
            configsTA.Fill(tst1DS.Configurations);
            
            test_oneDataSetTableAdapters.deviceKeysTableAdapter deviceKeysTA = 
                new DataWiz2.test_oneDataSetTableAdapters.deviceKeysTableAdapter();
            deviceKeysTA.Fill(tst1DS.deviceKeys);
            
            test_oneDataSetTableAdapters.DevicesTableAdapter DevicesTA = 
                new DataWiz2.test_oneDataSetTableAdapters.DevicesTableAdapter();
            DevicesTA.Fill(tst1DS.Devices);
            
            test_oneDataSetTableAdapters.LearnedKeysTableAdapter LearnedKeysTA = 
                new DataWiz2.test_oneDataSetTableAdapters.LearnedKeysTableAdapter();
            LearnedKeysTA.Fill(tst1DS.LearnedKeys);
            
            test_oneDataSetTableAdapters.UsersTableAdapter UsersTA = 
                new DataWiz2.test_oneDataSetTableAdapters.UsersTableAdapter();
            UsersTA.Fill(tst1DS.Users);

            tst1DS.WriteXmlSchema("configs.xsd");
            tst1DS.WriteXml("configs.xml");
            
            Console.WriteLine("EnforceConstraints[" + tst1DS.EnforceConstraints + "]");
            // test constraints by trying to add non existant user configuration..
            DataRow newRow = tst1DS.Configurations.NewRow();
            newRow["UserID"] = 4;
            newRow["ConfigID"] = 4;
            tst1DS.Configurations.Rows.Add(newRow);
            tst1DS.AcceptChanges();
            PrintDataSet(tst1DS);
        }
 public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
     System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
     System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
     test_oneDataSet ds = new test_oneDataSet();
     xs.Add(ds.GetSchemaSerializable());
     System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
     any1.Namespace = "http://www.w3.org/2001/XMLSchema";
     any1.MinOccurs = new decimal(0);
     any1.MaxOccurs = decimal.MaxValue;
     any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
     sequence.Items.Add(any1);
     System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
     any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
     any2.MinOccurs = new decimal(1);
     any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
     sequence.Items.Add(any2);
     System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
     attribute1.Name = "namespace";
     attribute1.FixedValue = ds.Namespace;
     type.Attributes.Add(attribute1);
     System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
     attribute2.Name = "tableTypeName";
     attribute2.FixedValue = "deviceKeysDataTable";
     type.Attributes.Add(attribute2);
     type.Particle = sequence;
     return type;
 }
 public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) {
     test_oneDataSet ds = new test_oneDataSet();
     System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
     System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
     xs.Add(ds.GetSchemaSerializable());
     System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
     any.Namespace = ds.Namespace;
     sequence.Items.Add(any);
     type.Particle = sequence;
     return type;
 }