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";
    }
}

<?xml version="1.0" encoding="utf-8"?>
<chores>
  <day label="111" title="asdasd">
    <job a="2" b="22" c="22" d="22" />
    <job a="2" b="22" c="22" d="22" />
  </day>
</chores>

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="EditTables.aspx.cs" Inherits="EditTables" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table class="style1">
        <tr>
            <td>
                <br />
                <br />
                Edit your Products tables<br />
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True" 
                    AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None" 
                    oncancelcommand="DataGrid1_CancelCommand" 
                    ondeletecommand="DataGrid1_DeleteCommand" oneditcommand="DataGrid1_EditCommand" 
                    onpageindexchanged="DataGrid1_PageIndexChanged" 
                    onupdatecommand="DataGrid1_UpdateCommand" AutoGenerateColumns="False" 
                    Width="890px">
                    <AlternatingItemStyle BackColor="White" ForeColor="#284775" />
                    <Columns>
                     <asp:TemplateColumn HeaderText=" label">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "label")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxTitle"
                   Text='<%# DataBinder.Eval(Container.DataItem, "label") %>'
                   runat="server" Height="21px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
          
           <asp:TemplateColumn HeaderText="title">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "title")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxTitle"
                   Text='<%# DataBinder.Eval(Container.DataItem, "title") %>'
                   runat="server" Height="21px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
      <asp:TemplateColumn HeaderText="כמות">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "a")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxAmount"
                   Text='<%# DataBinder.Eval(Container.DataItem, "a") %>'
                   runat="server" Height="21px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
           <asp:TemplateColumn HeaderText="מחירון">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "b")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxPrice"
                   Text='<%# DataBinder.Eval(Container.DataItem, "b") %>'
                   runat="server" Height="21px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
          
           <asp:TemplateColumn HeaderText="גודל">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "c")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxSize"
                   Text='<%# DataBinder.Eval(Container.DataItem, "c") %>'
                   runat="server" Height="22px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
          
           <asp:TemplateColumn HeaderText="מוצר">
            <ItemTemplate>
              <%# DataBinder.Eval(Container.DataItem, "d")%>
            </ItemTemplate>
            <EditItemTemplate>
              <asp:TextBox id="txtBoxProduct"
                   Text='<%# DataBinder.Eval(Container.DataItem, "d") %>'
                   runat="server" Height="22px" Width="80px"/>
            </EditItemTemplate>
          </asp:TemplateColumn>
          
          
                        <asp:EditCommandColumn CancelText="Cancel" EditText="Edit" UpdateText="Update">
                        </asp:EditCommandColumn>
                        <asp:ButtonColumn CommandName="Delete" Text="Delete"></asp:ButtonColumn>
                    </Columns>
                    <EditItemStyle BackColor="#999999" />
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <ItemStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <SelectedItemStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                </asp:DataGrid>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="lblerror" runat="server" ForeColor="Maroon"></asp:Label>
            </td>
        </tr>
    </table>
</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Globalization;
using System.IO;
using System.Data;
using System.Data.OleDb;

public partial class EditTables : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!User.IsInRole("Admin"))
     
           Server.Transfer("login.aspx");
        if (!(Page.IsPostBack))
        {
            DataGrid1.DataSource = LoadMyData();
            DataGrid1.DataBind();
        }

    }
    protected DataSet LoadMyData()
    {
        string sourceXml = Server.MapPath("~/xml/chores2.xml");
        if (!(File.Exists(sourceXml)))
        {
            return null;
        }
        DataSet cachedDataSet = (DataSet)Session["table"];
        if (!(cachedDataSet == null))
        {
            return cachedDataSet;
        }
        DataSet dataSet = new DataSet();
        try
        {
            dataSet.ReadXml(sourceXml);
            Session["table"] = dataSet;
        }
        catch (Exception e)
        {
            lblerror.Text = e.Message;
            dataSet = null;
        }
        return dataSet;
    }
    protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
    {

        DataGrid1.EditItemIndex = Convert.ToInt32(e.Item.ItemIndex);
        DataGrid1.DataSource = LoadMyData();

        DataGrid1.DataBind();
    }
    protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = -1;
        DataGrid1.DataSource = LoadMyData();
        DataGrid1.DataBind();
    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        DataSet dataSet = LoadMyData();
        int row = Convert.ToInt32(e.Item.ItemIndex);
        dataSet.Tables[0].Rows[row].Delete();
        dataSet.WriteXml(Server.MapPath("~/XML/chores2.xml"));
        Session["table"] = null;
        DataGrid1.EditItemIndex = -1;
        DataGrid1.DataSource = LoadMyData();
        DataGrid1.DataBind();
    }
    protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
    {
        DataSet dataSet = LoadMyData();
        int row = Convert.ToInt32(e.Item.ItemIndex);

        TextBox txtBoxLabel = (TextBox)e.Item.FindControl("txtBoxLabel");
        dataSet.Tables[0].Rows[row]["label"] = txtBoxLabel.Text;

        TextBox txtBoxTitle = (TextBox)e.Item.FindControl("txtBoxTitle");
        dataSet.Tables[0].Rows[row]["title"] = txtBoxTitle.Text;

        TextBox txtBoxProduct = (TextBox)e.Item.FindControl("txtBoxProduct");
        dataSet.Tables[0].Rows[row]["a"] = txtBoxProduct.Text;

        TextBox txtBoxSize = (TextBox)e.Item.FindControl("txtBoxSize");
        dataSet.Tables[0].Rows[row]["b"] = txtBoxSize.Text;

        TextBox txtBoxPrice = (TextBox)e.Item.FindControl("txtBoxPrice");
        dataSet.Tables[0].Rows[row]["c"] = txtBoxPrice.Text;


        TextBox txtBoxAmount = (TextBox)e.Item.FindControl("txtBoxAmount");
        dataSet.Tables[0].Rows[row]["d"] = txtBoxAmount.Text;



    

        dataSet.WriteXml(Server.MapPath("~/XML/chores2.xml"));
        Session["table"] = null;
        DataGrid1.EditItemIndex = -1;
        DataGrid1.DataSource = LoadMyData();
        DataGrid1.DataBind();
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
        DataGrid1.DataSource = LoadMyData();
        DataGrid1.DataBind();
    }
}