XML / XSL

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

<?xml version="1.0" encoding="utf-8" ?>
<root>
  <img src="Myjpeg1.jpg" />

  <img src="Myjpeg2.jpg" />
</root>

<ItemTemplate>

        <img src='<%# DataBinder.Eval(Container.DataItem, "src") %>'/>
        </ItemTemplate>    

<computer type="you need to put something here... - desktop?">
	<itemID>654132</itemID>
	<itemName>PACKARD BELL</itemName>
	<desc>ALL IN ONE TOUCH SCREEN</desc>
	<OS>VISTA</OS>
	<cpu>AMD</cpu>
	<speed>2.6</speed>
	<memory>1GB</memory>
	<hdd>250GB</hdd>
	<wirelessEnabled>NO</wirelessEnabled>
	<quantity>3</quantity>
	<price>435.62</price>
</computer>

<computer type="desktop">
							<itemID>654132</itemID>
							<itemName>PACKARD BELL</itemName>
							<desc>ALL IN ONE TOUCH SCREEN</desc>
							<OS>VISTA</OS>
							<cpu>AMD</cpu>
							<speed>2.6</speed>
							<memory>1GB</memory>
							<hdd>250GB</hdd>
							<wirelessEnabled>NO</wirelessEnabled>
							<quantity>3</quantity>
							<price>435.62</price>
					</computer>