<\/div>\n
Bu yaz\u0131mda C# kodlar\u0131yla XML dosyas\u0131 olu\u015fturmay\u0131 g\u00f6rece\u011fiz.<\/pre>\n
\nA\u015fa\u011f\u0131daki \u00f6rnekte veritaban\u0131 olarak Northwind kullan\u0131yorum.
\nPersoneller tablosunun XML dosyas\u0131n\u0131 kodlarla olu\u015ftural\u0131m.<\/p>\n
\r\n            SqlConnection baglanti = new SqlConnection("Server=GEN\u00c7AY-GEN\u00c7AY;Database=Northwind;Trusted_Connection=True;");\r\n            SqlCommand cmd = new SqlCommand("Select * from Personeller",baglanti);\r\n            baglanti.Open();\r\n            SqlDataReader dr = cmd.ExecuteReader();\r\n            XmlTextWriter XMLDosyasi = new XmlTextWriter("Personeller.xml",Encoding.GetEncoding(1254));\r\n            \/\/XmlTextWriter nesnesi ile "Personeller.xml" ad\u0131ndaki XML dosyas\u0131n\u0131n nereye olusturulaca\u011f\u0131n\u0131 belirledik.\r\n            \/\/Encoding.GetEncoding(1254) = T\u00fcrk\u00e7e karakter dil koduna g\u00f6re XML dosyas\u0131n\u0131 encode etmesini s\u00f6yledik.\r\n            XMLDosyasi.Formatting = Formatting.Indented;\r\n            \/\/Formatting \u00f6zelli\u011fi, XML nodelar\u0131n\u0131n girintili yaz\u0131laca\u011f\u0131n\u0131 belirtir.\r\n            XMLDosyasi.WriteStartDocument();\r\n            \/\/XML dosyas\u0131na yaz\u0131lmas\u0131na ba\u015flayaca\u011f\u0131n\u0131 bildirdik.\r\n            XMLDosyasi.WriteComment("Burada personellerimiz listelenmektedir.");\r\n            \/\/Bu metod ile XML dosyam\u0131za yorum(Comment) eklenmesi sa\u011flan\u0131r.\r\n            \/\/Bundan sonra elemanlar\u0131 yazd\u0131rmaya ba\u015flayal\u0131m...\r\n            XMLDosyasi.WriteStartElement("Personeller");\r\n            \/\/Bu metod ile XML dosyas\u0131n\u0131n root eleman\u0131 belirleniyor.\r\n            while (dr.Read())\r\n            {\r\n                XMLDosyasi.WriteStartElement("Personel");\r\n                \/\/WriteStartElement() metodu ile yaz\u0131lan ilk eleman root eleman olur.Daha sonrakiler root un i\u00e7indeki ana nodelar olur.\r\n                XMLDosyasi.WriteAttributeString("No", dr["PersonelID"].ToString());\r\n                \/\/WriteAttributeString() metodu ile herhangi bir node a Attribute yaz\u0131labilir.\r\n                for (int i = 0; i < dr.FieldCount; i++)\r\n                {\r\n                    XMLDosyasi.WriteElementString(dr.GetName(i), dr[i].ToString());\r\n                    \/\/Node lar\u0131 getirtiyoruz.\r\n                }\r\n                XMLDosyasi.WriteEndElement();\r\n                \/\/Olu\u015fturulan ana node kapat\u0131l\u0131yor.\r\n            }\r\n            XMLDosyasi.WriteEndElement();\r\n            \/\/Root eleman kapat\u0131l\u0131yor.\r\n            XMLDosyasi.WriteEndDocument();\r\n            \/\/XML sayfas\u0131n\u0131n yazma i\u015flevi bitti.\r\n            XMLDosyasi.Close();\r\n            baglanti.Close();\r\n            MessageBox.Show("\u0130\u015flem Tamamland\u0131.");\r\n<\/pre>\nSonu\u00e7 olarak,
\n<\/a>\u0130yi \u00e7al\u0131\u015fmalar \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131mda C# kodlar\u0131yla XML dosyas\u0131 olu\u015fturmay\u0131 g\u00f6rece\u011fiz.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,234],"tags":[236,238,240,242,241,237,239,752,235],"class_list":["post-759","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","category-xml","tag-formatting","tag-writecomment","tag-writeelementstring","tag-writeenddocument","tag-writeendelement","tag-writestartdocument","tag-writestartelement","tag-xml","tag-xmltextwriter"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=759"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/759\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}