XML文件导入到DATASET并且增加数据后导出为XML

昨晚通宵了一夜为了就是做接口用IBM MQ传送数据,目前有一个多层的XML文件是接口规范,我们现在开发环境是.NET,具体是将XML 结构导入到DATASET中然后增加数据,再通过DATASET导出XML,

在测试当中发现只要修改了DATASET的值,那么导出的XML结构就会把数据层次失去,对于这样我们找了好多解决方法没有解决,当时测试的代码如下:

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Xml;

namespace WindowsApplication1

{

/// <summary>

/// Form1 的摘要说明。

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.DataGrid dataGrid1;

/// <summary>

/// 必需的设计器变量。

/// </summary>

private System.ComponentModel.Container components = null;

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Splitter splitter1;

private System.Windows.Forms.DataGrid dataGrid2;

private System.Windows.Forms.DataGrid dataGrid3;

private System.Windows.Forms.DataGrid dataGrid4;

private System.Windows.Forms.DataGrid dataGrid5;

private System.Windows.Forms.DataGrid dataGrid6;

private WindowsApplication1.Dataset1 dataset11;

private System.Data.OleDb.OleDbConnection oleDbConnection1;

private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter2;

private System.Data.OleDb.OleDbCommand oleDbSelectCommand2;

private System.Data.OleDb.OleDbCommand oleDbInsertCommand2;

private System.Data.OleDb.OleDbCommand oleDbUpdateCommand2;

private System.Data.OleDb.OleDbCommand oleDbDeleteCommand2;

private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

private DataSet info;

public Form1()

{

// Windows 窗体设计器支持所必需的

InitializeComponent();

// TODO: 在 InitializeComponent 调用后添加任何构造函数代码

// this.oleDbDataAdapter1.Fill(this.dataset11);

// this.oleDbDataAdapter2.Fill(this.dataset11);

// this.dataGrid1.DataSource = this.dataset11.Tables[0];

// this.dataGrid2.DataSource = this.dataset11.Tables[1];

// DataColumn parentCol;

// DataColumn childCol;

// parentCol = dataset11.Tables[1].Columns["WO_ID"];

// childCol = dataset11.Tables[0].Columns["WO_PID"];

// DataRelation relCustOrder;

// relCustOrder = new DataRelation("CustomersOrders", parentCol, childCol);

// relCustOrder.Nested = true;

// dataset11.Relations.Add(relCustOrder);

// }

//同一个表(WorkOrder)不能是两个嵌套关系中的子表

this.info = new DataSet();

this.info.ReadXmlSchema(Application.StartupPath + @"\MEStoPCS_WorkOrder.xml");

this.info.ReadXml(Application.StartupPath + @"\MEStoPCS_WorkOrder.xml",XmlReadMode.Auto);

// //0

// System.Data.DataColumn C=new DataColumn("WO_ID",typeof(String));

// this.info.Tables[0].Columns.Add(C);

// //2

// System.Data.DataColumn D=new DataColumn("WO_ID",typeof(String));

// this.info.Tables[2].Columns.Add(D);

// //3

// System.Data.DataColumn E=new DataColumn("WO_PID",typeof(String));

// this.info.Tables[3].Columns.Add(E);

// //4

// System.Data.DataColumn F=new DataColumn("WO_PID",typeof(String));

// this.info.Tables[4].Columns.Add(F);

// //5

// System.Data.DataColumn G=new DataColumn("WO_PID",typeof(String));

// this.info.Tables[5].Columns.Add(G);

// //0 1

// this.info.Relations.Remove("WorkOrder_ProductionSelect");

// this.info.Relations.Remove("WorkOrder_PrimalMaterial");

// this.info.Relations.Remove("WorkOrder_SecondaryMaterial");

// DataColumn parentCol;

// DataColumn childCol;

// DataRelation relCustOrder;

// parentCol = this.info.Tables["WorkOrder"].Columns["WO_ID"];

// UniqueConstraint uc = new UniqueConstraint(parentCol,false);

// this.info.Tables["WorkOrder"].Constraints.Add(uc);

// childCol = this.info.Tables["ProductionSelect"].Columns["WO_PID"];

// foreach(Constraint cs in this.info.Tables[3].Constraints )

// {

// if(cs is UniqueConstraint)

// {

// this.info.Tables[3].Constraints.Remove(cs);

// }

// if(cs is ForeignKeyConstraint)

// {

////// this.info.Tables[3].Constraints.Remove(cs);

// }

// foreach(Constraint cs in this.info.Tables[4].Constraints )

// {

// if(cs is UniqueConstraint)

// {

// this.info.Tables[4].Constraints.Remove(cs);

// }

// if(cs is ForeignKeyConstraint)

// {

////// this.info.Tables[4].Constraints.Remove(cs);

// }

// foreach(Constraint cs in this.info.Tables[5].Constraints )

// {

// if(cs is UniqueConstraint)

// {

// this.info.Tables[5].Constraints.Remove(cs);

// }

// if(cs is ForeignKeyConstraint)

// {

//// this.info.Tables[5].Constraints.Remove(cs);

// }

// ForeignKeyConstraint fkc = new ForeignKeyConstraint("2_3",parentCol,childCol);

// this.info.Tables["ProductionSelect"].Constraints.Add(fkc);

////

// parentCol = this.info.Tables["WorkOrder"].Columns["WO_ID"];

// childCol = this.info.Tables["ProductionSelect"].Columns["WO_PID"];

// relCustOrder = new DataRelation("2_3", parentCol, childCol);

// relCustOrder.Nested = true;

// info.Relations.Add(relCustOrder);

// // 2 4

// // tableName "PrimalMaterial" string

// parentCol = this.info.Tables["WorkOrder"].Columns["WO_ID"];

// childCol = this.info.Tables["PrimalMaterial"].Columns["WO_PID"];

// relCustOrder = new DataRelation("2_4", parentCol, childCol);

// relCustOrder.Nested = true;

// info.Relations.Add(relCustOrder);

// // 2 5

// parentCol = this.info.Tables["WorkOrder"].Columns["WO_ID"];

// childCol = this.info.Tables["SecondaryMaterial"].Columns["WO_PID"];

// relCustOrder = new DataRelation("2_5", parentCol, childCol);

// relCustOrder.Nested = true;

// info.Relations.Add(relCustOrder);

this.dataGrid1.DataSource = this.info.Tables[0];

this.dataGrid2.DataSource = this.info.Tables[1];

this.dataGrid3.DataSource = this.info.Tables[2];

this.dataGrid4.DataSource = this.info.Tables[3];

this.dataGrid5.DataSource = this.info.Tables[4];

this.dataGrid6.DataSource = this.info.Tables[5];

}

/// <summary>

/// 清理所有正在使用的资源。

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

base.Dispose( disposing );

}

Windows 窗体设计器生成的代码

/// <summary>

/// 应用程序的主入口点。

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void button1_Click(object sender, System.EventArgs e)

{

//this.info.InferXmlSchema(Application.StartupPath + @"\MEStoPCS_WorkOrder.xml");

this.info.WriteXml(Application.StartupPath + @"\MEStoPCS_WorkOrderinfoday.xml",XmlWriteMode.DiffGram);

this.info.WriteXmlSchema(Application.StartupPath + @"\MEStoPCS_WorkOrderinfoschema.xml");

// this.dataset11.WriteXmlSchema(Application.StartupPath + @"\MEStoPCS_WorkOrderinfodayschema.xml",XmlWriteMode.WriteSchema);

// this.dataset11.WriteXml(Application.StartupPath + @"\MEStoPCS_WorkOrderinfoday.xml",XmlWriteMode.DiffGram);

// this.dataset11.WriteXml(Application.StartupPath + @"\MEStoPCS_WorkOrderinfodayschemainfo.xml",XmlWriteMode.WriteSchema);

// try

// {

// this.oleDbDataAdapter1.Update(this.dataset11.Tables[0]);

// MessageBox.Show("OK","dfsa");

// }

// catch(Exception error)

// {

// MessageBox.Show(error.Message,"dfsa");

// }

}

private void Form1_Load(object sender, System.EventArgs e)

{

}

private void dataadd(DataSet data)

{

}

这是我们的所有测试代码,下面是XML文件

</MessageHead>

<T_OutputMaterialID>eee</T_OutputMaterialID>

<T_PlanningQuantity>eee</T_PlanningQuantity>

<T_ProcessRoute>ee</T_ProcessRoute>

<T_SegmentCode>GY</T_SegmentCode>

<T_planningFinishedTime>ee</T_planningFinishedTime>

<T_PlanningStartTime>2005-05-26 00:30:00</T_PlanningStartTime>

<T_OutputInSiloID>1</T_OutputInSiloID>

<T_CutterID>ee</T_CutterID>

<T_SweatingEquiID>ee</T_SweatingEquiID>

<T_CTFeedder>ee</T_CTFeedder>

</ProductionSelect>

<T_PrimalMaterialID>e</T_PrimalMaterialID>

<T_PrimalMaterialLotID>e</T_PrimalMaterialLotID>

<T_PrimalMaterialOutSiloID>2</T_PrimalMaterialOutSiloID>

</PrimalMaterial>

<T_SecondaryMaterial>e</T_SecondaryMaterial>

<T_SecondaryMaterialID>e</T_SecondaryMaterialID>

<T_SecondaryMaterialLotID>e</T_SecondaryMaterialLotID>

<T_SecondaryMaterialSiloID>e</T_SecondaryMaterialSiloID>

</SecondaryMaterial>

</WorkOrder>

<T_OutputMaterialID>eee</T_OutputMaterialID>

<T_PlanningQuantity>eee</T_PlanningQuantity>

<T_ProcessRoute>ee</T_ProcessRoute>

<T_SegmentCode>GY</T_SegmentCode>

<T_planningFinishedTime>ee</T_planningFinishedTime>

<T_PlanningStartTime>2005-05-26 00:30:00</T_PlanningStartTime>

<T_OutputInSiloID>1</T_OutputInSiloID>

<T_CutterID>ee</T_CutterID>

<T_SweatingEquiID>ee</T_SweatingEquiID>

<T_CTFeedder>ee</T_CTFeedder>

</ProductionSelect>

<T_PrimalMaterialID>e</T_PrimalMaterialID>

<T_PrimalMaterialLotID>e</T_PrimalMaterialLotID>

<T_PrimalMaterialOutSiloID>2</T_PrimalMaterialOutSiloID>

</PrimalMaterial>

<T_SecondaryMaterial>e</T_SecondaryMaterial>

<T_SecondaryMaterialID>e</T_SecondaryMaterialID>

<T_SecondaryMaterialLotID>e</T_SecondaryMaterialLotID>

<T_SecondaryMaterialSiloID>e</T_SecondaryMaterialSiloID>

</SecondaryMaterial>

<T_SecondaryMaterial>ee</T_SecondaryMaterial>

<T_SecondaryMaterialID>e</T_SecondaryMaterialID>

<T_SecondaryMaterialLotID>e</T_SecondaryMaterialLotID>

<T_SecondaryMaterialSiloID>e</T_SecondaryMaterialSiloID>

</SecondaryMaterial>

</WorkOrder>

</MessageBody>

</Message>

到测试了那么多到最后发现XML导入到DATASET时..NET自动给建好了主从关系,一个叫WORKORDER_ID 的主键,还有一个字段我记不住了,你们可以在DATASET调试时看一下,会多出几个字段,那几个字段就是关联这些结构的
乔高峰 2006-01-18 于武汉烟厂

posted on 2006-01-18 09:41 2017_LIVE 阅读(839) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

LIVE

导航

公告

XML文件导入到DATASET并且增加数据后导出为XML