<\/div>\n

Bu yaz\u0131m\u0131zda Disconnected gibi Connected \u00e7al\u0131\u015fmay\u0131 g\u00f6rece\u011fiz.Disconnected mimaride verilerimize blog blog ula\u015fabildi\u011fimizden dolay\u0131 veriler aras\u0131ndaki i\u015flemlerimizi kolayl\u0131kla ger\u00e7ekle\u015ftirebiliyorduk.Ancak Connected mimaride veriler teker teker geldi\u011finden bazen s\u0131k\u0131nt\u0131 durumlar olu\u015fabiliyor.Ancak Connected \u00e7al\u0131\u015f\u0131rken Disconnected mimari gibi bir yap\u0131dan faydalanabiliriz.Yani Connected \u00e7al\u0131\u015f\u0131rken \u00f6yle bir yap\u0131 kuraca\u011f\u0131zki verilerimize Disconnected mimarideki gibi rahat h\u00fckmedebilece\u011fiz.Ama nihayetinde Connected olaca\u011f\u0131z.
\n
\nConnected mimaride veriler aras\u0131nda rahat \u00e7al\u0131\u015fmak i\u00e7in ne gibi bir yap\u0131 kullanabiliriz de gelen verileri bu yap\u0131 i\u00e7inde tutabiliriz.Bir class olu\u015ftursak ve gelen her veriyi bu classtan bir nesneye atasak nas\u0131l olur?
\n\u015eimdi bir \u00f6rnek yapal\u0131m.Northwind tablosundaki Ad\u0131,Soyad\u0131 ve PersonelId bilgilerini Disconnected gibi Connected \u00e7al\u0131\u015farak \u00e7ekip DataGridView nesnesinde g\u00f6sterelim.
\nFormumuza bir tane DataGridView nesnesi ekleyelim.
\n\u00d6ncelikle “Personeller.cs” adl\u0131 bir class dosyas\u0131 olu\u015ftural\u0131m.<\/p>\n

\r\nclass Personeller\r\n    {\r\n        public int PersonelId { get; set; }\r\n        public string PersonelAdi { get; set; }\r\n        public string PersonelSoyadi { get; set; }\r\n        public void Personel(int PersonelId,string PersonelAdi,string PersonelSoyadi)\r\n        {\r\n            this.PersonelId = PersonelId;\r\n            this.PersonelAdi = PersonelAdi;\r\n            this.PersonelSoyadi = PersonelSoyadi;\r\n        }\r\n    }\r\n<\/pre>\n\u015eimdi Disconnected gibi Connected \u00e7al\u0131\u015fmay\u0131 g\u00f6relim.<\/p>\n
\r\nprivate void Form1_Load(object sender, EventArgs e)\r\n        {\r\n            ArrayList personeller = new ArrayList();\r\n\/\/Personel nesnelerini tutacak ArrayList koleksiyonu olu\u015fturuyoruz.\r\n            SqlConnection baglanti = new SqlConnection("server=GEN\u00c7AY-GEN\u00c7AY;database=Northwind;trusted_connection=true;");\r\n            baglanti.Open();\r\n            SqlCommand cmd = new SqlCommand("Select PersonelId,Adi,SoyAdi From Personeller",baglanti);\r\n            SqlDataReader dtr = cmd.ExecuteReader();\r\n            while (dtr.Read())\r\n            {\r\n                Personeller prs = new Personeller();\r\n                prs.PersonelAdi = dtr["Adi"].ToString();\r\n                prs.PersonelSoyadi = dtr["SoyAdi"].ToString();\r\n                prs.PersonelId = Convert.ToInt32(dtr["PersonelId"]);\r\n                personeller.Add(prs);\r\n            }\r\n            dataGridView1.DataSource = personeller;\r\n            baglanti.Close();\r\n        }\r\n<\/pre>\nYukarda g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi Connected mimari sayesinde teker teker gelen veriler Personeller clas\u0131 sayesinde olu\u015fturdu\u011fumuz nesneler de tutuluyor.Bu nesneleri ArrayList koleksiyonuna at\u0131p bu nesneler \u00fczerinde istedi\u011fimiz kontrol\u00fc yapabiliriz.\u0130\u015fte Disconnected gibi Conected mimarisiyle \u00e7al\u0131\u015ft\u0131k.\u015eimdilik bu kadar kolay gelsin..<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131m\u0131zda Disconnected gibi Connected \u00e7al\u0131\u015fmay\u0131 g\u00f6rece\u011fiz.Disconnected mimaride verilerimize blog blog ula\u015fabildi\u011fimizden dolay\u0131 veriler aras\u0131ndaki i\u015flemlerimizi kolayl\u0131kla ger\u00e7ekle\u015ftirebiliyorduk.Ancak Connected mimaride veriler teker teker geldi\u011finden bazen s\u0131k\u0131nt\u0131 durumlar olu\u015fabiliyor.Ancak Connected \u00e7al\u0131\u015f\u0131rken Disconnected mimari gibi bir...<\/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,131,139],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","category-veritabani","tag-ado-net","tag-connected","tag-disconnected"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/214","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=214"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}