<\/div>\n
Bu yaz\u0131mda, sorgulama sonucu d\u00f6nen tabloyu XML formatt\u0131nda almay\u0131 g\u00f6rece\u011fiz.
\n
\nVeritaban\u0131 olarak Northwind kullanal\u0131m.
\n\u00d6rnek olarak \u00dcr\u00fcnler tablosunu XML formatta elde edelim.<\/p>\n
\r\n            SqlConnection baglanti = new SqlConnection("Server=GEN\u00c7AY-GEN\u00c7AY;Database=Northwind;Trusted_Connection=True;");\r\n            SqlDataAdapter dap = new SqlDataAdapter("Select * from Urunler",baglanti);\r\n            DataSet ds = new DataSet();\r\n            dap.Fill(ds);\r\n            FileStream fs = new FileStream("Urunler.xml", FileMode.OpenOrCreate, FileAccess.Write);\r\n            ds.WriteXml(fs);\r\n            fs.Close();\r\n            MessageBox.Show("\u0130\u015flem Tamam");\r\n<\/pre>\nYukardaki kodlar\u0131 derleyip \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131z zaman, mesaj kutusunda “\u0130\u015flem Tamam” yaz\u0131s\u0131yla kar\u015f\u0131la\u015f\u0131r\u0131z.”Urunler.xml” in olu\u015fturulaca\u011f\u0131 yolu belirmedik.O halde nereye olu\u015fturuldu diye sorarsan\u0131z e\u011fer,projenizin solution dosyas\u0131n\u0131n oldu\u011fu dizine gelip,”\\bin\\Debug” klas\u00f6rlerini takip ederseniz “Debug” isimli klas\u00f6r\u00fcn alt\u0131nda “Urunler.xml” oldu\u011funu g\u00f6r\u00fcrs\u00fcn\u00fcz.<\/p>\n
Genellikle yol verilmezse dosyalar bu klas\u00f6re eklenir.<\/p>\n
\u015eimdide Urunler.xml dosyam\u0131z\u0131 a\u00e7\u0131p bakal\u0131m.<\/p>\n
\r\n<NewDataSet>\r\n  <Table>\r\n    <UrunID>1<\/UrunID>\r\n    <UrunAdi>Chai<\/UrunAdi>\r\n    <TedarikciID>1<\/TedarikciID>\r\n    <KategoriID>1<\/KategoriID>\r\n    <BirimdekiMiktar>10 boxes x 20 bags<\/BirimdekiMiktar>\r\n    <BirimFiyati>19.8000<\/BirimFiyati>\r\n    <HedefStokDuzeyi>39<\/HedefStokDuzeyi>\r\n    <YeniSatis>0<\/YeniSatis>\r\n    <EnAzYenidenSatisMikatari>10<\/EnAzYenidenSatisMikatari>\r\n    <Sonlandi>false<\/Sonlandi>\r\n  <\/Table>\r\n  <Table>\r\n    <UrunID>2<\/UrunID>\r\n    <UrunAdi>Chang<\/UrunAdi>\r\n    <TedarikciID>1<\/TedarikciID>\r\n    <KategoriID>1<\/KategoriID>\r\n    <BirimdekiMiktar>24 - 12 oz bottles<\/BirimdekiMiktar>\r\n    <BirimFiyati>20.9000<\/BirimFiyati>\r\n    <HedefStokDuzeyi>17<\/HedefStokDuzeyi>\r\n    <YeniSatis>40<\/YeniSatis>\r\n    <EnAzYenidenSatisMikatari>25<\/EnAzYenidenSatisMikatari>\r\n    <Sonlandi>false<\/Sonlandi>\r\n  <\/Table>\r\n  <Table>\r\n    <UrunID>3<\/UrunID>\r\n    <UrunAdi>Aniseed Syrup<\/UrunAdi>\r\n.\r\n.\r\n.\r\n  <\/Table>\r\n<\/NewDataSet>\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz \u00fczere root elemana “NewDataSet” ad\u0131n\u0131 vermi\u015f.\u00dcr\u00fcnler tablosundan ald\u0131\u011f\u0131 b\u00fct\u00fcn sat\u0131rlarada “Table” ismini vermi\u015f.
\n\u0130\u015fte sorgu sonucu gelen sonu\u00e7 tablosunu bu \u015fekilde XML format\u0131nda elde edebiliyoruz.
\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere..
\n\u0130yi \u00e7al\u0131\u015fmalar \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131mda, sorgulama sonucu d\u00f6nen tabloyu XML formatt\u0131nda almay\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":[752],"class_list":["post-682","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","category-xml","tag-xml"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/682","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=682"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/682\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}