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