private static void BinWriteDataSetToStream(System.IO.Stream stream, System.Data.DataSet ds) { //Version IO.StreamPersistence.Write(stream, c_BinaryVersion); //Schema byte[] byte[] bytesSchema; using (System.IO.MemoryStream schemaStream = new System.IO.MemoryStream()) { ds.WriteXmlSchema(schemaStream); schemaStream.Flush(); schemaStream.Seek(0, System.IO.SeekOrigin.Begin); bytesSchema = schemaStream.ToArray(); } IO.StreamPersistence.Write(stream, bytesSchema); //Tables for (int iTable = 0; iTable < ds.Tables.Count; iTable++) { System.Data.DataTable table = ds.Tables[iTable]; //Only the current Rows System.Data.DataRow[] rows = table.Select(null, null, System.Data.DataViewRowState.CurrentRows); IO.StreamPersistence.Write(stream, rows.Length); //Rows for (int r = 0; r < rows.Length; r++) { //Columns for (int c = 0; c < table.Columns.Count; c++) { BinWriteFieldToStream(stream, rows[r][c], table.Columns[c].DataType); } } } }
private void Form1_FormClosing(object sender, FormClosingEventArgs e) { //Сохранение конфигурации в директории программы. System.Data.DataSet ds = new System.Data.DataSet(); ds.ExtendedProperties["tcp"] = mskTCP.Text; ds.ExtendedProperties["tcpPort"] = numPort.Value; ds.ExtendedProperties["isConnect"] = timerServerRequest.Enabled; ds.WriteXmlSchema(Application.StartupPath + "\\UARTDHT-Client.cfg"); }
public static string CreateSchema(Document doc, string xml) { using (System.Data.DataSet dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader(xml), System.Data.XmlReadMode.InferSchema); using (EncodedStringWriter writer = new EncodedStringWriter(Encoding.UTF8)) { using (XmlTextWriter xmlWriter = XmlEditorService.CreateXmlTextWriter(doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return(writer.ToString()); } } } }
public static string CreateSchema(TextEditor doc, string xml) { using (var dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader(xml), System.Data.XmlReadMode.InferSchema); using (var writer = new EncodedStringWriter(Encoding.UTF8)) { using (var xmlWriter = CreateXmlTextWriter(doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return(writer.ToString()); } } } }
private void Form1_FormClosing(object sender, FormClosingEventArgs e) { serialPort1.Close(); //Сохранение конфигурации в директории программы. System.Data.DataSet ds = new System.Data.DataSet(); ds.ExtendedProperties["tcp"] = cbTCP.Text; ds.ExtendedProperties["tcpPort"] = numPort.Value; ds.ExtendedProperties["isServerStart"] = ThreadServer.IsAlive; ds.ExtendedProperties["tCrit"] = numTCrit.Value; ds.ExtendedProperties["hCrit"] = numHCrit.Value; ds.WriteXmlSchema(Application.StartupPath + "\\UARTDHT.cfg"); }
public static string CreateSchema (TextEditor doc, string xml) { using (System.Data.DataSet dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader (xml), System.Data.XmlReadMode.InferSchema); using (EncodedStringWriter writer = new EncodedStringWriter (Encoding.UTF8)) { using (XmlTextWriter xmlWriter = XmlEditorService.CreateXmlTextWriter (doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return writer.ToString(); } } } }
public void TestQueryingTheDataBase() { try { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM puzzleRUN"; adapter = new OleDbDataAdapter( cmd ); System.Data.DataSet dataSet = new System.Data.DataSet( "Test_DataSet" ); int numRowsAffected = cmd.ExecuteNonQuery(); adapter.Fill( dataSet ); dataSet.WriteXmlSchema( @"\\" + System.Net.Dns.GetHostName() + @"\thepuzzler_3dstyle\ManageStatsWebService\puzzleRUN_DataSet.xsd" ); Assert.IsTrue( true ); } catch( Exception ex ) { HandleException( ref ex ); Assert.IsTrue( false ); } finally { conn.Close(); } }