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; }