C#

cmmd.CommandType = CommandType.StoredProcedure

public SqlCommand InsertData()
       {
           cmd = new SqlCommand("sp_AddDatas", con);
           cmd.CommandType = CommandType.StoredProcedure;
           return cmd;
       }

ALTER  procedure [dbo].[sp_AddDatas] 
(
@firmanin_adi nvarchar(70),
@yetkili1 nvarchar(30),
@gsm_num1 nvarchar(20),
@e_mail1 nvarchar(30),
@yetkili2 nvarchar(30),
@gsm_num2 nvarchar(20),
@e_mail2 nvarchar(30),
@yetkili3 nvarchar(30),
@gsm_num3 nvarchar(20),
@e_mail3 nvarchar(30),
@tlfn1 nvarchar(20),
@tlfn2 nvarchar(20),
@tlfn3 nvarchar(20),
@tlfn4 nvarchar(20),
@tlfn5 nvarchar(20)
)
as 
  BEGIN
   Insert Into Firmalar(firma_adi,yetkili_ad1,Gsm1,email1,yetkili_ad2,Gsm2,Email2,yetkili_ad3,Gsm3,Email3,Telefon1,Telefon2,Telefon3,Telefon4,Telefon5)Values (@firmanin_adi, @yetkili1,@gsm_num1,@e_mail1,@yetkili2,@gsm_num2,@e_mail2, @yetkili3,@gsm_num3,@e_mail3,@tlfn1,@tlfn2,@tlfn3,@tlfn4,@tlfn5)
 END 

foreach (XmlNode PersonTag in PersonNode.ChildNodes)
{
    sOut = PersonTag.Name + "\t" + PersonTag.FirstChild.Value;
    txtBox.Text = sOut;
}

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

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

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

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

squerley wrote:

Now i got to print the last two lines haha

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

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

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

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