{"id":154,"date":"2009-02-11T03:15:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=154"},"modified":"2009-02-11T03:15:00","modified_gmt":"1970-01-01T00:00:00","slug":"xml-web-servisleri-i-web-servisleri-ile-dataset-dondurmek","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2009\/02\/11\/xml-web-servisleri-i-web-servisleri-ile-dataset-dondurmek\/","title":{"rendered":"XML Web Servisleri I – Web Servisleri ile DataSet D\u00f6nd\u00fcrmek"},"content":{"rendered":"

Web servislerle ilgili internete birçok doküman bulabilirsiniz. Web servis sudur, su ise yarar, söyle çalisir gibi bilgiler vermeden direk olarak bir web servis nasil olusturuluru konusacagiz.  <\/span>Aldigi parametreye göre veritabanindan sorgu yaparak sonucu geri döndüren basit bir web servis metodu olusturacagiz. Hadi baslayalim.<\/span><\/p>\n

Projeyi Buradan <\/a>Indirebilirsiniz.<\/span><\/p>\n

Visual Studio 2008 de New Project -> Visual C# -> Web menusu altindan ASP.NET Web Service Application seçenegini seçerek devam edelim.<\/span><\/p>\n

 .<\/a><\/p>\n

\"\"                <\/span>Yukaridaki ekranda Ok butonuna bastiginiz zaman web servisiniz otomatik olarak olusturulacak. Visual Studio web servisimizin çalismasi için gerekli asagidaki kodlari olusturacak.<\/span><\/span><\/p>\n

namespace<\/span> WebServiceBaslangic<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>\/\/\/<\/span> <\/span><summary><\/span><\/span><\/p>\n

    <\/span>\/\/\/<\/span> Summary description for Service1<\/span><\/span><\/p>\n

    <\/span>\/\/\/<\/span> <\/span><\/summary><\/span><\/span><\/p>\n

    <\/span>[WebService<\/span>(Namespace = "http:\/\/tempuri.org\/"<\/span>)]<\/span><\/p>\n

    <\/span>[WebServiceBinding<\/span>(ConformsTo = WsiProfiles<\/span>.BasicProfile1_1)]<\/span><\/p>\n

    <\/span>[ToolboxItem<\/span>(false<\/span>)]<\/span><\/p>\n

    <\/span>\/\/ To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. <\/span><\/span><\/p>\n

    <\/span>\/\/ [System.Web.Script.Services.ScriptService]<\/span><\/span><\/p>\n

    <\/span>public<\/span> class<\/span> Service1<\/span> : System.Web.Services.WebService<\/span><\/span><\/p>\n

    <\/span>{<\/span><\/p>\n

 <\/span><\/p>\n

        <\/span>[WebMethod<\/span>]<\/span><\/p>\n

        <\/span>public<\/span> string<\/span> HelloWorld()<\/span><\/p>\n

        <\/span>{<\/span><\/p>\n

            <\/span>return<\/span> "Hello World"<\/span>;<\/span><\/p>\n

        <\/span>}<\/span><\/p>\n

    <\/span>}<\/span><\/p>\n

}<\/span><\/p>\n

Kod içinde<\/span> [WebService<\/span>(Namespace = "http:\/\/tempuri.org\/"<\/span>)] <\/span>kismini <\/span>[WebService<\/span>(Namespace = "http:\/\/yazilimmutfagi.com\/"<\/span>)] <\/span>olarak degistirelim.  <\/span>Yukaridaki kodu inceleyecek olursak HelloWorld adinda bir metot olusturulmus ve çagirildigi durumda “Hello World” string degerini döndürmekle görevli. Burada dikkat edilmesi gereken <\/span>[WebMethod<\/span>]<\/span> kismi. Eger web servisinize yazdiginiz fonksiyona disaridan erisilmesini istiyorsaniz <\/span>[WebMethod<\/span>]<\/span> etiketini metot isminin hemen üstüne koymak zorundasiniz.  <\/span><\/span><\/span><\/p>\n

Gelelim kendi web metodumuzu yazmaya. Yazacagimzi metod aldigi parametre ile veritabaninda sorgu çalistirarak veritabanindan dönen verileri metodu çagiran istemciye gönderecek. Bunun için ilk olarak kullanacagimiz veritabani tablomuzu olusturalim. Ben örnegimizde Kisi adinda bir tablo kullanacagim. Tablomuzun scripti asagidaki gibidir.<\/span><\/p>\n

.<\/a>
\n<\/span><\/p>\n

CREATE<\/span> TABLE<\/span> [dbo].<\/span>[Kisi](<\/span><\/span><\/p>\n

      <\/span>[No] [int] IDENTITY<\/span>(<\/span>1,<\/span>1)<\/span> NOT<\/span> NULL,<\/span><\/span><\/p>\n

      <\/span>[Ad] [varchar](<\/span>50)<\/span> NULL,<\/span><\/span><\/p>\n

      <\/span>[Soyad] [varchar](<\/span>50)<\/span> NULL,<\/span><\/span><\/p>\n

      <\/span>[TCKimlikNo] [char](<\/span>11)<\/span> NULL,<\/span><\/span><\/p>\n

      <\/span>[Numara] [int] NULL,<\/span><\/span><\/p>\n

      <\/span>[Cinsiyet] [char](<\/span>1)<\/span> NULL,<\/span><\/span><\/p>\n

      <\/span>[DogumYeri] [varchar](<\/span>50)<\/span> NULL,<\/span><\/span><\/p>\n

)<\/span><\/p>\n

                <\/span>Olusturdugunuz tabloya kendi istediginiz verileri girin. Daha sonra web servisimizi kod kismini açarak asagidaki kodlari ekleyin.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

[WebMethod<\/span>]<\/span><\/p>\n

public<\/span> DataSet<\/span> KisiDondur(string<\/span> ad)<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>string<\/span> query = String<\/span>.Format("SELECT * FROM Kisi WHERE Ad = ‘{0}’"<\/span>,ad);<\/span><\/p>\n

    <\/span>return<\/span> SorguCalistir(query);<\/span><\/p>\n

}<\/span><\/p>\n

 <\/span><\/p>\n

[WebMethod<\/span>]<\/span><\/p>\n

public<\/span> DataSet<\/span> KisiDondurTCKimlikNoIle(string<\/span> tcKimlikNo)<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>string<\/span> query = String<\/span>.Format("SELECT * FROM Kisi WHERE TCKimlikNo = ‘{0}’"<\/span>, tcKimlikNo);<\/span><\/p>\n

    <\/span>return<\/span> SorguCalistir(query);<\/span><\/p>\n

}<\/span><\/p>\n

 <\/span><\/p>\n

public<\/span> DataSet<\/span> SorguCalistir(string<\/span> query)<\/span><\/p>\n

{<\/span><\/p>\n

    <\/span>SqlConnection<\/span> con = new<\/span> SqlConnection<\/span>("Data Source=.;Initial Catalog=Ornek;Integrated Security=True"<\/span>);<\/span><\/p>\n

    <\/span>con.Open();<\/span><\/p>\n

    <\/span>SqlDataAdapter<\/span> da = new<\/span> SqlDataAdapter<\/span>(query, con);<\/span><\/p>\n

    <\/span>da.SelectCommand.ExecuteNonQuery();<\/span><\/p>\n

    <\/span>DataSet<\/span> dt = new<\/span> DataSet<\/span>();<\/span><\/p>\n

    <\/span>da.Fill(dt);<\/span><\/p>\n

    <\/span>return<\/span> dt;<\/span><\/p>\n

}<\/span><\/p>\n

      <\/span><\/span><\/p>\n

      <\/span><\/span><\/p>\n

Yukarida gördügünüz gibi KisiBilgilerini Donduren iki fonksiyon tanimladik ve tanimlamalarinin hemen üstüne <\/span>[WebMethod<\/span>] <\/span>ekledik. Ama SorguCalistir adiyla tanimladigimiz fonksiyona <\/span>[WebMethod<\/span>] <\/span>eklemedik. Çünkü bu fonksiya disardan erisilmesini istemiyoruz. Web Servisimizi çalistirarak sonuçlara bakalim ve makalemizi sonlandiralim.<\/span><\/p>\n

 <\/p>\n

\"\"<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Yukarida görüldügü gibi <\/span>[WebMethod<\/span>]<\/span> <\/span>ekledigimiz tüm fonksiyonlarimiz listelendi. Bunlardan KisiDondur linkini tiklayarak devam edelim.<\/span><\/span> <\/p>\n

\"\"                <\/span><\/span><\/span><\/p>\n

         Ad kismina Metin yazarak Çagir dedigimizde Metin adli bir kisi tablomuzda var ise Metine ait tüm bilgiler <\/span><\/span>asagida görüldügü gibi XML formatinda bize dönecektir. <\/span><\/span><\/p>\n

<<\/span>DataSet<\/span>><\/span><\/p>\n

  <\/span>−<\/span><\/p>\n

  <\/span><<\/span>xs:schema<\/span> <\/span>id<\/span>=<\/span>"NewDataSet<\/span>"><\/span><\/span><\/p>\n

    <\/span>−<\/span><\/p>\n

    <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"NewDataSet<\/span>" <\/span>msdata:IsDataSet<\/span>=<\/span>"true<\/span>" <\/span>msdata:UseCurrentLocale<\/span>=<\/span>"true<\/span>"><\/span><\/span><\/p>\n

      <\/span>−<\/span><\/p>\n

      <\/span><<\/span>xs:complexType<\/span>><\/span><\/p>\n

        <\/span>−<\/span><\/p>\n

        <\/span><<\/span>xs:choice<\/span> <\/span>minOccurs<\/span>=<\/span>"0<\/span>" <\/span>maxOccurs<\/span>=<\/span>"unbounded<\/span>"><\/span><\/span><\/p>\n

          <\/span>−<\/span><\/p>\n

          <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"Table<\/span>"><\/span><\/span><\/p>\n

            <\/span>−<\/span><\/p>\n

            <\/span><<\/span>xs:complexType<\/span>><\/span><\/p>\n

              <\/span>−<\/span><\/p>\n

              <\/span><<\/span>xs:sequence<\/span>><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"No<\/span>" <\/span>type<\/span>=<\/span>"xs:int<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"Ad<\/span>" <\/span>type<\/span>=<\/span>"xs:string<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"Soyad<\/span>" <\/span>type<\/span>=<\/span>"xs:string<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"TCKimlikNo<\/span>" <\/span>type<\/span>=<\/span>"xs:string<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"Numara<\/span>" <\/span>type<\/span>=<\/span>"xs:int<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"Cinsiyet<\/span>" <\/span>type<\/span>=<\/span>"xs:string<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

                <\/span><<\/span>xs:element<\/span> <\/span>name<\/span>=<\/span>"DogumYeri<\/span>" <\/span>type<\/span>=<\/span>"xs:string<\/span>" <\/span>minOccurs<\/span>=<\/span>"0<\/span>"\/><\/span><\/span><\/p>\n

              <\/span><\/<\/span>xs:sequence<\/span>><\/span><\/p>\n

            <\/span><\/<\/span>xs:complexType<\/span>><\/span><\/p>\n

          <\/span><\/<\/span>xs:element<\/span>><\/span><\/p>\n

        <\/span><\/<\/span>xs:choice<\/span>><\/span><\/p>\n

      <\/span><\/<\/span>xs:complexType<\/span>><\/span><\/p>\n

    <\/span><\/<\/span>xs:element<\/span>><\/span><\/p>\n

  <\/span><\/<\/span>xs:schema<\/span>><\/span><\/p>\n

  <\/span>−<\/span><\/p>\n

  <\/span><<\/span>diffgr:diffgram<\/span>><\/span><\/p>\n

    <\/span>−<\/span><\/p>\n

    <\/span><<\/span>NewDataSet<\/span>><\/span><\/p>\n

      <\/span>−<\/span><\/p>\n

      <\/span><<\/span>Table<\/span> <\/span>diffgr:id<\/span>=<\/span>"Table1<\/span>" <\/span>msdata:rowOrder<\/span>=<\/span>"0<\/span>"><\/span><\/span><\/p>\n

        <\/span><<\/span>No<\/span>><\/span>2<\/<\/span>No<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>Ad<\/span>><\/span>Metin<\/<\/span>Ad<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>Soyad<\/span>><\/span>Tosun<\/<\/span>Soyad<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>TCKimlikNo<\/span>><\/span>76543244233<\/<\/span>TCKimlikNo<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>Numara<\/span>><\/span>124<\/<\/span>Numara<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>Cinsiyet<\/span>><\/span>E<\/<\/span>Cinsiyet<\/span>><\/span><\/span><\/p>\n

        <\/span><<\/span>DogumYeri<\/span>><\/span>Ankara<\/<\/span>DogumYeri<\/span>><\/span><\/span><\/p>\n

      <\/span><\/<\/span>Table<\/span>><\/span><\/p>\n

    <\/span><\/<\/span>NewDataSet<\/span>><\/span><\/p>\n

  <\/span><\/<\/span>diffgr:diffgram<\/span>><\/span><\/p>\n

<\/<\/span>DataSet<\/span>><\/span><\/p>\n

Olusturdugumuz bir web servisi baska bir projeden nasil çagiracagimiz hakkinda bilgiyi sonraki makalelerimizde vermeye çalisacagiz. <\/span><\/p>","protected":false},"excerpt":{"rendered":"

Web servislerle ilgili internete birçok doküman bulabilirsiniz. Web servis sudur, su ise yarar, söyle çalisir gibi bilgiler vermeden direk olarak bir web servis nasil olusturuluru konusacagiz. Aldigi parametreye göre veritabanindan sorgu yaparak sonucu geri döndüren basit bir web servis metodu …<\/p>\n","protected":false},"author":517,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[407],"tags":[5175,4229,5094,4431,5743,6091,6049,6243,4488],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/154"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=154"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/154\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}