ReadXmlSchema() public method

public ReadXmlSchema ( Stream stream ) : void
stream Stream
return void
Beispiel #1
0
        /// <summary>
        /// initialize Backup
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void Backup_Load(object sender, EventArgs e)
        {
            var culture = new CultureInfo(CfgFile.Get("Lang"));
            SetCulture(culture);

            restobj = new Restore();
            var myTable = new DataTable("dataTable");
            myTable.Columns.Add(rm.GetString("name"), typeof (string));
            myTable.Columns.Add(rm.GetString("path"), typeof (string));
            myTable.Columns.Add("Date", typeof (DateTime));
            myTable.Columns.Add(rm.GetString("sel"), typeof (bool));

            myTable.ReadXmlSchema(@"schemefile");
            myTable.ReadXml(@"datafile");
            string str = null;

            for (int i = 0; i < myTable.Rows.Count; i++)
            {
                string item = Convert.ToString(myTable.Rows[i][2]);
                if (str != item)
                {
                    lsbMain.Items.Add(item);
                    str = item;
                }
            }
        }
 /// <summary>
 /// 从 XML 文件中读取数据,形成 DataTable.
 /// 
 /// 参考 A0150_Access 项目的 ReadAccessDB.cs
 /// </summary>
 /// <returns></returns>
 private static DataTable LoadDataTable()
 {
     DataTable newDt = new DataTable();
     newDt.ReadXmlSchema(DATATABLE_SCHEMA_XML_FILE);
     newDt.ReadXml(DATATABLE_XML_FILE);
     return newDt;
 }
Beispiel #3
0
        private DataTable Create()
        {
            string dataSchemaPath = Directory.GetCurrentDirectory() + "\\" + dataSchemaName + ".xml";
            string dataPath = Directory.GetCurrentDirectory() + "\\" + dataFileName + ".xml";

            DataTable dt = new DataTable();

            if (File.Exists(dataPath))
            {
                dt.ReadXmlSchema(dataSchemaPath);
                dt.ReadXml(dataPath);
            }
            else
            {
                dt.Columns.Add("VaultName", typeof(string));
                dt.Columns.Add("ArchiveId", typeof(string));
                dt.Columns.Add("ZipName", typeof(string));
                dt.Columns.Add("FilePath", typeof(string));
                dt.Columns.Add("EnterdDate", typeof(DateTime));

                dt.TableName = dataFileName;
                dt.PrimaryKey = new[] { dt.Columns["VaultName"], dt.Columns["ArchiveId"], dt.Columns["FilePath"] };
            }

            return dt;
        }
Beispiel #4
0
        public DataTable ReadToDataTable()
        {
            DataTable dt = new DataTable(System.IO.Path.GetFileNameWithoutExtension(FileName));
            dt.ReadXmlSchema(this.FileName);
            dt.ReadXml(FileName);

            return dt;
        }
Beispiel #5
0
 public DataTable ConvertXMLToDataTable(string xml)
 {
     System.IO.TextReader trDataTable = new System.IO.StringReader(xml.Substring(0, xml.IndexOf("<?xml")));
     System.IO.TextReader trSchema = new System.IO.StringReader(xml.Substring(xml.IndexOf("<?xml")));
     DataTable dtReturn = new DataTable();
     dtReturn.ReadXmlSchema(trSchema);
     dtReturn.ReadXml(trDataTable);
     return dtReturn;
 }
        public ServerForm()
        {
            this._iconList = new List<PictureBox>();
            this._labelList = new List<Label>();
            for (int i = 0; i < 8; i++)
            {
                PictureBox newbox = new PictureBox();
                Point point = new Point((81 + 72*i), 254);
                newbox.Location = point;
                newbox.ImageLocation = Environment.CurrentDirectory + "/../../Resources/buddy_bleu_normal.png";
                newbox.SizeMode = PictureBoxSizeMode.AutoSize;
                newbox.Visible = false;
                this.Controls.Add(newbox);
                _iconList.Add(newbox);

                Label newlabel = new Label();
                newlabel.Font = new Font("Impact", 15);
                newlabel.Visible = false;
                //newlabel.TextAlign = ContentAlignment.MiddleCenter;
                newlabel.Text = "-1";
                newlabel.BackColor = Color.Transparent;
                //newlabel.Location = point;
                newlabel.Parent = _iconList[i];
                _labelList.Add(newlabel);
            }

            Panel panel = new Panel();
            panel.BorderStyle = BorderStyle.FixedSingle;
            panel.Visible = true;
            panel.BackColor = Color.White;
            panel.Location = new Point(66, 311);
            panel.Size = new Size(600, 128);
            this.Controls.Add(panel);
            panel.BringToFront();

            //this._dataObj = new DataPack();

            InitializeComponent();

            DataTable table = new DataTable();
            string schemePath = Environment.CurrentDirectory + "/../../TableScheme.xsd";
            table.ReadXmlSchema(schemePath);

            DataPack._cli_table = table;

            setData();

            this._server = new ServerListener(9000);
            _srv_thread = new Thread(this._server.RegisterClients);
            _srv_thread.Start();
        }
Beispiel #7
0
        public DataTable Get()
        {
            string dataSchemaPath = Directory.GetCurrentDirectory() + "\\" + dataSchemaName + ".xml";
            string dataPath = Directory.GetCurrentDirectory() + "\\" + dataFileName + ".xml";

            DataTable dt = new DataTable();

            if (File.Exists(dataPath))
            {
                dt.ReadXmlSchema(dataSchemaPath);
                dt.ReadXml(dataPath);
            }
            else
            {
                dt = Create();
            }

            return dt;
        }
Beispiel #8
0
		public void XmlSchemaTest7 ()
		{
			DataTable table = new DataTable ();
			
			try {
				table.ReadXmlSchema (string.Empty);
				Assert.Fail ("#1");
			} catch (ArgumentException ex) {
				// The URL cannot be empty
				Assert.AreEqual (typeof (ArgumentException), ex.GetType (), "#2");
				Assert.IsNull (ex.InnerException, "#3");
				Assert.IsNotNull (ex.Message, "#4");
				//Assert.AreEqual ("url", ex.ParamName, "#5");
			}
		}
Beispiel #9
0
		public void XmlSchemaTest5 ()
		{
			MakeParentTable ();
			MakeChildTable ();
			MakeSecondChildTable ();
			MakeDataRelation ();
			
			//Write
			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				childTable.WriteXmlSchema (stream);
			}

			//Read
			DataTable table = new DataTable (childTable.TableName);
			using (FileStream stream = new FileStream (tempFile, FileMode.Open)) {
				table.ReadXmlSchema (stream);
			}
			
			//Check Properties of the table
			Assert.AreEqual (string.Empty, table.Namespace, "#1");
			Assert.IsNull (table.DataSet, "#2");
			Assert.AreEqual (3, table.Columns.Count, "#3");
			Assert.AreEqual (0, table.Rows.Count, "#4");
			Assert.AreEqual (false, table.CaseSensitive, "#5");
			Assert.AreEqual ("ChildTable", table.TableName, "#6");
			Assert.AreEqual (string.Empty, table.Prefix, "#7");
			Assert.AreEqual (1, table.Constraints.Count, "#8");
			Assert.AreEqual ("Constraint1", table.Constraints [0].ToString (), "#9");
			Assert.AreEqual (typeof (UniqueConstraint), table.Constraints [0].GetType(), "#10");
			Assert.AreEqual (0, table.ParentRelations.Count, "#11");
			Assert.AreEqual (0, table.ChildRelations.Count, "#12");
			Assert.AreEqual (0, table.PrimaryKey.Length, "#13");
			
			//First Column
			DataColumn col = table.Columns [0];
			Assert.AreEqual (true, col.AllowDBNull, "#14");
			Assert.AreEqual (true, col.AutoIncrement, "#15");
			Assert.AreEqual (0, col.AutoIncrementSeed, "#16");
			Assert.AreEqual (1, col.AutoIncrementStep, "#17");
			Assert.AreEqual ("Element", col.ColumnMapping.ToString (), "#18");
			Assert.AreEqual ("ChildID", col.ColumnName, "#19");
			Assert.AreEqual (typeof (int), col.DataType, "#20");
			Assert.AreEqual (string.Empty, col.DefaultValue.ToString (), "#21");
			Assert.AreEqual (false, col.DesignMode, "#22");
			Assert.AreEqual ("System.Data.PropertyCollection", col.ExtendedProperties.ToString (), "#23");
			Assert.AreEqual (-1, col.MaxLength, "#24");
			Assert.AreEqual (0, col.Ordinal, "#25");
			Assert.AreEqual (string.Empty, col.Prefix, "#26");
			Assert.AreEqual ("ChildTable", col.Table.ToString (), "#27");
			Assert.AreEqual (true, col.Unique, "#28");

			//Second Column
			col = table.Columns [1];
			Assert.AreEqual (true, col.AllowDBNull, "#29");
			Assert.AreEqual (false, col.AutoIncrement, "#30");
			Assert.AreEqual (0, col.AutoIncrementSeed, "#31");
			Assert.AreEqual (1, col.AutoIncrementStep, "#32");
			Assert.AreEqual ("Element", col.ColumnMapping.ToString (), "#33");
			Assert.AreEqual ("ChildItem", col.Caption, "#34");
			Assert.AreEqual ("ChildItem", col.ColumnName, "#35");
			Assert.AreEqual (typeof (string), col.DataType, "#36");
			Assert.AreEqual (string.Empty, col.DefaultValue.ToString (), "#37");
			Assert.AreEqual (false, col.DesignMode, "#38");
			Assert.AreEqual ("System.Data.PropertyCollection", col.ExtendedProperties.ToString (), "#39");
			Assert.AreEqual (-1, col.MaxLength, "#40");
			Assert.AreEqual (1, col.Ordinal, "#41");
			Assert.AreEqual (string.Empty, col.Prefix, "#42");
			Assert.AreEqual ("ChildTable", col.Table.ToString (), "#42");
			Assert.AreEqual (false, col.Unique, "#43");

			//Third Column
			col = table.Columns [2];
			Assert.AreEqual (true, col.AllowDBNull, "#44");
			Assert.AreEqual (false, col.AutoIncrement, "#45");
			Assert.AreEqual (0, col.AutoIncrementSeed, "#46");
			Assert.AreEqual (1, col.AutoIncrementStep, "#47");
			Assert.AreEqual ("Element", col.ColumnMapping.ToString (), "#48");
			Assert.AreEqual ("ParentID", col.Caption, "#49");
			Assert.AreEqual ("ParentID", col.ColumnName, "#50");
			Assert.AreEqual (typeof (int), col.DataType, "#51");
			Assert.AreEqual (string.Empty, col.DefaultValue.ToString (), "#52");
			Assert.AreEqual (false, col.DesignMode, "#53");
			Assert.AreEqual ("System.Data.PropertyCollection", col.ExtendedProperties.ToString (), "#54");
			Assert.AreEqual (-1, col.MaxLength, "#55");
			Assert.AreEqual (2, col.Ordinal, "#56");
			Assert.AreEqual (string.Empty, col.Prefix, "#57");
			Assert.AreEqual ("ChildTable", col.Table.ToString (), "#58");
			Assert.AreEqual (false, col.Unique, "#59");
		}
Beispiel #10
0
		public void XmlSchemaTest3 ()
		{
			//Write
			MakeParentTable ();

			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				parentTable.WriteXmlSchema (stream);
			}

			//Read
			DataTable table = new DataTable ();
			using (FileStream stream = new FileStream (tempFile, FileMode.Open)) {
				table.ReadXmlSchema (stream);
			}

			VerifyTableSchema (table, parentTable.TableName, null);
		}
Beispiel #11
0
		public void ReadWriteXmlSchemaExp_TableNameConflict ()
		{
			DataTable dtw = new DataTable ("Table1");
			StringWriter writer1 = new StringWriter ();
			dtw.WriteXmlSchema (writer1);
			DataTable dtr = new DataTable ("Table2");
			StringReader reader1 = new StringReader (writer1.ToString());
			try {
				dtr.ReadXmlSchema (reader1);
				Assert.Fail ("#1");
			} catch (ArgumentException) {
			}
		}
Beispiel #12
0
		public void WriteXmlSchema_Relations_ForeignKeys ()
		{
			MemoryStream ms1 = null;
			MemoryStream ms2 = null;
			MemoryStream msA = null;
			MemoryStream msB = null;

			DataSet ds1 = new DataSet ();

			DataTable table1 = ds1.Tables.Add ("Table 1");
			DataTable table2 = ds1.Tables.Add ("Table 2");

			DataColumn col1_1 = table1.Columns.Add ("col 1", typeof (int));
			DataColumn col1_2 = table1.Columns.Add ("col 2", typeof (int));
			DataColumn col1_3 = table1.Columns.Add ("col 3", typeof (int));
			DataColumn col1_4 = table1.Columns.Add ("col 4", typeof (int));
			DataColumn col1_5 = table1.Columns.Add ("col 5", typeof (int));
			DataColumn col1_6 = table1.Columns.Add ("col 6", typeof (int));
			DataColumn col1_7 = table1.Columns.Add ("col 7", typeof (int));

			DataColumn col2_1 = table2.Columns.Add ("col 1", typeof (int));
			DataColumn col2_2 = table2.Columns.Add ("col 2", typeof (int));
			DataColumn col2_3 = table2.Columns.Add ("col 3", typeof (int));
			DataColumn col2_4 = table2.Columns.Add ("col 4", typeof (int));
			DataColumn col2_5 = table2.Columns.Add ("col 5", typeof (int));
			DataColumn col2_6 = table2.Columns.Add ("col 6", typeof (int));
			DataColumn col2_7 = table2.Columns.Add ("col 7", typeof (int));

			ds1.Relations.Add ("rel 1",
				new DataColumn[] { col1_1, col1_2 },
				new DataColumn[] { col2_1, col2_2 },
				false);
			ds1.Relations.Add ("rel 2",
				new DataColumn[] { col1_3, col1_4 },
				new DataColumn[] { col2_3, col2_4 },
				true);
			table2.Constraints.Add ("fk 1",
				new DataColumn[] { col1_5, col1_6 },
				new DataColumn[] { col2_5, col2_6 });
			table1.Constraints.Add ("fk 2",
				new DataColumn[] { col2_5, col2_6 },
				new DataColumn[] { col1_5, col1_6 });

			table1.Constraints.Add ("pk 1", col1_7, true);
			table2.Constraints.Add ("pk 2", col2_7, true);

			ms1 = new MemoryStream ();
			ds1.Tables[0].WriteXmlSchema (ms1);
			ms2 = new MemoryStream ();
			ds1.Tables[1].WriteXmlSchema (ms2);

			msA = new MemoryStream (ms1.GetBuffer ());
			DataTable dtA = new DataTable ();
			dtA.ReadXmlSchema (msA);

			msB = new MemoryStream (ms2.GetBuffer ());
			DataTable dtB = new DataTable ();
			dtB.ReadXmlSchema (msB);

			Assert.AreEqual (3, dtA.Constraints.Count, "#2");
			Assert.AreEqual (2, dtB.Constraints.Count, "#3");

			Assert.IsTrue (dtA.Constraints.Contains ("pk 1"), "#5");
			Assert.IsTrue (dtA.Constraints.Contains ("Constraint1"), "#6");
			Assert.IsTrue (dtA.Constraints.Contains ("Constraint2"), "#7");
			Assert.IsTrue (dtB.Constraints.Contains ("pk 2"), "#9");
			Assert.IsTrue (dtB.Constraints.Contains ("Constraint1"), "#10");
		}
Beispiel #13
0
		public void ReadXmlSchema_ByTextReader ()
		{
			DataSet ds1 = new DataSet ();
			ds1.Tables.Add (DataProvider.CreateParentDataTable ());
			ds1.Tables.Add (DataProvider.CreateChildDataTable ());

			StringWriter sw1 = new StringWriter ();
			StringWriter sw2 = new StringWriter ();
			//write xml file, schema only
			//ds1.WriteXmlSchema (sw);
			ds1.Tables[0].WriteXmlSchema (sw1);
			ds1.Tables[1].WriteXmlSchema (sw2);

			StringReader sr1 = new StringReader (sw1.GetStringBuilder ().ToString ());
			StringReader sr2 = new StringReader (sw2.GetStringBuilder ().ToString ());
			//copy both data and schema
			//DataSet ds2 = new DataSet ();
			DataTable dt1 = new DataTable ();
			DataTable dt2 = new DataTable ();

			//ds2.ReadXmlSchema (sr);
			dt1.ReadXmlSchema (sr1);
			dt2.ReadXmlSchema (sr2);

			//check xml schema
			// ReadXmlSchema - Tables count
			//Assert.AreEqual (ds2.Tables.Count, ds1.Tables.Count, "DS283");

			// ReadXmlSchema - Tables 0 Col count
			Assert.AreEqual (ds1.Tables[0].Columns.Count, dt1.Columns.Count, "DS284");

			// ReadXmlSchema - Tables 1 Col count
			Assert.AreEqual (ds1.Tables[1].Columns.Count, dt2.Columns.Count, "DS285");

			//check some colummns types
			// ReadXmlSchema - Tables 0 Col type
			Assert.AreEqual (ds1.Tables[0].Columns[0].GetType (), dt1.Columns[0].GetType (), "DS286");

			// ReadXmlSchema - Tables 1 Col type
			Assert.AreEqual (ds1.Tables[1].Columns[3].GetType (), dt2.Columns[3].GetType (), "DS287");

			//check that no data exists
			// ReadXmlSchema - Table 1 row count
			Assert.AreEqual (0, dt1.Rows.Count, "DS288");

			// ReadXmlSchema - Table 2 row count
			Assert.AreEqual (0, dt2.Rows.Count, "DS289");
		}
Beispiel #14
0
        private void dlgOpenFile_FileOk(object sender, CancelEventArgs e)
        {
            txtSchemaFileName.Text = dlgOpenSchema.FileName;
            lstSchemaFields.Items.Clear();
            DataTable dt = new DataTable();
            dt.ReadXmlSchema(dlgOpenSchema.FileName);
            //dsMappings.Tables.Add(dt);
            //dsMappings.Tables["tblSchemaFields"].Load(dt.CreateDataReader());

            //lstSchemaFields.DataSource = dt;
            //lstSchemaFields.DisplayMember = dt.Columns[0].ColumnName;

            foreach (DataColumn dc in dt.Columns)
            {
                lstSchemaFields.Items.Add(dc.Caption);
                //DataRow dr = dsMappings.Tables["tblSchemaFields"].NewRow();
                //dr.SetField("fieldName", dc.Caption);
                //dsMappings.Tables["tblSchemaFields"].Rows.Add(dr);
            }
        }
Beispiel #15
0
 /// <summary>
 /// full
 /// </summary>
 /// <returns></returns>
 public DataTable GetProjects()
 {
     DataTable res = new DataTable();
     res.ReadXmlSchema(HttpContext.Current.Server.MapPath(CC.PROJECTS_SCHEMA_FILE_LOCAL_PATH));
     res.ReadXml(HttpContext.Current.Server.MapPath(CC.PROJECTS_FILE_LOCAL_PATH));
     return res;
 }
Beispiel #16
0
		public void ReadXmlSchema_ByStream ()
		{
			DataSet ds1 = new DataSet ();
			ds1.Tables.Add (DataProvider.CreateParentDataTable ());
			ds1.Tables.Add (DataProvider.CreateChildDataTable ());

			MemoryStream ms1 = new MemoryStream ();
			MemoryStream ms2 = new MemoryStream ();
			//write xml  schema only
			//ds1.WriteXmlSchema (ms);
			ds1.Tables[0].WriteXmlSchema (ms1);
			ds1.Tables[1].WriteXmlSchema (ms2);

			MemoryStream ms11 = new MemoryStream (ms1.GetBuffer ());
			MemoryStream ms22 = new MemoryStream (ms2.GetBuffer ());
			//copy schema
			//DataSet ds2 = new DataSet ();
			DataTable dt1 = new DataTable ();
			DataTable dt2 = new DataTable ();

			//ds2.ReadXmlSchema (ms1);
			dt1.ReadXmlSchema (ms11);
			dt2.ReadXmlSchema (ms22);

			//check xml schema
			// ReadXmlSchema - Tables count
			//Assert.AreEqual (ds2.Tables.Count, ds1.Tables.Count, "DS269");

			// ReadXmlSchema - Tables 0 Col count
			Assert.AreEqual (ds1.Tables[0].Columns.Count, dt1.Columns.Count, "DS270");

			// ReadXmlSchema - Tables 1 Col count
			Assert.AreEqual (ds1.Tables[1].Columns.Count, dt2.Columns.Count, "DS271");

			//check some colummns types
			// ReadXmlSchema - Tables 0 Col type
			Assert.AreEqual (ds1.Tables[0].Columns[0].GetType (), dt1.Columns[0].GetType (), "DS272");

			// ReadXmlSchema - Tables 1 Col type
			Assert.AreEqual (ds1.Tables[1].Columns[3].GetType (), dt2.Columns[3].GetType (), "DS273");

			//check that no data exists
			// ReadXmlSchema - Table 1 row count
			Assert.AreEqual (0, dt1.Rows.Count, "DS274");

			// ReadXmlSchema - Table 2 row count
			Assert.AreEqual (0, dt2.Rows.Count, "DS275");
		}
Beispiel #17
0
		public void ReadWriteXmlSchema_ByFileName ()
		{
			string sTempFileName1 = Path.Combine (Path.GetTempPath (), "tmpDataSet_ReadWriteXml_43899-1.xml");
			string sTempFileName2 = Path.Combine (Path.GetTempPath (), "tmpDataSet_ReadWriteXml_43899-2.xml");

			DataSet ds1 = new DataSet ();
			ds1.Tables.Add (DataProvider.CreateParentDataTable ());
			ds1.Tables.Add (DataProvider.CreateChildDataTable ());

			ds1.Tables[0].WriteXmlSchema (sTempFileName1);
			ds1.Tables[1].WriteXmlSchema (sTempFileName2);

			DataTable dt1 = new DataTable ();
			DataTable dt2 = new DataTable ();

			dt1.ReadXmlSchema (sTempFileName1);
			dt2.ReadXmlSchema (sTempFileName2);

			Assert.AreEqual (ds1.Tables[0].Columns.Count, dt1.Columns.Count, "DS277");
			Assert.AreEqual (ds1.Tables[1].Columns.Count, dt2.Columns.Count, "DS278");
			Assert.AreEqual (ds1.Tables[0].Columns[0].GetType (), dt1.Columns[0].GetType (), "DS279");
			Assert.AreEqual (ds1.Tables[1].Columns[3].GetType (), dt2.Columns[3].GetType (), "DS280");
			Assert.AreEqual (0, dt1.Rows.Count, "DS281");
			Assert.AreEqual (0, dt2.Rows.Count, "DS282");

			File.Delete (sTempFileName1);
			File.Delete (sTempFileName2);
		}
		public void ReadXmlSchemeWithoutScheme ()
		{
			const string xml = @"<CustomElement />";
			using (var s = new StringReader (xml)) {
				DataTable dt = new DataTable ();
				dt.ReadXmlSchema (s);
				Assert.AreEqual ("", dt.TableName);
			}
		}
Beispiel #19
0
		public void ReadXmlSchema_ByXmlReader ()
		{
			DataSet ds1 = new DataSet ();
			ds1.Tables.Add (DataProvider.CreateParentDataTable ());
			ds1.Tables.Add (DataProvider.CreateChildDataTable ());

			StringWriter sw1 = new StringWriter ();
			XmlTextWriter xmlTW1 = new XmlTextWriter (sw1);
			StringWriter sw2 = new StringWriter ();
			XmlTextWriter xmlTW2 = new XmlTextWriter (sw2);

			//write xml file, schema only
			ds1.Tables[0].WriteXmlSchema (xmlTW1);
			xmlTW1.Flush ();
			ds1.Tables[1].WriteXmlSchema (xmlTW2);
			xmlTW2.Flush ();

			StringReader sr1 = new StringReader (sw1.ToString ());
			XmlTextReader xmlTR1 = new XmlTextReader (sr1);
			StringReader sr2 = new StringReader (sw2.ToString ());
			XmlTextReader xmlTR2 = new XmlTextReader (sr2);

			//copy both data and schema
			//DataSet ds2 = new DataSet ();
			DataTable dt1 = new DataTable ();
			DataTable dt2 = new DataTable ();

			//ds2.ReadXmlSchema (xmlTR);
			dt1.ReadXmlSchema (xmlTR1);
			dt2.ReadXmlSchema (xmlTR2);

			//check xml schema
			// ReadXmlSchema - Tables count
			//Assert.AreEqual (ds2.Tables.Count, ds1.Tables.Count, "DS290");

			// ReadXmlSchema - Tables 0 Col count
			Assert.AreEqual (ds1.Tables[0].Columns.Count, dt1.Columns.Count, "DS291");

			// ReadXmlSchema - Tables 1 Col count
			Assert.AreEqual (ds1.Tables[1].Columns.Count, dt2.Columns.Count, "DS292");

			//check some colummns types
			// ReadXmlSchema - Tables 0 Col type
			Assert.AreEqual (ds1.Tables[0].Columns[0].GetType (), dt1.Columns[0].GetType (), "DS293");

			// ReadXmlSchema - Tables 1 Col type
			Assert.AreEqual (ds1.Tables[1].Columns[3].GetType (), dt2.Columns[3].GetType (), "DS294");

			//check that no data exists
			// ReadXmlSchema - Table 1 row count
			Assert.AreEqual (0, dt1.Rows.Count, "DS295");

			// ReadXmlSchema - Table 2 row count
			Assert.AreEqual (0, dt2.Rows.Count, "DS296");
		}
		public void ReadXmlSchemeWithScheme ()
		{
			const string xml = @"<CustomElement>
				  <xs:schema id='NewDataSet' xmlns='' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:msdata='urn:schemas-microsoft-com:xml-msdata'>
					<xs:element name='NewDataSet' msdata:IsDataSet='true' msdata:MainDataTable='row' msdata:Locale=''>
					  <xs:complexType>
						<xs:choice minOccurs='0' maxOccurs='unbounded'>
						  <xs:element name='row' msdata:Locale=''>
							<xs:complexType>
							  <xs:sequence>
								<xs:element name='Text' type='xs:string' minOccurs='0' />
							  </xs:sequence>
							</xs:complexType>
						  </xs:element>
						</xs:choice>
					  </xs:complexType>
					</xs:element>
				  </xs:schema>
				</CustomElement>";
			using (var s = new StringReader (xml)) {
				DataTable dt = new DataTable ();
				dt.ReadXmlSchema (s);
				Assert.AreEqual ("row", dt.TableName);
			}
		}
Beispiel #21
0
		public void ReadWriteXmlSchemaExp_NoRootElmnt ()
		{
			MemoryStream ms = new MemoryStream ();
			DataTable dtr = new DataTable ();
			try {
				dtr.ReadXmlSchema (ms);
				Assert.Fail ("#1");
			} catch (XmlException) {
			}
		}
		public void ReadXmlSchemeWithBadScheme ()
		{
			const string xml = @"<CustomElement>
				  <xs:schema id='NewDataSet' xmlns='' xmlns:xs='http://www.w3.org/2001/BAD' xmlns:msdata='urn:schemas-microsoft-com:xml-msdata'>
				  </xs:schema>
				</CustomElement>";
			using (var s = new StringReader (xml)) {
				DataTable dt = new DataTable ();
				dt.ReadXmlSchema (s);
			}
		}
Beispiel #23
0
		public void XmlSchemaTest1 ()
		{
			
			MakeParentTable ();
			//Detach the table from the DataSet
			dataSet.Tables.Remove (parentTable);

			//Write
			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				parentTable.WriteXmlSchema (stream);
			}

			//Read
			DataTable table = new DataTable ();
			using (FileStream stream = new FileStream (tempFile, FileMode.Open)) {
				table.ReadXmlSchema (stream);
			}

			VerifyTableSchema (table, parentTable.TableName, parentTable.DataSet);
		}
Beispiel #24
0
        /// <summary>
        /// handle Click event to delete a shortcut
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDelete_Click(object sender, EventArgs e)
        {
            int rowCount = 0;
            for (int iCounter = 0; iCounter < dgwMain.Rows.Count; iCounter++)
            {
                try
                {
                    if (Convert.ToBoolean(dgwMain.Rows[iCounter].Cells[0].Value))
                    {
                        rowCount++;
                    }
                }
                catch
                {
                }

            }

            if (rowCount > 0)
            {
                DialogResult dialogResult =
                    MessageBox.Show(string.Format("{0} {1} {2}", rm.GetString("are_you_sure"), rowCount.ToString(), rm.GetString("are_you_sure_cont")),
                                    rm.GetString("Confirmation"), MessageBoxButtons.YesNo);

                if (dialogResult == DialogResult.Yes)
                {
                    DataTable myTable = new DataTable("dataTable");

                    try
                    {
                        myTable.ReadXmlSchema(@"schemefile");
                        myTable.ReadXml(@"datafile");

                        string date = Convert.ToString(DateTime.Now);
                        for (int i = 0; i < dgwMain.Rows.Count; i++)
                        {
                            try
                            {
                                string path = dgwMain.Rows[i].Cells[3].Value.ToString();
                                string name = path;
                                name = name.Substring(name.LastIndexOf("\\") + 1, name.Length - name.LastIndexOf("\\") - 1);

                                if (Convert.ToBoolean(dgwMain.Rows[i].Cells[0].Value))
                                {
                                    //enable copy it on Data Folder
                                    File.Copy(path, @"Data\\" + name, true);
                                    myTable.Rows.Add(false, name, path, date);
                                    File.Delete(path);
                                }
                            }
                            catch (Exception)
                            {
                            }
                        }

                        for (int i = dgwMain.Rows.Count - 1; i >= 0; i--)
                        {
                            try
                            {
                                string path = dgwMain.Rows[i].Cells[3].Value.ToString();
                                if (!File.Exists(path))
                                {
                                    dgwMain.Rows.RemoveAt(i);
                                }
                            }
                            catch { }
                        }

                        myTable.WriteXml(@"datafile");
                    }

                    catch (Exception)
                    {
                    }
                }

                ControlToolStripButtonsState();
                ControlToolStripCheckButtonsState();
            }
            else
            {
                MessageBox.Show(rm.GetString("atleast_one"), rm.GetString("shortcut_fixer"), MessageBoxButtons.OK,
                                MessageBoxIcon.Warning);
            }
        }
Beispiel #25
0
		public void XmlSchemaTest4 ()
		{
			MakeParentTable ();
			MakeChildTable ();
			MakeSecondChildTable ();
			MakeDataRelation ();

			//Write
			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				parentTable.WriteXmlSchema (stream, true);
			}

			//Read
			DataTable table = new DataTable ();
			using (FileStream stream = new FileStream (tempFile, FileMode.Open)) {
				table.ReadXmlSchema (stream);
			}

			//Test Property of Parent
			VerifyParentTableSchema (table, parentTable.TableName, parentTable.DataSet);

			//Check Properties of First Child Table
			DataTable firstChildTable = parentTable.ChildRelations [0].ChildTable;
			Assert.AreEqual (string.Empty, firstChildTable.Namespace, "#1");
			Assert.AreEqual ("XmlSchemaDataSet", firstChildTable.DataSet.DataSetName, "#2");
			Assert.AreEqual (3, firstChildTable.Columns.Count, "#3");
			Assert.AreEqual (6, firstChildTable.Rows.Count, "#4");
			Assert.AreEqual (false, firstChildTable.CaseSensitive, "#5");
			Assert.AreEqual ("ChildTable", firstChildTable.TableName, "#6");
			Assert.AreEqual (string.Empty, firstChildTable.Prefix, "#7");
			Assert.AreEqual (2, firstChildTable.Constraints.Count, "#8");
			Assert.AreEqual ("Constraint1", firstChildTable.Constraints [0].ToString (), "#9");
			Assert.AreEqual ("ParentChild_Relation1", firstChildTable.Constraints [1].ToString (), "#10");
			Assert.AreEqual (1, firstChildTable.ParentRelations.Count, "#11");
			Assert.AreEqual (0, firstChildTable.ChildRelations.Count, "#12");
			Assert.AreEqual (0, firstChildTable.PrimaryKey.Length, "#13");
			
			//Check Properties of Second Child Table
			DataTable secondChildTable = parentTable.ChildRelations [1].ChildTable;
			Assert.AreEqual (string.Empty, secondChildTable.Namespace, "#14");
			Assert.AreEqual ("XmlSchemaDataSet", secondChildTable.DataSet.DataSetName, "#15");
			Assert.AreEqual (4, secondChildTable.Columns.Count, "#16");
			Assert.AreEqual (6, secondChildTable.Rows.Count, "#17");
			Assert.AreEqual (false, secondChildTable.CaseSensitive, "#18");
			Assert.AreEqual ("SecondChildTable", secondChildTable.TableName, "#19");
			Assert.AreEqual (string.Empty, secondChildTable.Prefix, "#20");
			Assert.AreEqual (2, secondChildTable.Constraints.Count, "#21");
			Assert.AreEqual ("Constraint1", secondChildTable.Constraints [0].ToString (), "#22");
			Assert.AreEqual ("ParentChild_Relation2", secondChildTable.Constraints [1].ToString (), "#23");
			Assert.AreEqual (1, secondChildTable.ParentRelations.Count, "#24");;
			Assert.AreEqual (0, secondChildTable.ChildRelations.Count, "#25");
			Assert.AreEqual (0, secondChildTable.PrimaryKey.Length, "#26");
			
		}
Beispiel #26
0
 private void loadToolStripMenuItem_Click(object sender, EventArgs e)
 {
     OpenFileDialog fileDialog = new OpenFileDialog();
     fileDialog.DefaultExt = ".xsd";
     fileDialog.AddExtension = true;
     fileDialog.Filter = "Files (*.xsd)|*.xsd";
     if (fileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
     {
         tabControl1.TabPages[tabControl1.SelectedIndex].Text = fileDialog.SafeFileName;
         //Console.WriteLine("FileDialog Done");
         DataTable dt = new DataTable();
         //Console.WriteLine("Create DataTable ds Done");
         dt.ReadXmlSchema(fileDialog.FileName);
         dt.ReadXml(fileDialog.FileName);
         //Console.WriteLine("ReadXml from FileDialog Done");
         dataGridView1.DataSource = dt;
         //Console.WriteLine("Set dataGridView1.DataSource to DataTable dt Done");
         lastSavedFile = fileDialog.FileName;
         backgroundWorker1.RunWorkerAsync();
         backgroundWorker1.DoWork += new DoWorkEventHandler(backgroundWorker1_DoWork);
     }
 }
Beispiel #27
0
		public void XmlSchemaTest6 ()
		{
			MakeParentTable ();

			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				parentTable.WriteXmlSchema (stream);
			}

			DataTable table = new DataTable ();
			DataSet ds = new DataSet ();
			ds.Tables.Add (table);
			
			using (FileStream stream = new FileStream (tempFile, FileMode.Open)) {
				try {
					table.ReadXmlSchema (stream);
					Assert.Fail ("#1");
				} catch (ArgumentException ex) {
					// DataTable 'Table1' does not match
					// to any DataTable in source
					Assert.AreEqual (typeof (ArgumentException), ex.GetType (), "#2");
					Assert.IsNull (ex.InnerException, "#3");
					Assert.IsNotNull (ex.Message, "#4");
					Assert.IsTrue (ex.Message.IndexOf ("'Table1'") != -1, "#5");
					Assert.IsNull (ex.ParamName, "#6");
				}
			}
		}
Beispiel #28
0
		public void ReadXmlSchema ()
		{
			DataTable Table = new DataTable ();
			Table.ReadXmlSchema ("Test/System.Data/own_schema1.xsd");

			Assert.AreEqual ("test_table", Table.TableName, "test#02");
			Assert.AreEqual ("", Table.Namespace, "test#03");
			Assert.AreEqual (2, Table.Columns.Count, "test#04");
			Assert.AreEqual (0, Table.Rows.Count, "test#05");
			Assert.IsFalse (Table.CaseSensitive, "test#06");
			Assert.AreEqual (1, Table.Constraints.Count, "test#07");
			Assert.AreEqual ("", Table.Prefix, "test#08");

			Constraint cons = Table.Constraints[0];
			Assert.AreEqual ("Constraint1", cons.ConstraintName.ToString (), "test#09");
			Assert.AreEqual ("Constraint1", cons.ToString (), "test#10");

			DataColumn column = Table.Columns[0];
			Assert.IsTrue (column.AllowDBNull, "test#11");
			Assert.IsFalse (column.AutoIncrement, "test#12");
			Assert.AreEqual (0L, column.AutoIncrementSeed, "test#13");
			Assert.AreEqual (1L, column.AutoIncrementStep, "test#14");
			Assert.AreEqual ("test", column.Caption, "test#15");
			Assert.AreEqual ("Element", column.ColumnMapping.ToString (), "test#16");
			Assert.AreEqual ("first", column.ColumnName, "test#17");
			Assert.AreEqual (typeof (string), column.DataType, "test#18");
			Assert.AreEqual ("test_default_value", column.DefaultValue.ToString (), "test#19");
			Assert.IsFalse (column.DesignMode, "test#20");
			Assert.AreEqual ("", column.Expression, "test#21");
			Assert.AreEqual (100, column.MaxLength, "test#22");
			Assert.AreEqual ("", column.Namespace, "test#23");
			Assert.AreEqual (0, column.Ordinal, "test#24");
			Assert.AreEqual ("", column.Prefix, "test#25");
			Assert.IsFalse (column.ReadOnly, "test#26");
			Assert.IsTrue (column.Unique, "test#27");

			DataColumn column2 = Table.Columns[1];
			Assert.IsTrue (column2.AllowDBNull, "test#28");
			Assert.IsFalse (column2.AutoIncrement, "test#29");
			Assert.AreEqual (0L, column2.AutoIncrementSeed, "test#30");
			Assert.AreEqual (1L, column2.AutoIncrementStep, "test#31");
			Assert.AreEqual ("second", column2.Caption, "test#32");
			Assert.AreEqual ("Element", column2.ColumnMapping.ToString (), "test#33");
			Assert.AreEqual ("second", column2.ColumnName, "test#34");
			Assert.AreEqual (typeof (SqlGuid), column2.DataType, "test#35");
			Assert.AreEqual (SqlGuid.Null, column2.DefaultValue, "test#36");
			Assert.AreEqual (typeof (SqlGuid), column2.DefaultValue.GetType (), "test#36-2");
			Assert.IsFalse (column2.DesignMode, "test#37");
			Assert.AreEqual ("", column2.Expression, "test#38");
			Assert.AreEqual (-1, column2.MaxLength, "test#39");
			Assert.AreEqual ("", column2.Namespace, "test#40");
			Assert.AreEqual (1, column2.Ordinal, "test#41");
			Assert.AreEqual ("", column2.Prefix, "test#42");
			Assert.IsFalse (column2.ReadOnly, "test#43");
			Assert.IsFalse (column2.Unique, "test#44");

			DataTable Table2 = new DataTable ();
			Table2.ReadXmlSchema ("Test/System.Data/own_schema2.xsd");

			Assert.AreEqual ("second_test_table", Table2.TableName, "test#45");
			Assert.AreEqual ("", Table2.Namespace, "test#46");
			Assert.AreEqual (1, Table2.Columns.Count, "test#47");
			Assert.AreEqual (0, Table2.Rows.Count, "test#48");
			Assert.IsFalse (Table2.CaseSensitive, "test#49");
			Assert.AreEqual (1, Table2.Constraints.Count, "test#50");
			Assert.AreEqual ("", Table2.Prefix, "test#51");

			DataColumn column3 = Table2.Columns[0];
			Assert.IsTrue (column3.AllowDBNull, "test#52");
			Assert.IsFalse (column3.AutoIncrement, "test#53");
			Assert.AreEqual (0L, column3.AutoIncrementSeed, "test#54");
			Assert.AreEqual (1L, column3.AutoIncrementStep, "test#55");
			Assert.AreEqual ("second_first", column3.Caption, "test#56");
			Assert.AreEqual ("Element", column3.ColumnMapping.ToString (), "test#57");
			Assert.AreEqual ("second_first", column3.ColumnName, "test#58");
			Assert.AreEqual (typeof (string), column3.DataType, "test#59");
			Assert.AreEqual ("default_value", column3.DefaultValue.ToString (), "test#60");
			Assert.IsFalse (column3.DesignMode, "test#61");
			Assert.AreEqual ("", column3.Expression, "test#62");
			Assert.AreEqual (100, column3.MaxLength, "test#63");
			Assert.AreEqual ("", column3.Namespace, "test#64");
			Assert.AreEqual (0, column3.Ordinal, "test#65");
			Assert.AreEqual ("", column3.Prefix, "test#66");
			Assert.IsFalse (column3.ReadOnly, "test#67");
			Assert.IsTrue (column3.Unique, "test#68");
		}
Beispiel #29
0
		public void XmlSchemaTest9 ()
		{
			MakeParentTable ();

			using (FileStream stream = new FileStream (tempFile, FileMode.Create)) {
				parentTable.WriteXmlSchema (stream);
			}
		
			//Create a table and define the full schema 
			DataTable table = new DataTable ();
			table.Columns.Add (new DataColumn (parentTable.Columns [0].ColumnName, typeof (int)));
			table.Columns.Add (new DataColumn (parentTable.Columns [1].ColumnName, typeof (string)));
			table.Columns.Add (new DataColumn (parentTable.Columns [2].ColumnName, typeof (int)));

			//ReadXmlSchema will not read any schema in this case
			table.ReadXmlSchema (tempFile);

			Assert.AreEqual (string.Empty, table.TableName, "#1");
			Assert.AreEqual (3, table.Columns.Count, "#2");
			Assert.AreEqual (0, table.Constraints.Count, "#3");
		}
Beispiel #30
0
		public void ReadXmlSchema_2 ()
		{
			DataTable dt = new DataTable ();
			string xmlData = string.Empty;
			xmlData += "<?xml version=\"1.0\"?>";
			xmlData += "<xs:schema id=\"SiteConfiguration\" targetNamespace=\"http://tempuri.org/PortalCfg.xsd\" xmlns:mstns=\"http://tempuri.org/PortalCfg.xsd\" xmlns=\"http://tempuri.org/PortalCfg.xsd\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:msdata=\"urn:schemas-microsoft-com:xml-msdata\" attributeFormDefault=\"qualified\" elementFormDefault=\"qualified\">";
			xmlData += "<xs:element name=\"SiteConfiguration\" msdata:IsDataSet=\"true\" msdata:EnforceConstraints=\"False\">";
			xmlData += "<xs:complexType>";
			xmlData += "<xs:choice  minOccurs=\"0\" maxOccurs=\"unbounded\">";
			xmlData += "<xs:element name=\"Tab\">";
			xmlData += "<xs:complexType>";
			xmlData += "<xs:sequence>";
			xmlData += "<xs:element name=\"Module\" minOccurs=\"0\" maxOccurs=\"unbounded\">";
			xmlData += "<xs:complexType>";
			xmlData += "<xs:attribute name=\"ModuleId\" form=\"unqualified\" type=\"xs:int\" />";
			xmlData += "</xs:complexType>";
			xmlData += "</xs:element>";
			xmlData += "</xs:sequence>";
			xmlData += "<xs:attribute name=\"TabId\" form=\"unqualified\" type=\"xs:int\" />";
			xmlData += "</xs:complexType>";
			xmlData += "</xs:element>";
			xmlData += "</xs:choice>";
			xmlData += "</xs:complexType>";
			xmlData += "<xs:key name=\"TabKey\" msdata:PrimaryKey=\"true\">";
			xmlData += "<xs:selector xpath=\".//mstns:Tab\" />";
			xmlData += "<xs:field xpath=\"@TabId\" />";
			xmlData += "</xs:key>";
			xmlData += "<xs:key name=\"ModuleKey\" msdata:PrimaryKey=\"true\">";
			xmlData += "<xs:selector xpath=\".//mstns:Module\" />";
			xmlData += "<xs:field xpath=\"@ModuleID\" />";
			xmlData += "</xs:key>";
			xmlData += "</xs:element>";
			xmlData += "</xs:schema>";
			dt.ReadXmlSchema (new StringReader (xmlData));
		}