<\/div>\n

Bu yaz\u0131m\u0131zda SqlCommand ile insert,update ve delete sorgular\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmay\u0131 g\u00f6sterece\u011fim.Bir \u00f6nceki yaz\u0131mda SqlCommand nesnesinin nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 ve hangi Execute metoduyla hangi sorgular \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131ndan bahsetmi\u015ftim.\u0130nsert,update ve delete i\u015flemleri i\u00e7in ExecuteNonQuery() metodunu kullanaca\u011f\u0131m\u0131z\u0131 tekrardan de\u011finmek istiyorum.
\n
\nExecuteNonQuery metodundan bahsetmek gerekirse,\u00e7al\u0131\u015ft\u0131r\u0131lan sorgu sonucu ka\u00e7 kay\u0131t\u0131n etkilendi\u011fini bize int tipinde geri d\u00f6ner.Bu sayede ka\u00e7 kay\u0131t eklemi\u015fiz,silmi\u015fiz ya da g\u00fcncellemi\u015fiz bilgi alabiliriz.<\/p>\n

\r\nSqlConnection baglanti = new SqlConnection("Server=GEN\u00c7AY-GEN\u00c7AY;database=Northwind;trusted_connection=true;");\r\n            baglanti.Open();\r\n            SqlCommand cmd = new SqlCommand("insert Personeller(Adi,Soyadi) values('Gen\u00e7ay','Y\u0131ld\u0131z')",baglanti);\r\n            cmd.ExecuteNonQuery();\r\n            baglanti.Close();\r\n            baglanti.Dispose();\r\n<\/pre>\nYukarda g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi cmd.ExecuteNonQuery() metodu ile sorgu \u00e7al\u0131\u015ft\u0131r\u0131l\u0131yor ve Personeller tablosuna veriler kaydediliyor.
\nAncak bu kodlar\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda i\u015flem yap\u0131ld\u0131m\u0131 yap\u0131lmad\u0131m\u0131 biz fark\u0131nda olmay\u0131z.Bunun i\u00e7in cmd.ExecuteNonQuery() kodunun geri d\u00f6n\u00fc\u015f de\u011ferinden faydalanmak laz\u0131m.Bir int tipinde de\u011fi\u015fkene alarak e\u011fer bu de\u011fi\u015fken 0 dan b\u00fcy\u00fckse i\u015flem kesinlikle yap\u0131lm\u0131\u015ft\u0131r.De\u011filse kay\u0131t i\u015flemi yap\u0131lmam\u0131\u015ft\u0131r.<\/p>\n
\r\nSqlConnection baglanti = new SqlConnection("Server=GEN\u00c7AY-GEN\u00c7AY;database=Northwind;trusted_connection=true;");\r\n            baglanti.Open();\r\n            SqlCommand cmd = new SqlCommand("insert Personeller(Adi,Soyadi) values('Gen\u00e7ay','Y\u0131ld\u0131z')", baglanti);\r\n            int kontrol = cmd.ExecuteNonQuery();\r\n            if (kontrol>0)\r\n            {\r\n                MessageBox.Show("Kay\u0131t yap\u0131ld\u0131");\r\n            }\r\n            else\r\n            {\r\n                MessageBox.Show("Kay\u0131t i\u015flemi ba\u015far\u0131s\u0131z.");\r\n            }\r\n            baglanti.Close();\r\n            baglanti.Dispose();\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Bu yaz\u0131m\u0131zda SqlCommand ile insert,update ve delete sorgular\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmay\u0131 g\u00f6sterece\u011fim.Bir \u00f6nceki yaz\u0131mda SqlCommand nesnesinin nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 ve hangi Execute metoduyla hangi sorgular \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131ndan bahsetmi\u015ftim.\u0130nsert,update ve delete i\u015flemleri i\u00e7in ExecuteNonQuery() metodunu kullanaca\u011f\u0131m\u0131z\u0131 tekrardan de\u011finmek istiyorum.<\/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,87,79,133,86],"class_list":["post-195","post","type-post","status-publish","format-standard","hentry","category-c-sharp-c","category-veritabani","tag-ado-net","tag-delete","tag-insert","tag-sqlcommand","tag-update"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/195","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=195"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}