<\/div>\n
Genellikle amat\u00f6rce kod yaz\u0131m hatalar\u0131ndan birisi olan “Invalid attempt to call MetaData when reader is closed<\/strong><\/span>” hatas\u0131ndan bahsedece\u011fim.<\/p>\n
Ado.NET i\u015flemleri yapt\u0131\u011f\u0131m\u0131z bir sayfada birden fazla SqlDataReader nesnesi kullan\u0131yorsak e\u011fer a\u015fa\u011f\u0131daki gibi bir i\u015flem hatas\u0131 yapm\u0131\u015f olabiliriz.<\/p>\n
\r\n        SqlConnection baglanti = new SqlConnection("Provider");\r\n\r\n        private void Islem(object sender, EventArgs e)\r\n        {\r\n            baglanti.Open();\r\n            SqlCommand Sorgu = new SqlCommand("Sorgu",baglanti);\r\n            SqlDataReader dr = Sorgu.ExecuteReader();\r\n            while (dr.HasRows)\r\n            {\r\n                textbox1.Text = dr.GetValue(0).ToString();\r\n            }\r\n            dr.Close();\r\n            dr.Dispose();\r\n            baglanti.Close();\r\n\/\/-----------------------------------------------\r\n            baglanti.Open();\r\n            SqlCommand Sorgu2 = new SqlCommand("Sorgu",baglanti);\r\n            SqlDataReader dr2 = Sorgu.ExecuteReader();\r\n            while (dr2.HasRows)\r\n            {\r\n                textbox1.Text = dr.GetValue(0).ToString();\r\n\/\/Hata dr referans\u0131n\u0131n kullan\u0131lmaya \u00e7al\u0131\u015f\u0131lmas\u0131d\u0131r.\r\n            }\r\n            dr2.Close();\r\n            dr2.Dispose();\r\n            baglanti.Close();\r\n        }\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi nesne tabanl\u0131 programlama tekni\u011finin kullan\u0131lmad\u0131\u011f\u0131 hata olas\u0131l\u0131\u011f\u0131 y\u00fcksek ve bir o kadar da karma\u015f\u0131k bu tarz yaz\u0131l\u0131mlarda “Invalid attempt to call MetaData when reader is closed” hatas\u0131n\u0131 alman\u0131z gayet do\u011fald\u0131r.\u00c7\u00fcnk\u00fc bir “dr” referans\u0131ndaki SqlDataReader nesnesini kullan\u0131p Dispose etti\u011finiz halde alt sat\u0131rlarda “dr2” referans\u0131 yerine yanl\u0131\u015fl\u0131kla “dr” referans\u0131n\u0131n kullan\u0131lmas\u0131 bu hataya sebep olmaktad\u0131r.<\/p>\n
Bu hatan\u0131n \u00e7\u00f6z\u00fcm\u00fc kolayd\u0131r ama dikkat etmemiz gereken temel prensip kaliteli, anla\u015f\u0131l\u0131r ve d\u00fcnya standartlar\u0131na uygun bir tarzda kod yazman\u0131zd\u0131r.Aksi halde programlama sanat\u0131n\u0131 anlamay\u0131p yanl\u0131\u015f lanse etmenize sebep olacakt\u0131r.<\/p>\n
Faydalanman\u0131z dile\u011fiyle..<\/p>\n","protected":false},"excerpt":{"rendered":"
Genellikle amat\u00f6rce kod yaz\u0131m hatalar\u0131ndan birisi olan “Invalid attempt to call MetaData when reader is closed” hatas\u0131ndan bahsedece\u011fim. Ado.NET i\u015flemleri yapt\u0131\u011f\u0131m\u0131z bir sayfada birden fazla SqlDataReader nesnesi kullan\u0131yorsak e\u011fer a\u015fa\u011f\u0131daki gibi bir i\u015flem hatas\u0131...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[258],"tags":[129,260,134],"class_list":["post-1717","post","type-post","status-publish","format-standard","hentry","category-hata-cozumleri","tag-ado-net","tag-hata","tag-sqldatareader"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/1717","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=1717"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/1717\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=1717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=1717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=1717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}