Re: Reading Xml to and fro - C# Discussion Boards

squerley13-Dec-10 5:48

13-Dec-10 5:48

Hey _Erik_

thanks for you help on my last post =^)

Yeah this was just to test so i could see the xml, because i was having kinda the same problem with my list view so i just wanted to test it with something simple haha im a newbee cant you tell haha

I dont see it Sniff | :^)

sOut = PersonTag.Name + "\t" + PersonTag.FirstChild.Value + "\r\n";
                             Or this
sOut = PersonNode.Name + "\t" + PersonTag.FirstChild.Value + "\r\n";

_Erik_13-Dec-10 6:03

_Erik_

13-Dec-10 6:03

I'm afraid none of them. Put a ListBox on your Form instead of a TextBox. This is basically a tree, so you will need a recursive method. This is a very basic sample:

void ShowAll(XmlNodeList nodes)
{
    foreach (XmlNode node in nodes)
    {
        listBox.Add(string.Format("{0}\t{1}", node.Name, node.Value));

        if (node.HasChildNodes)
            ShowAll(node.ChildNodes);
    }
}

Research something about recursion in the Internet if you cannot understand it.

RaviRanjanKr13-Dec-10 5:42

13-Dec-10 5:42

Yes Erik pointed you what mistake you have done whatever, take a snap of this code. it include a little bit modification and display all lines of XML file

string sOut ="";
            XmlDocument myDoc = new XmlDocument();
            try
            {
                myDoc.Load(@"F:\Images.xml");
            }
            catch (Exception xmle)
            {
                MessageBox.Show(xmle.Message, "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                return;
            }
           // txtBox.Text = "";
            XmlNodeList nodeList = myDoc.DocumentElement.ChildNodes;
            foreach (XmlNode PersonNode in nodeList)
            {
                foreach (XmlNode PersonTag in PersonNode.ChildNodes)
                {
                    sOut += PersonTag.Name + "\t" + PersonTag.FirstChild.Value +"\r\n";

                    txtBox.Text = sOut;
                }
             
            }

ShilpaKumari13-Dec-10 5:57

ShilpaKumari

13-Dec-10 5:57

Simple and smart answer

RaviRanjanKr13-Dec-10 6:08

13-Dec-10 6:08

squerley13-Dec-10 5:58

13-Dec-10 5:58

Haha
Now i got to print the last two lines haha

string sOut = "";
           XmlDocument myDoc = new XmlDocument();
           try
           {
               myDoc.Load("people.xml");
           }
           catch (Exception xmle)
           {
               MessageBox.Show(xmle.Message, "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
               return;
           }
           txtBox.Text = "";
           XmlNodeList nodeList = myDoc.DocumentElement.ChildNodes;
           foreach (XmlNode PersonNode in nodeList)
           {
               foreach (XmlNode PersonTag in PersonNode.ChildNodes)
               {
                   sOut += PersonTag.Name + "\t" + PersonTag.FirstChild.Value + "\r\n";
                   txtBox.Text = sOut;
               }
           }

RaviRanjanKr13-Dec-10 6:05

13-Dec-10 6:05

squerley wrote:
Now i got to print the last two lines haha

there something wrong.
It display all lines I have checked it and then posted.
Smile | :)

squerley13-Dec-10 6:25

13-Dec-10 6:25

haha craziness
I did it on my other lab and it works fine haha

Anyhow when i run my listview lab im getting this NullReferanceException in my ReadInPeople method

public int ReadInPeople()
{
    XmlNodeList nodeList = m_xmlDoc.DocumentElement.ChildNodes; //this line has the exception "NullReferanceException was unhandled"
    foreach (XmlNode PersonNode in nodeList)
    {
        Person addPerson = new Person();
        foreach(XmlNode PersonTag in PersonNode.ChildNodes)
        {
            switch (PersonTag.Name)
            {
                case "firstName":
                    addPerson.SetFirstName(PersonTag.FirstChild.Value);
                    break;
                case "lastName":
                    addPerson.SetLastName(PersonTag.FirstChild.Value);
                    break;
                case "address":
                    addPerson.SetAddress(PersonTag.FirstChild.Value);
                    break;
                case "city":
                    addPerson.SetCity(PersonTag.FirstChild.Value);
                    break;
                case "state" :
                    addPerson.SetState(PersonTag.FirstChild.Value);
                    break;
                case "zip":
                    addPerson.SetZip(PersonTag.FirstChild.Value);
                    break;
                default:
                    break;
            }
        }
       this.AddPerson(addPerson); //this is my add person array
    }
    return nodeList.Count;
}

squerley13-Dec-10 6:13

13-Dec-10 6:13

This is my listView form that im trying to get populated by the xml file

private void frmPersonList_Load(object sender, EventArgs e)
{
    try
    {
        m_xmlDoc.Load("m_person.xml");
    }
    catch (Exception xmle)
    {
        MessageBox.Show(xmle.Message, "Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
    }

and i cant see the ReadInPeople method in my main form unless i use public instead of privete and if i use public i get an exception...

    myForm.ReadInPeople();

    lstPersons.View = View.Details;
    lstPersons.Columns.Add("Fist Name", 100, HorizontalAlignment.Center);
    lstPersons.Columns.Add("MI", 30, HorizontalAlignment.Center);
    lstPersons.Columns.Add("Last Name", 80, HorizontalAlignment.Center);
    lstPersons.Columns.Add("Address", 160, HorizontalAlignment.Center);
    lstPersons.Columns.Add("City", 150, HorizontalAlignment.Center);
    lstPersons.Columns.Add("State", 50, HorizontalAlignment.Center);
    lstPersons.Columns.Add("Zip", 50, HorizontalAlignment.Center);
    lstPersons.Columns.Add("Date and Time", 150, HorizontalAlignment.Center);

    Person p;
    for (int i = 0; i < m_PersonReference.Length; i++)
    {
        p = m_PersonReference[i];
        lstPersons.Items.Add(p.FirstName);
        lstPersons.Items[i].SubItems.Add(p.MI);
        lstPersons.Items[i].SubItems.Add(p.LastName);
        lstPersons.Items[i].SubItems.Add(p.Address);
        lstPersons.Items[i].SubItems.Add(p.city);
        lstPersons.Items[i].SubItems.Add(p.state);
        lstPersons.Items[i].SubItems.Add(p.zip);
        lstPersons.Items[i].SubItems.Add(p.time);
    }
}

private void btnCancel_Click(object sender, EventArgs e)
{
   this.Close();
}

private void frmPersonList_FormClosing(object sender, FormClosingEventArgs e)
{
    this.m_xmlDoc.Save("m_person.xml");
}

RaviRanjanKr13-Dec-10 6:19

13-Dec-10 6:19

squerley wrote:
i cant see the ReadInPeople method in my main form unless i use public instead of privete and if i use public i get an exception...

will you mention exception which is occur?

Re: Reading Xml to and fro [modified]

ShilpaKumari13-Dec-10 6:28

ShilpaKumari

13-Dec-10 6:28

What are you trying, please be clear. Fistly your question is you are not getting all lines or something other

squerley13-Dec-10 6:37

CPU jumps from 16% to 78%

13-Dec-10 6:37

Well its kinda hard to explain, I have a windows form that people can fill in there info and click submit and the information gets stored in a local variable. Then if the user wants to see all the people they have entered into the form they click show all and this calls the form2 with the listView and shows them all the data they have entered.
Now we were asked to add in a xml file, so when the main form loads it loads the xml in to the Xml object, then when the user adds more people into the form it will add them to the local variable along with adding it to the already open Xml doc. Then when the user hits show all it shows in info from the xml file along with any new people they entered in.

Hope this makes a little more sense, Sorry for sounding so obtuse Sniff | :^)

Well i finely got it Thumbs Up | :thumbsup:

Thanks to all that helped.
You guys Rock Big Grin | :-D

modified on Monday, December 13, 2010 9:36 PM

Jassim Rahma13-Dec-10 2:47

Jassim Rahma

13-Dec-10 2:47

Hi,

I have this code which works fine but there is a major issue specially i am going t run this on the server! when the code in the timer start running, the CPU usage of the machine jumps from 16% to 78%? of course after completed it will go back to normal but my question. what's happening in the code? why it take this much from CPU?

MySqlConnection sql_connection = null;
MySqlCommand sql_command = null;
MySqlDataAdapter sql_adapter;
DataTable data_table = null;
MySqlDataReader sql_reader = null;
DataSet data_set = null;

public public_class public_var = new public_class();

const int MF_BYPOSITION = 0x400;

[DllImport("User32.dll")]
private static extern int RemoveMenu(IntPtr hMenu, int nPosition, int wFlagS);

[DllImport("User32.dll")]
private static extern IntPtr GetSystemMenu(IntPtr hWnd, bool bRevert);

[DllImport("User32.dll")]
private static extern int GetMenuItemCount(IntPtr hWnd);

public delegate void ControlStringConsumer(Control control, string text);

public int result_rows;

public frmMain()
{
    InitializeComponent();
}

public void SetText(Control control, string text)
{
    control.Invoke(new ControlStringConsumer(SetTextGUI), new object[] { control, text });  // invoking another method
}

public void SetTextGUI(Control control, string text)
{
    control.Text = text;      // the "functional part", acceptable only on the main thread
}

private void perform()
{
    get_statistics_summary();
    send_sms();
}

private void get_statistics_summary()
{
    // progressRunning.Visible = true;

    // try
    // {
        // sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=shefa;integrated security=true");
        sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
        sql_connection.Open();
        sql_command = new MySqlCommand("SELECT COUNT(*) AS total_files FROM persons", sql_connection);
        sql_command.CommandType = CommandType.Text;
        sql_reader = sql_command.ExecuteReader();

        if (sql_reader.Read())
        {
            // lblTotalFiles.Text = sql_reader["total_files"].ToString();
            SetText(lblTotalFiles, sql_reader["total_files"].ToString());
        }

        sql_reader.Close();

        sql_command = new MySqlCommand("SELECT COUNT(*) AS total_appointments FROM appointments", sql_connection);
        sql_command.CommandType = CommandType.Text;
        sql_reader = sql_command.ExecuteReader();

        if (sql_reader.Read())
        {
            // lblTotalAppointments.Text = sql_reader["total_appointments"].ToString();
            SetText(lblTotalAppointments, sql_reader["total_appointments"].ToString());
        }
    /*
    }
    catch (Exception exp)
    {
        MessageBox.Show(exp.Message);
    }
    finally
    {
        if (sql_reader != null) sql_reader.Close();
        if (sql_connection != null)
        {
            if (sql_connection.State == ConnectionState.Open)
                sql_connection.Close();
        }
    }
     * */

    // progressRunning.Visible = false;
}

private void send_sms()
{
    // progressRunning.Visible = true;

    // try
    // {
        sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
        sql_connection.Open();
        sql_command = new MySqlCommand("sp_send_pending_sms", sql_connection);
        sql_command.CommandType = CommandType.StoredProcedure;
        sql_reader = sql_command.ExecuteReader();

        while (sql_reader.Read())
        {
            // lblTimer.Text = sql_reader["sms_queue_id"].ToString();
            SetText(lblTimer, sql_reader["sms_queue_id"].ToString());
        }
    /*
    }
    catch (Exception exp)
    {
        MessageBox.Show(exp.Message);
    }
    finally
    {
        if (sql_reader != null) sql_reader.Close();
        if (sql_connection != null)
        {
            if (sql_connection.State == ConnectionState.Open)
                sql_connection.Close();
        }
    }
     * */

    // progressRunning.Visible = false;
}

private void frmMain_Load(object sender, EventArgs e)
{
    this.Cursor = Cursors.WaitCursor;

    IntPtr hMenu = GetSystemMenu(this.Handle, false);
    int menuItemCount = GetMenuItemCount(hMenu);
    RemoveMenu(hMenu, menuItemCount - 1, MF_BYPOSITION);

    timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);

    // public_var.get_system_properties();
}

private void btnEmailTemplates_Click(object sender, EventArgs e)
{
    frmEmailTemplates EmailTemplatesForm = new frmEmailTemplates(public_var);
    EmailTemplatesForm.ShowDialog();
}

private void frmMain_Shown(object sender, EventArgs e)
{
    this.Cursor = Cursors.WaitCursor;

    timerMain.Start();

    this.Cursor = Cursors.Default;
}


private void timerMain_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
    // lblTimer.Text = DateTime.Now.ToString();
    backgroundWorkerSMS.RunWorkerAsync();

    // send_sms();
}

private void btnOptions_Click(object sender, EventArgs e)
{
    frmOptions OptionsForm = new frmOptions();
    DialogResult options_form = OptionsForm.ShowDialog();

    if (options_form == DialogResult.OK)
    {
        timerMain.Stop();

        timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);

        timerMain.Start();
    }
}

private void backgroundWorkerSMS_DoWork(object sender, DoWorkEventArgs e)
{
    perform();
}

private void backgroundWorkerSMS_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
    backgroundWorkerSMS.Dispose();
}
</pre>

Luc Pattyn13-Dec-10 3:16

Luc Pattyn

13-Dec-10 3:16

is your code and the database running on the same machine?
how many cores are there?
what is inside the stored procedure?
how many different values are you sending to lblTimer per second? (or how long is the SMS table and how long does your code actually run?

if you don't have polling loops, and if you have chosen good algorithms, CPU activity is OK, it just says the processor is working for you.

if the database is elsewhere or the SP is light, then your code is mostly switching threads to update some labels, i.e. your GUI is costing a lot then.

[ADDED]
1. you're not going to have a display with a permanent status update on a server, are you?

2. when update frequency is high, a better approach is to store, not display, the status in some variable(s), and have the GUI update itself (with a Windows.Forms.Timer) a few times a second. When the variable is a 4-byte int or smaller, no need to have synchronization logic (such as locks) at all.
[/ADDED]

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Jassim Rahma13-Dec-10 3:27

Jassim Rahma

13-Dec-10 3:27

s your code and the database running on the same machine?

Yes both on the same machine.

how many cores are there?

Core Due

what is inside the stored procedure?

Just a select statement only

how many different values are you sending to lblTimer per second? (or how long is the SMS table and how long does your code actually run?

The code runs for about 10seconds

Luc Pattyn13-Dec-10 3:34

Luc Pattyn

13-Dec-10 3:34

jrahma wrote:
The code runs for about 10second

and how many SMS (and hence lblTimer updates) is that?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Dave Kreskowiak13-Dec-10 8:54

Dave Kreskowiak

13-Dec-10 8:54

Is the CPU being used by your application or the SQL Server?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

fjdiewornncalwe13-Dec-10 8:32

fjdiewornncalwe

13-Dec-10 8:32

What is your timer interval set to? If it is too small, they tick events may be happening too often depending on the time it takes to perform the actions in each one.

I wasn't, now I am, then I won't be anymore.