/// <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; }
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; }
public DataTable ReadToDataTable() { DataTable dt = new DataTable(System.IO.Path.GetFileNameWithoutExtension(FileName)); dt.ReadXmlSchema(this.FileName); dt.ReadXml(FileName); return dt; }
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(); }
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; }
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"); } }
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"); }
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); }
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) { } }
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"); }
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"); }
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); } }
/// <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; }
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"); }
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); } }
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); } }
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); } }
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); }
/// <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); } }
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"); }
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); } }
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"); } } }
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"); }
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"); }
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)); }