C#

erdinc27 wrote:

fir = new Firmalar();

erdinc27 wrote:

cmmd.Parameters.AddWithValue("@yetkili1", System.Data.SqlDbType.NVarChar).Value = fir.yetkili1;

cmmd.Parameters.AddWithValue("@yetkili1",fir.yetkili1);

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