{"id":10,"date":"2008-09-14T16:02:13","date_gmt":"2008-09-14T13:02:13","guid":{"rendered":"http:\/\/www.notsayfam.com\/?p=13"},"modified":"2008-11-28T00:16:39","modified_gmt":"2008-11-27T21:16:39","slug":"10-autosave","status":"publish","type":"post","link":"https:\/\/www.notsayfam.com\/?p=10","title":{"rendered":"Sqldatareader ile kay\u0131t say\u0131s\u0131n\u0131 kontrol etmek"},"content":{"rendered":"<p>Dim a As String<br \/>\nDim sayi As Integer<br \/>\na = InputBox(\u201dFirma Ad\u0131n\u0131n birka\u00e7 harfini giriniz\u201d)<br \/>\nsqlbaglanti.Open()<br \/>\nsqlkomut.CommandText = \u201cSELECT COUNT(*) FROM firma WHERE firmaadi LIKE \u2018%\u201d + UCase(a) + \u201c%\u2019\u201d<br \/>\nsqlkomut.ExecuteNonQuery()<br \/>\nveriler = sqlkomut.ExecuteReader(CommandBehavior.SingleResult)<br \/>\nDo While veriler.Read<br \/>\nsayi = veriler(0)<br \/>\nLoop<br \/>\nIf sayi > 1 Then<br \/>\nMsgBox(\u201dbirden fazla\u201d)<br \/>\nEnd If<br \/>\nsqlbaglanti.Close()<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dim a As String Dim sayi As Integer a = InputBox(\u201dFirma Ad\u0131n\u0131n birka\u00e7 harfini giriniz\u201d) sqlbaglanti.Open() sqlkomut.CommandText = \u201cSELECT COUNT(*) FROM firma WHERE firmaadi LIKE \u2018%\u201d + UCase(a) + \u201c%\u2019\u201d sqlkomut.ExecuteNonQuery() veriler = sqlkomut.ExecuteReader(CommandBehavior.SingleResult) Do While veriler.Read sayi = veriler(0) Loop If sayi > 1 Then MsgBox(\u201dbirden fazla\u201d) End If sqlbaglanti.Close()<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,12],"tags":[45,105,106,17],"class_list":["post-10","post","type-post","status-publish","format-standard","hentry","category-programlama","category-sql","tag-count","tag-programlama","tag-sql","tag-vbnet"],"_links":{"self":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10"}],"version-history":[{"count":4,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/10\/revisions"}],"predecessor-version":[{"id":95,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/10\/revisions\/95"}],"wp:attachment":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}