XML / XSL

Axiom70m wrote:

that doesn't work.

<AfasGetConnector>
  <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="AfasGetConnector">
      <xs:complexType>
        <xs:choice maxOccurs="unbounded">
          <xs:element name="MNINT_Summary">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="Itemtype" type="xs:string" minOccurs="0" />
                etc etc
                <xs:element name="Afbeelding_in_Summary" type="xs:boolean" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <MNINT_Summary>
    <Itemtype>2</Itemtype>
    <Itemcode>0401023100</Itemcode>
    <Omschrijving>Tales Legends - The Erzberg</Omschrijving>
    <Gewichtseenheid_code>3</Gewichtseenheid_code>
    <Bruto_gewicht>16</Bruto_gewicht>
    <Bestandsnaam ShowImage="">ERZBERGAVRV.JPG</Bestandsnaam>
    <Artikelcode>3988</Artikelcode>
    <Nominale_waarde>€ 10</Nominale_waarde>
    <Jaartal>2010</Jaartal>
    <Metaal>Silver</Metaal>
    <Kwaliteit>Proof</Kwaliteit>
    <Fijnheid>.925</Fijnheid>
    <Diameter>32</Diameter>
    <Mintage>40000</Mintage>
    <Prijs_5>24</Prijs_5>
    <Prijs_25>22</Prijs_25>
    <Prijs_50>20.75</Prijs_50>
    <Prijs_100>19.9</Prijs_100>
    <Sold_Out>false</Sold_Out>
    <Land>Austria</Land>
    <Logo_mint>AUT</Logo_mint>
    <Gewijzigd_op>2010-03-10</Gewijzigd_op>
    <Aangemaakt_op>2009-10-06</Aangemaakt_op>
    <Uitgifte_datum>2010-04-14</Uitgifte_datum>
    <Opnemen_in_Summary>false</Opnemen_in_Summary>
    <Afbeelding_in_Summary>true</Afbeelding_in_Summary>
  </MNINT_Summary>
  <MNINT_Summary>
    <Itemtype>2</Itemtype>
    <Itemcode>0401023400</Itemcode>
    <Omschrijving>Tales Legends - The Erzberg</Omschrijving>
    <Gewichtseenheid_code>3</Gewichtseenheid_code>
    <Bruto_gewicht>16</Bruto_gewicht>
    <Bestandsnaam ShowImage="">ERZBERGAVRV.JPG</Bestandsnaam>
    <Artikelcode>3984</Artikelcode>
    <Nominale_waarde>€ 10</Nominale_waarde>
    <Jaartal>2010</Jaartal>
    <Metaal>Silver</Metaal>
    <Kwaliteit>Unc</Kwaliteit>
    <Fijnheid>.925</Fijnheid>
    <Diameter>32</Diameter>
    <Mintage>130000</Mintage>
    <Prijs_5>12.5</Prijs_5>
    <Prijs_25>11.75</Prijs_25>
    <Prijs_50>11.25</Prijs_50>
    <Prijs_100>11</Prijs_100>
    <Sold_Out>false</Sold_Out>
    <Land>Austria</Land>
    <Logo_mint>AUT</Logo_mint>
    <Gewijzigd_op>2010-03-10</Gewijzigd_op>
    <Aangemaakt_op>2009-10-06</Aangemaakt_op>
    <Uitgifte_datum>2010-04-14</Uitgifte_datum>
    <Opnemen_in_Summary>false</Opnemen_in_Summary>
    <Afbeelding_in_Summary>true</Afbeelding_in_Summary>
  </MNINT_Summary>
  <MNINT_Summary>
    <Itemtype>2</Itemtype>
    <Itemcode>0401024300</Itemcode>
    <Omschrijving>Renewable Energy NIOB</Omschrijving>
    <Gewichtseenheid_code>3</Gewichtseenheid_code>
    <Bruto_gewicht>9.1</Bruto_gewicht>
    <Bestandsnaam ShowImage="">25EErneuerbareEnergieAVRV.JPG</Bestandsnaam>
    <Artikelcode>3983</Artikelcode>
    <Nominale_waarde>25 €</Nominale_waarde>
    <Jaartal>2010</Jaartal>
    <Metaal>Silver</Metaal>
    <Kwaliteit>B.U.</Kwaliteit>
    <Fijnheid>.9</Fijnheid>
    <Diameter>34</Diameter>
    <Mintage>65000</Mintage>
    <Prijs_5>44</Prijs_5>
    <Prijs_25>42.25</Prijs_25>
    <Prijs_50>40.5</Prijs_50>
    <Prijs_100>39.5</Prijs_100>
    <Sold_Out>false</Sold_Out>
    <Land>Austria</Land>
    <Logo_mint>AUT</Logo_mint>
    <Gewijzigd_op>2010-02-03</Gewijzigd_op>
    <Aangemaakt_op>2009-10-06</Aangemaakt_op>
    <Uitgifte_datum>2010-03-10</Uitgifte_datum>
    <Opnemen_in_Summary>false</Opnemen_in_Summary>
    <Afbeelding_in_Summary>true</Afbeelding_in_Summary>
  </MNINT_Summary>
</AfasGetConnector>

For Each row As GridViewRow In GrdImagesSel.Rows
            Dim cbSi As CheckBox = row.FindControl("chkShowImage")
            'add the Itemcode to the row index
            Dim productID As String = Convert.ToString(GrdImagesSel.DataKe(row.RowIndex).Value)            

XmlNode node = doc.SelectSingleNode("AfasGetConnector/MNINT_Summary[Itemcode=productID]");

For Each row As GridViewRow In GrdImagesSel.Rows
           Dim cbSi As CheckBox = row.FindControl("chkShowImage")
           'Koppel Itemcode van de row aan productID en

           If cbSi IsNot Nothing AndAlso cbSi.Checked Then
               Dim productID As String = Convert.ToString(GrdImagesSel.DataKeys(row.RowIndex).Value)
               Dim root As XmlNode = xmldoc.DocumentElement
               Dim nodeList As XmlNodeList = root.SelectNodes("MNINT_Summary/Itemcode")
               For Each productNode As XmlNode In nodeList
                   If productNode.FirstChild.InnerText = productID Then
                       Dim ShowImage As XmlElement = xmldoc.CreateElement("ShowImage")
                       productNode.AppendChild(ShowImage)
                       ShowImage.InnerText = "1"
                   End If
               Next
           Else
               Dim productID As String = Convert.ToString(GrdImagesSel.DataKeys(row.RowIndex).Value)
               Dim root As XmlNode = xmldoc.DocumentElement
               Dim nodeList As XmlNodeList = root.SelectNodes("MNINT_Summary/Itemcode")
               For Each productNode As XmlNode In nodeList
                   If productNode.FirstChild.InnerText = productID Then
                       Dim ShowImage As XmlElement = xmldoc.CreateElement("ShowImage")
                       productNode.AppendChild(ShowImage)
                       ShowImage.InnerText = "0"
                   End If
               Next
           End If
       Next

XmlDocument XDoc = new XmlDocument();
        XmlElement Xchores = XDoc.CreateElement("day");
        XmlElement XElemRoot = XDoc.CreateElement("chores");
        XElemRoot.AppendChild(Xchores);
        Xchores.SetAttribute("label", "" + this.txtBoxCat.Text + "");
        // Create root node.
        //Add the node to the document.
        XDoc.AppendChild(XElemRoot);
        XmlElement Xjob = XDoc.CreateElement("job");
        while (this.Label5.Text == "1")
        {
            Xjob.SetAttribute("a", "" + this.txtBoxAbout.Text + "");
            Xjob.SetAttribute("b", "" + this.txtBoxSize.Text + "");
            Xjob.SetAttribute("c", "" + this.txtBoxPrice.Text + "");
            Xjob.SetAttribute("d", "" + this.txtBoxAmount.Text + "");
            Xchores.AppendChild(Xjob);
            XDoc.Save("chores2.xml");
        } 

    DataSet ds = new DataSet();
        ds.ReadXml("chores2.xml");        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("a"));
        dt.Columns.Add(new DataColumn("b"));
        dt.Columns.Add(new DataColumn("c"));
        dt.Columns.Add(new DataColumn("d"));
        DataRow dr = dt.NewRow();
        dr[0] = ""+this.txtBoxSize.Text+"";
        dr[1] = "" + this.txtBoxAbout.Text + "";
        dr[2] = "" + this.txtBoxAmount.Text + "";
        dr[3] = "" + this.txtBoxSize.Text + "";
        dt.Rows.Add(dr);
        ds.Tables.Add(dt);
        ds.Relations.Add(new
DataRelation("myrel", ds.Tables[1].Columns[0], ds.Tables[0].Columns[0]));
        ds.Relations[0].Nested = true;
        ds.WriteXml("chores2.xml");

OleDbConnection con = new OleDbConnection();
        con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb";
        OleDbDataAdapter da = new OleDbDataAdapter("Select * from job1", con);
        DataSet ds = new DataSet("chores");
        DataTable xjob = new DataTable();
        xjob = xjob.Tables["job"];
        da.Fill(ds, "day");
        ds.WriteXml("chores2.xml"); 
*/
        string jobName = this.TextBox2.Text;
        OleDbConnection con = new OleDbConnection();
        con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb";
        OleDbDataAdapter da = new OleDbDataAdapter("Select * from "+jobName+"", con);
        DataSet ds = new DataSet("chores");
        while (this.Label5.Text == "1")
        {
            da.Fill(ds, "job");
            DataTable dt = new DataTable("job");
            dt = ds.Tables["job"];
            foreach (DataColumn dc in dt.Columns)
            {
                dc.ColumnMapping = MappingType.Attribute;
            }
        }
        ds.WriteXml("chores2.xml"); 

FileInfo fi1 = new System.IO.FileInfo(@"c:\temp\chores2.xml");

if (!fi1.Exists)
{
    XDoc.Load(@"c:\temp\chores2.xml")
}
else
{
    XmlElement XElemRoot = XDoc.CreateElement("chores");
    XDoc.AppendChild(XElemRoot);
}

XDoc.SelectSingleNode("descendant::day[@title='YourTitle']");

C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin\xsd.exe

public partial class chores {
    
    private choresDay[] itemsField;
    
    public choresDay[] Items {
        get {
            return this.itemsField;
        }
        set {
            this.itemsField = value;
        }
    }
}

public partial class choresDay {
    
    private choresDayJob[] jobField;
    
    private string titleField;
    
    public choresDayJob[] job {
        get {
            return this.jobField;
        }
        set {
            this.jobField = value;
        }
    }
    
    public string title {
        get {
            return this.titleField;
        }
        set {
            this.titleField = value;
        }
    }
}

public partial class choresDayJob {
    
    private string aField;
    
    private string bField;
    
    private string cField;
    
    private string dField;
    
    public string a {
        get {
            return this.aField;
        }
        set {
            this.aField = value;
        }
    }
    
    public string b {
        get {
            return this.bField;
        }
        set {
            this.bField = value;
        }
    }
    
    public string c {
        get {
            return this.cField;
        }
        set {
            this.cField = value;
        }
    }
    
    public string d {
        get {
            return this.dField;
        }
        set {
            this.dField = value;
        }
    }
}

You would use it :


            chores chores = new chores();
            chores.Items  = new choresDay[];
            chores.Items[0] = new choresDay;;
            chores.Items[0].job = new choresDayJob[];
            chores.Items[0].job[0] = new choresDayJob();
            chores.Items[0].job[0].a = this.a;
            chores.Items[0].job[0].b = this.b;

 protected void Button1_Click(object sender, EventArgs e)
    {
       XmlDocument XDoc = new XmlDocument();
        FileInfo fi1 = new System.IO.FileInfo("chores2.xml");
        if (!fi1.Exists)
        {

            XDoc.Load("chores2.xml");
        }

        else
        {
            
           
            XmlNode root = XDoc.DocumentElement;
            XDoc.SelectSingleNode("descendant::day[@title='"+this.dropdwnlst.selectedvalue+"']");

            XmlElement Xjob = XDoc.CreateElement("job");
            Xjob.SetAttribute("a", "" + this.txtBoxProduct.Text + "");
            Xjob.SetAttribute("b", "" + this.txtBoxSize.Text + "");
            Xjob.SetAttribute("c", "" + this.txtBoxPrice.Text + "");
            Xjob.SetAttribute("d", "" + this.txtBoxAmount.Text + "")
            XDoc.Save("chores2.xml");
        }
}

XDoc.SelectSingleNode("descendant::day[@title='"+this.dropdwnlst.selectedvalue+"']");

Xjob.SetAttribute("a", "" + this.txtBoxProduct.Text + "");
          Xjob.SetAttribute("b", "" + this.txtBoxSize.Text + "");
          Xjob.SetAttribute("c", "" + this.txtBoxPrice.Text + "");
          Xjob.SetAttribute("d", "" + this.txtBoxAmount.Text + "")

public partial class choreForm : Form
{
    XmlDocument xDoc = new XmlDocument();

    public choreForm()
    {
        InitializeComponent();
    }

    private void choreForm_Load(object sender, EventArgs e)
    {
        FileInfo fi1 = new FileInfo(GetFileName());

        if (fi1.Exists)
        {
            xDoc.Load(GetFileName());
        }
        else
        {
            xDoc.AppendChild(xDoc.CreateElement("chores"));
        }
    }

    private void button1_Click(object sender, EventArgs e)
    {
        XmlElement xDay = xDoc.SelectSingleNode("descendant::day[@title='" + this.dropdwnlst.selectedvalue + "']") as XmlElement;

        if (xDay == null)
        {
            xDay = xDoc.CreateElement("day");
            xDay.SetAttribute("title", this.dropdwnlst.selectedvalue);
            xDoc.FirstChild.AppendChild(xDay);
        }

        XmlElement xJob = xDoc.CreateElement("job");
        xJob.SetAttribute("a", this.txtBoxProduct.Text);
        xJob.SetAttribute("b", this.txtBoxSize.Text);
        xJob.SetAttribute("c", this.txtBoxPrice.Text);
        xJob.SetAttribute("d", this.txtBoxAmount.Text);
        xDay.AppendChild(xJob);

    }

    private void choreForm_FormClosing(object sender, FormClosingEventArgs e)
    {
        xDoc.Save(GetFileName());
    }

    private string GetFileName()
    {
        return @"c:\temp\chores2.xml";
    }
}