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);
                    }
                }
            }
        }
Beispiel #2
0
 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());
             }
         }
     }
 }
Beispiel #5
0
 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();
            }
        }