<\/div>\n

Bu yaz\u0131mda ADO.NET te Disconnected Mimarye giri\u015f yapaca\u011f\u0131z.Disconnected mimaride veritaban\u0131yla pek ili\u015fkimiz yoktur.Connected mimaride oldu\u011fu gibi manuel olarak ba\u011flant\u0131y\u0131 a\u00e7\u0131p kapatmam\u0131za gerek yoktur.SqlDataAdapter nesnesi bu i\u015fi otomatik olarak yapmaktad\u0131r.\u015eimdi nesneleri tan\u0131t\u0131p \u00f6rnek yapal\u0131m.
\n
\nSqlDataAdapter Nesnesi<\/strong><\/span>
\nSqlCommand nesnesi gibi verilen ba\u011flant\u0131 \u00fczerine sorguyu \u00e7al\u0131\u015ft\u0131r\u0131r.Ba\u011flant\u0131y\u0131 a\u00e7\u0131p kapatmaya gerek yoktur.Kendisi bu i\u015flemi otomatik yapar.Biz ona select sorgusu veririz, o bu select sorgusuna g\u00f6re insert,update ve delete sorgular\u0131n\u0131 otomatik olarak olu\u015fturur.Daha sonra SqlDataAdapter metodlar\u0131n\u0131 kullanarak bu sorgular\u0131 \u00e7al\u0131\u015ft\u0131rabiliriz.<\/p>\n

DataSet Nesnesi\u00a0<\/span><\/strong>
\nBellekte veritaban\u0131na benzer bir yap\u0131 olu\u015fturur.Bu yap\u0131 i\u00e7inde DataTable’lar saklayabiliriz.Default olarak i\u00e7inde bir adet DataTable vard\u0131r.\u0130\u00e7indeki DataTable’ler DataSet’in Tables koleksiyonunda saklan\u0131r.<\/p>\n

DataTable Nesnesi\u00a0<\/strong><\/span>
\nBellekte veritaban\u0131 tablosu yap\u0131s\u0131nda bir yap\u0131 olu\u015fturur.<\/p>\n

\u015eimdi formumuza bir ComboBox kontrol\u00fc koyal\u0131m ve Northwind tablosundaki Ad ve Soyadlar\u0131 bu ComboBox\u0131n i\u00e7ine \u00e7ekelim.<\/p>\n

\r\n SqlConnection baglanti = new SqlConnection();\r\n            baglanti.ConnectionString = "server=GEN\uffc7AY-GEN\uffc7AY;database=northwind;trusted_connection=true;";\r\n            SqlDataAdapter dta = new SqlDataAdapter("select Adi + ' ' + Soyadi as isim from Personeller",baglanti);\r\n            DataSet ds = new DataSet();\r\n            dta.Fill(ds,"Personeller");\r\n            comboBox1.DataSource=ds.Tables["Personeller"];\r\n            comboBox1.DisplayMember = "isim";\r\n            comboBox1.ValueMember = "PersonelId";\r\n<\/pre>\nYukardaki kodlar\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131z zaman ComboBox kontrol\u00fcne Ad ve Soyad\u0131n eklendi\u011fini g\u00f6rece\u011fiz.Tabi “Gen\u00e7ay Y\u0131ld\u0131z” \u015feklinde eklenmesi i\u00e7in sorgumuzu ona g\u00f6re ayarl\u0131yoruz.\u015eimdi kodlardaki yap\u0131lar\u0131 izah edeyim;
\nSqlDataAdapter dta = new SqlDataAdapter(“select Adi + ‘ ‘ + Soyadi as isim from Personeller”,baglanti); = SqlCommand gibi sorgumuzu yaz\u0131p , ba\u011flant\u0131m\u0131z\u0131 tan\u0131ml\u0131yoruz.Ba\u011flant\u0131y\u0131 kendisi otomatik a\u00e7\u0131p kapatt\u0131\u011f\u0131ndan biz ba\u011flant\u0131y\u0131 ellemiyoruz.
\nDataSet ds = new DataSet(); = DataSet nesnesi olu\u015fturuyoruz ki DataAdapter nesnesinden DataSet’e tablolar\u0131 atabilelim.
\ndta.Fill(ds,”Personeller”); = SqlDataAdapter’\u0131n Fill() metoduyla DataSet’e tablolar\u0131 atabiliriz.G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi referans ad\u0131 ds olan DataSet nesnesine veritaban\u0131ndan gelen tablo at\u0131l\u0131yor ve bu tablonun ad\u0131nada “Personeller” deniyor.
\ncomboBox1.DataSource=ds.Tables[“Personeller”]; = ComboBox,ListBox vs. gibi kontrollerin DataSource \u00f6zelli\u011fi vard\u0131r.Bu \u00f6zellik sayesinde bu kontrollerin veri kayna\u011f\u0131 olarak neyi baz alaca\u011f\u0131n\u0131 g\u00f6sterebiliyoruz.Bu \u015fekilde,ds.Tables[“Personeller”] diyerek, DataSet’in i\u00e7indeki tablolardan ad\u0131 Personeller olan tabloyu bu nesneye verikayna\u011f\u0131 yap demi\u015f oluyorum.E\u011fer SqlDataAdapter’\u0131n Fill() metodunu kullan\u0131rken DataSet’e aktar\u0131lan tabloya “Personeller” ismini vermemi\u015f olsayd\u0131m, bu sefer ds.Tables[0] olarak bu tabloyu \u00e7a\u011f\u0131racakt\u0131m.\u00c7\u00fcnk\u00fc yazd\u0131\u011f\u0131m\u0131z sorgu sonucunda bir tane tablo d\u00f6necektir ve o tablonun ismi olsada olmasada index numaras\u0131 0 d\u0131r.
\ncomboBox1.DisplayMember = “isim”; = Burada ise Personeller tablosunda hangi kolonu g\u00f6sterece\u011fini s\u00f6yl\u00fcyoruz.Birden fazla kolon d\u00f6nmesi sonucunda ComboBox t\u00fcr\u00fc nesneler hangilerini nas\u0131l g\u00f6sterece\u011fini bilmedi\u011fi i\u00e7in DisplayMember \u00f6zelli\u011fi ile hangi kolonu g\u00f6stermesi gerekti\u011fini belirtiyoruz.
\ncomboBox1.ValueMember = “PersonelId”; = \u00d6rne\u011fin ben ComboBox’tan “Gen\u00e7ay Y\u0131ld\u0131z” \u0131 se\u00e7iyorum ve bunun sonucunda bana bir de\u011fer d\u00f6nmesini talep ediyorum.”Gen\u00e7ay Y\u0131ld\u0131z” isim ve soyisminin PersonelId sini bana ValueMember \u00f6zelli\u011fi sayesinde geliyor.<\/p>\n
E\u011fer ComboBox,listBox vs. gibi kontrolleri kullan\u0131yorsan\u0131z SelectedIndexChanged yerine SelectionChangeCommitted olay\u0131n\u0131 kullan\u0131n\u0131z.Bunun sebebi SelectedIndexChanged y\u00fcklenir y\u00fcklenmez \u00e7al\u0131\u015f\u0131rken SelectionChangeCommitted siz t\u0131klad\u0131\u011f\u0131n\u0131z zaman \u00e7al\u0131\u015facakt\u0131r.Bu aksakl\u0131k bazen istenmeyen ufak tefek sorunlara yol a\u00e7abilir.<\/p>\n
\u015eimdi DataTable nesnesini de kullanmay\u0131 g\u00f6relim.<\/p>\n
\r\nSqlConnection baglanti = new SqlConnection();\r\n            baglanti.ConnectionString = "server=GEN\u00c7AY-GEN\u00c7AY;database=northwind;trusted_connection=true;";\r\n            SqlDataAdapter dta = new SqlDataAdapter("select Adi + ' ' + Soyadi as isim,PersonelId from Personeller",baglanti);\r\n            DataSet ds = new DataSet();\r\n            DataTable dt = new DataTable("Personeller");\r\n            ds.Tables.Add(dt);\r\n            dta.Fill(ds,"Personeller");\r\n            comboBox1.DataSource = dt;\r\n            comboBox1.DisplayMember = "isim";\r\n            comboBox1.ValueMember = "PersonelId";\r\n<\/pre>\nYukardaki yap\u0131da ise,DataTable nesnesi olu\u015fturup ad\u0131na “Personeller” dedim.Bunu referans ad\u0131 ds olan DataSet nesnesinin Tables koleksiyonuna(koleksiyon oldu\u011fu i\u00e7in Add metodu var) Add() metoduna ekliyorum.SqlDataAdapter nesnesinin Fill() metoduyla DataSet’ime tabloyu y\u00fcklerken bu sefer DataSet’imdeki var olan “Personeller” tablosunu se\u00e7iyorum.ComboBox’\u0131n DataSource \u00f6zelli\u011fine DataSet’imi de\u011fil DataTable’\u0131m\u0131 ba\u011fl\u0131yorum.Sonu\u00e7ta di\u011fer t\u00fcrl\u00fc DataSet’in i\u00e7indeki tabloyu g\u00f6stererek ba\u011fl\u0131yordum.Bi\u015fey de\u011fi\u015fmiyor.Geri kalan\u0131 bildi\u011finiz gibi..<\/p>\n
Hi\u00e7 DataSet olu\u015fturmadan SqlDataAdapter’a gelen verileri DataTable’a atabilirmiyiz diye sorarsan\u0131z e\u011fer evet.SqlDataAdapter nesnesinin Fill() metoduna bu sefer DataSet de\u011fil DataTable nesnemizi yazarsak tablomuz DataTable’\u0131m\u0131za y\u00fcklenecektir.Mant\u0131ken bunu yaparken sorgumuzdan bir tablo geldi\u011fini bilmemiz gerekiyor.Birden fazla tablo gelirse e\u011fer bu tablolar\u0131 DataTable \u0131m\u0131za de\u011fil,DataSet’imize atmal\u0131y\u0131z.<\/p>\n
\r\nSqlConnection baglanti = new SqlConnection();\r\n            baglanti.ConnectionString = "server=GEN\u00c7AY-GEN\u00c7AY;database=northwind;trusted_connection=true;";\r\n            SqlDataAdapter dta = new SqlDataAdapter("select Adi + ' ' + Soyadi as isim,PersonelId from Personeller",baglanti);\r\n            DataTable dt = new DataTable();\r\n            dta.Fill(dt);\r\n            comboBox1.DataSource = dt;\r\n            comboBox1.DisplayMember = "isim";\r\n            comboBox1.ValueMember = "PersonelId";\r\n<\/pre>\n\u015eimdilik burda keselim.Bir sonraki yaz\u0131mda SqlDataAdapter nesnesini daha detayl\u0131 anlataca\u011f\u0131m.\u0130yi \u00e7al\u0131\u015fmalar.<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131mda ADO.NET te Disconnected Mimarye giri\u015f yapaca\u011f\u0131z.Disconnected mimaride veritaban\u0131yla pek ili\u015fkimiz yoktur.Connected mimaride oldu\u011fu gibi manuel olarak ba\u011flant\u0131y\u0131 a\u00e7\u0131p kapatmam\u0131za gerek yoktur.SqlDataAdapter nesnesi bu i\u015fi otomatik olarak yapmaktad\u0131r.\u015eimdi nesneleri tan\u0131t\u0131p \u00f6rnek yapal\u0131m.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,22],"tags":[129,137,136,139,138],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","category-veritabani","tag-ado-net","tag-dataset","tag-datatable","tag-disconnected","tag-sqldataadapter"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/202","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=202"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}