{"id":267,"date":"2008-12-21T07:53:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=267"},"modified":"2008-12-21T07:53:00","modified_gmt":"1970-01-01T00:00:00","slug":"dataset-kavrami-iii","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2008\/12\/21\/dataset-kavrami-iii\/","title":{"rendered":"DataSet Kavrami – III"},"content":{"rendered":"

Bu makalemizde DataSet sinifina ait bazi methodlarin  islevlerine ve özelliklerine deyinecegiz. Bizim için yararli olabilecek bir çok method Datasetlerimizin içerisinde yer almaktadir. Bu methodlar programlama anlayisini kolaylastirmakta ve hizlandirmaktadirlar.<\/span><\/p>\n

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

AcceptChange Methodu<\/span><\/strong> <\/span><\/span><\/span><\/p>\n

      <\/span><\/strong>DataSet sinifimizda oldugu gibi hem DataTable hemde DataRow Sinifimizda bu methoda sahiptir. Bu methodun DataTable sinifi ile çagrilmasi bütün DataRowlarda da çagrilmasina sepeb olacaktir. Benzer sekilde DataSet sinifimizdan çagirirsak tüm DataTablelar ve dolayisiyla tüm DataRowlar hiyerasik bir yapiyla etkilenecektir. Bu durumda multiple level akisi gerçeklesmis olur.  Asagida küçük bir örnegimiz bulunmaktadir. Bir önceki makalemizde iller tablosunu SqlDataApater sinifimizi kullanarak  dataSetimize doldurmus ve DataSetimizin içerisinde "Iller" adli bir DataTable olusturmustuk. Elimizde bir adet dataSet ve ona bagli "Iller" dataTable oldugunu varsayarak örnegimizi olusturmaya basiyoruz.<\/span><\/p>\n

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

   <\/span> <\/span><\/span>private<\/span> <\/span>void<\/span> AcceptChangesNedir()  <\/span>{<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Iller tablomuza yeni bir satir ekliyoruz.<\/span><\/p>\n

   <\/span> <\/span><\/span>DataRow<\/span> myRow;<\/span><\/p>\n

    <\/span>myRow = dataSet.Tables[<\/span>"Iller"<\/span>].NewRow();<\/span><\/p>\n

    <\/span>myRow[<\/span>"Pk_Il_ID"<\/span>] = 1;<\/span><\/p>\n

    <\/span>myRow[<\/span>"Il_Ad"<\/span>] = <\/span>"Denizli"<\/span>;<\/span><\/p>\n

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

    <\/span><\/span>\/\/ yeni bir satir ekleniyor.<\/span><\/p>\n

    <\/span>dataSet.Tables[<\/span>"Iller"<\/span>].Rows.Add(myRow);<\/span><\/p>\n

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

    <\/span><\/span>\/\/ AcceptChange methodu dataSet ten çagrildiginda <\/span><\/p>\n

    <\/span><\/span>\/\/ Iller DataTablendaki tüm DataRow lari etkileyecektir. <\/span><\/p>\n

    <\/span>dataSet.AcceptChanges();<\/span><\/p>\n

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

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

       <\/span> <\/span><\/span><\/span><\/span>Yukaridaki örnekte AcceptChanges() Methodu dataSetten tetiklenmis ve tüm table ve ona bagli rowlar etkilenmistir. Tam anlamiyla DataRowlarin RowState durumlari AcceptChanges() ile; satirin eklenmesi ya da degistirilmesi durumunda (added or modified ) degismemis(unchange) durumuna, silinmesi durumunda ise ayrilmis(detached) pozisyonuna geçmesine neden olacaktir.<\/span><\/p>\n

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

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

   <\/span> <\/span><\/span>private<\/span> <\/span>void<\/span> RowStateNedir()<\/span><\/p>\n

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

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

   <\/span> <\/span><\/span>DataTable<\/span> table = dataSet.Tables[<\/span>"Iller"<\/span>];<\/span><\/p>\n

   <\/span> <\/span><\/span>DataRow<\/span> row;<\/span><\/p>\n

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

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

   <\/span> <\/span>row = table.NewRow();<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Detached row. Ayrilmis Satir<\/span><\/p>\n

   <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"New Row "<\/span> + row.RowState);<\/span><\/p>\n

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

   <\/span> <\/span>table.Rows.Add(row);<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Added row. Eklenmis satir<\/span><\/p>\n

   <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"AddRow "<\/span> + row.RowState);<\/span><\/p>\n

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

   <\/span> <\/span>table.AcceptChanges();<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Unchanged row. Degismemis satir<\/span><\/p>\n

   <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"AcceptChanges "<\/span> + row.RowState);<\/span><\/p>\n

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

   <\/span> <\/span>row[<\/span>"Il_Ad"<\/span>] = <\/span>"Konya"<\/span>;<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Modified row. Degistirilmis satir<\/span><\/p>\n

   <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"Modified "<\/span> + row.RowState);<\/span><\/p>\n

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

   <\/span> <\/span>row.Delete();<\/span><\/p>\n

   <\/span> <\/span><\/span>\/\/ Deleted row. Silinmis Satir<\/span><\/p>\n

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

   <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"Deleted "<\/span> + row.RowState);<\/span><\/p>\n

      <\/span> <\/span>table.AcceptChanges();<\/span><\/p>\n

   <\/span> <\/span>\/\/<\/span> Detached row. Ayrilmis Satir<\/span><\/p>\n

 <\/span> <\/span> <\/span> <\/span><\/span>Response<\/span>.Write(<\/span>"AcceptChanges "<\/span> + row.RowState);<\/span><\/p>\n

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

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

Clear Methodu<\/span><\/strong><\/p>\n

      <\/span><\/span><\/strong>Clear Methodu sayesinde kolayca tüm tabellarimizin satirlarini ayni anda temizleyebiliriz.<\/span><\/p>\n

    <\/span>private<\/span> void<\/span> Clear_Nedir(DataSet<\/span> dataSet)<\/span><\/p>\n

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

        <\/span>\/\/ dataSetimize bagli tüm Tablelarda satir sayisini tespit edelim<\/span><\/span><\/p>\n

    <\/span>    <\/span>foreach<\/span> (DataTable<\/span> table in<\/span> dataSet.Tables)<\/span><\/p>\n

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

            <\/span>Response.Write(table.TableName + "Rows.Count = "<\/span><\/span><\/p>\n

                <\/span>+ table.Rows.Count.ToString());<\/span><\/p>\n

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

        <\/span>\/\/ Tüm tablellarin satirlarini temizleyelim<\/span><\/span><\/p>\n

        <\/span>dataSet.Clear();<\/span><\/p>\n

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

        <\/span>\/\/ Tekrar gözlemleyelim<\/span><\/span><\/p>\n

        <\/span>foreach<\/span> (DataTable<\/span> table in<\/span> dataSet.Tables)<\/span><\/p>\n

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

            <\/span>Response.Write(table.TableName + "Satir Sayisi = "<\/span><\/span><\/p>\n

                <\/span>+ table.Rows.Count.ToString());<\/span><\/p>\n

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

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

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

Clone Methodu<\/span><\/strong><\/p>\n

            <\/span><\/span>Clone Methodu ile tabellarimizin yapilarini aralarindaki iliskileri baska bir datasete uyarlayabiliriz. Fakat herhangi bir veri kopyalama söz konusu degildir.<\/span><\/p>\n

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

         <\/span> <\/span><\/span>DataSet cloneSet = dataSet.Clone(); <\/span><\/span><\/p>\n

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

Copy Methodu<\/span><\/strong><\/p>\n

            <\/span><\/span>Clone Methodu ile tabellarimizin yapilarini aralarindaki iliskileri baska bir datasete verileri ile kopyalamamizi saglar.<\/span><\/p>\n

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

         <\/span> <\/span><\/span>DataSet copySet = dataSet.Copy(); <\/span><\/span><\/p>\n

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

Merge Methodu<\/span><\/strong><\/p>\n

Merge methodu iki tablonun birlestirilmesi esasina dayanir. Iki tablonun birlestirilebilmesi için birtakim ön sartlarin olmasi gereklidir. <\/span><\/p>\n

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

Bir datagridde iki tablonunu gösterilebilmesi için, <\/span><\/p>\n

·         <\/span><\/span><\/span>Datatable’içindeki tüm column tipleri ve adlari ayni olamlidir.<\/span><\/p>\n

·         <\/span><\/span><\/span>DataTable isimleri ayni olmalidir.<\/span><\/p>\n

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

Merge Methodunun temel uygulama alanlari Master ve transation tablolarinin yapilandirilmasina yöneliktir.<\/span><\/p>\n

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

Table1: Iller                                <\/span>   <\/span>Table2: Iller<\/span><\/p>\n

Alan1 int32    <\/span>Pk_Il_ID                    <\/span>Alan1 int 32  <\/span> <\/span>Pk_Il_ID<\/span><\/p>\n

Alan2 string   <\/span>Il_Ad                        <\/span>Alan2 string   <\/span>Il_Ad<\/span><\/p>\n

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

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

 <\/span>   <\/span>private<\/span> void<\/span> MergeNedir()<\/span><\/p>\n

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

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

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

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

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

        <\/span>\/\/ dataSet1 mizin içersine Iller tablosunun fill edildigini düsünelim     <\/span><\/span><\/span><\/p>\n

        <\/span>\/\/ dataSet2 mizin içersine de yeni eklenen iller oldugu varsayalim<\/span><\/span><\/p>\n

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

        <\/span>dataSet1.Merge(dataSet2);<\/span><\/p>\n

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

        <\/span>GridView1.DataSource = dataSet1.Tables[0];<\/span><\/p>\n

        <\/span>GridView1.DataBind();<\/span><\/p>\n

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

   <\/span>}<\/span><\/p>","protected":false},"excerpt":{"rendered":"

Bu makalemizde DataSet sinifina ait bazi methodlarin islevlerine ve özelliklerine deyinecegiz. Bizim için yararli olabilecek bir çok method Datasetlerimizin içerisinde yer almaktadir. Bu methodlar programlama anlayisini kolaylastirmakta ve hizlandirmaktadirlar.<\/p>\n","protected":false},"author":554,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[407],"tags":[4904,5542,5345,4168,5969,6209,6291,6140,5851,4614],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/267"}],"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\/554"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}