{"id":235,"date":"2012-03-19T21:49:02","date_gmt":"2012-03-19T21:49:02","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=235"},"modified":"2012-05-28T13:00:42","modified_gmt":"2012-05-28T13:00:42","slug":"cta-sqlconnection-nesnesinin-statechange-olayi","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/cta-sqlconnection-nesnesinin-statechange-olayi\/","title":{"rendered":"C# SqlConnection Nesnesinin StateChange Olay\u0131"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Bu yaz\u0131mda C#&#8217;ta SqlConnection nesnesinin StateChange olay\u0131na de\u011finece\u011fim.Bu olay SqlConnection nesnesinin State \u00f6zelli\u011fi de\u011fi\u015fti\u011finde yani durumu de\u011fi\u015fti\u011finde \u00e7al\u0131\u015f\u0131r.Connection kapal\u0131 iken a\u00e7\u0131k hale gelirse ya da a\u00e7\u0131k iken kapal\u0131 hale gelirse ya da di\u011fer durumlar vs&#8230; halinde tetiklenir.<br \/>\n\u015eimdi gelin bu olay\u0131 deneyelim.<br \/>\nBen formuma iki buton ekliyorum(buton1 buton2).Ve ard\u0131ndan a\u015fa\u011f\u0131daki kodlar\u0131 yaz\u0131yorum.<br \/>\n<!--more--><\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSqlConnection baglanti = new SqlConnection(&quot;Server=GEN\u00c7AY-GEN\u00c7AY;database=northwind;trusted_connection=true;&quot;);\r\nprivate void Form1_Load(object sender, EventArgs e)\r\n{\r\nbaglanti.StateChange += new System.Data.StateChangeEventHandler(baglanti_StateChange);\r\n}\r\n\r\nvoid baglanti_StateChange(object sender, System.Data.StateChangeEventArgs e)\r\n{\r\nthis.Text = &quot;Orginal : &quot; + e.OriginalState + &quot;Current : &quot; + e.CurrentState;\r\n\/\/ OriginalState : Ba\u011flant\u0131n\u0131n \u015fu ankinden bir \u00f6nceki durumu\/\/ CurrentState : Ba\u011flant\u0131n\u0131n \u015fu anki durumu\r\n}\r\nprivate void button1_Click(object sender, EventArgs e)\r\n{\r\nbaglanti.Open();\r\n}\r\nprivate void button2_Click(object sender, EventArgs e)\r\n{\r\nbaglanti.Close();\r\n}\r\n<\/pre>\n<p>Yukardaki kod blo\u011funu \u00e7al\u0131\u015ft\u0131r\u0131rsan\u0131z,button1 t\u0131kland\u0131\u011f\u0131nda :Orginal Closed-Current Open,buton2 t\u0131kland\u0131\u011f\u0131nda :Orginal Open-Current Closed yazacakt\u0131r.<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Bu yaz\u0131mda C#&#8217;ta SqlConnection nesnesinin StateChange olay\u0131na de\u011finece\u011fim.Bu olay SqlConnection nesnesinin State \u00f6zelli\u011fi de\u011fi\u015fti\u011finde yani durumu de\u011fi\u015fti\u011finde \u00e7al\u0131\u015f\u0131r.Connection kapal\u0131 iken a\u00e7\u0131k hale gelirse ya da a\u00e7\u0131k iken kapal\u0131 hale gelirse ya da di\u011fer durumlar&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[132,152],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","tag-sqlconnection","tag-statechange"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/235","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=235"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/235\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}