XML / XSL

13-Apr-10 5:26

Hello Coders,

Im facing a problem building a C#.net code that will build me the following XML page:

<?xml version="1.0"?>
<chores>
<day title="some title">
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
</day>

//updating a new DAY tag

<day title="some title">
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
</day>
//and again.. etc..

<day title="some title">
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
 <job a=".." b="text.." c="..text.." d="d..."/>
</day>

</chores>

I've tried hundreds of codes, nothing worked the way i need it. i will appreciate any help PLEASE.

What im trying to do is the following:

I have a page that has 4 textboxes, each one is supposed to save some value .. lets say a,b,c,d..

Another textbox is for the day attribute which is TITLE according to my example

I need to add whenever i need a DAY. with it's attribute. and "jobs" like that example.

whenever i need to make a new "DAY" i need it do be after the last one. i mean i need it to update the new <DAY> after the last one's

and all of that i need it to come before the each time i update the xml file</chores>

Please i'd really appreciate any help with this. im new to XML and im trying to make an XML management page for some project.If what i've said wasnt clear im ready to explain again. Please tell me what to do and how to do it, or if you have any samples for handling such an issue it will be great too

Estys14-Apr-10 1:01

14-Apr-10 1:01

Can you show us a little of what you tried?

What you are trying to do is maintaining a kind of database.
On the assumption that you really want it as xml-file :
option 1 : Read your file as XmlDocument and add nodes as you add entries.
option 2 : Create a dedicated class model with serializing/deserializing.

Both methods have as disadvantage that everything get loaded in memory. To prevent that you might have to split your model in multiple files.

Google for XmlDocument and/or XSD utility.
If you need further clarification, just ask.

Farraj14-Apr-10 1:20

14-Apr-10 1:20

i've tried this code for example

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

and ive tried it by making a dataset of the elements

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

and i've tried it by getting the values from an access database and save them as an XML file
also that didnt help approaching my goal

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

and i tried the XMLDocument, also didnt work exactly how i want it

i would be more than happy if you can explain me what do you mean by
:
option 2 : Create a dedicated class model with serializing/deserializing

Estys14-Apr-10 2:22

14-Apr-10 2:22

Your approach with XmlDocument in itself works, I tried your code.
What you need to to there is first checking if the file exists and if so xDoc.Load(<file>);.

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

To add a job to a particular day you need to find the node with the right title :

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

You can now add your jobs to it.

About option 2, MS has a utility called XSD. On my PC it's in :

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

With your xml you can generate an xsd, and with the xsd you can generate a .cs file.
It has all the classes and attributes you need. You can and should edit it to suit your needs.
The only thing left to do is write a serializer and a deserializer.
The code would look something like this (I removed all attributes)

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;

Good luck!

Farraj14-Apr-10 6:07

14-Apr-10 6:07

Hi Estys,
First of all thank you a lot for your help and time, i really appreciate that.
Second, i think im gonna take option #1 Smile | :)

lol.
Anyway, this is the code i've made for now, im not sure about it but i'd really appreciate more help.

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

this is what im thinking about, i have 4 text boxes for the job attributes. with another DropDownList that through it i can choose what kind of a "DAY" according to the title i want to play with and add "jobs".

So, this cute line

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

is really great, but how i can control my selected node and enter the correct attributes

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

to it?

Thanks again for your help.

Estys14-Apr-10 22:52

14-Apr-10 22:52

Your form code should look like this :

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

gimme 5 if you like this!

Farraj15-Apr-10 0:46

15-Apr-10 0:46

I LOVE IT!! this code is perfect!!!

i've been blessed by a genius coder
THANK U ALOT for ur time and help!! PERFECT Smile | :)

)))))))))))))))))))))

Farraj16-Apr-10 4:26

16-Apr-10 4:26

Hi again

thanks for your help with adding the XML data
i need to ask you another question
i've got my final xml file looking exactly as i need it to be

<?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>

im trying to Edit this file in a dataGrid but its not working

my aspx page

<%@ 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>

and this is my CS code

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

it keeps telling me whenever i load the page
DataBinding: 'System.Data.DataRowView' does not contain a property with the name a..

anyway the problem is here..
dataSet.Tables[0].Rows[row]["a"] = txtBoxProduct.Text;

i guess this line is not working for the xml attributes
int row = Convert.ToInt32(e.Item.ItemIndex);

how can i fix that to work with my xml?

Estys16-Apr-10 6:04

16-Apr-10 6:04

Actually, your DataSet contains two Tables : day and job, I guess that's where the problems start.
I'm not very familiar with databinding, I would ask in another forum (as this whole question probably should have been Smile | :)

).

The problem is not the attributes, the "title" and "label" attributes are acceptable to the binder. Also the other attributes ARE present as columns in table "job".

So, post this question in the ASP or Web Development corner of CP.

Cheers

Farraj24-Apr-10 9:46