{"id":2560,"date":"2025-04-29T10:56:25","date_gmt":"2025-04-29T07:56:25","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2560"},"modified":"2025-04-29T11:07:31","modified_gmt":"2025-04-29T08:07:31","slug":"ziyaretci-c-uygulamasi","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2025\/04\/29\/ziyaretci-c-uygulamasi\/","title":{"rendered":"Ziyaret\u00e7i c# uygulamas\u0131"},"content":{"rendered":"<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\nstring connectionString = &quot;Server=LAB3OGRTMEN\\\\SQLEXPRESS01;Database=ziyaretci;Trusted_Connection=True;&quot;;\r\nSqlConnection baglanti = new SqlConnection(connectionString);\r\n\r\ntry\r\n{\r\nbaglanti.Open();\r\n\r\nSqlCommand komut = new SqlCommand(&quot;INSERT INTO Kisiler (AdiSoyadi,Telefon,GorusulecekKisi,ZiyaretSebebi,NobetciSinif,NobetciAdSoyad) VALUES (@AdiSoyadi, @Telefon, @GorusulecekKisi, @ZiyaretSebebi,@NobetciSinif,@NobetciAdSoyad)&quot;, baglanti);\r\n\r\nkomut.Parameters.AddWithValue(&quot;@AdiSoyadi&quot;, txtAdSoyad.Text);\r\nkomut.Parameters.AddWithValue(&quot;@Telefon&quot;, txtTelefon.Text);\r\nkomut.Parameters.AddWithValue(&quot;@GorusulecekKisi&quot;, txtGorusulecekKisi.Text);\r\nkomut.Parameters.AddWithValue(&quot;@ZiyaretSebebi&quot;, txtZiyaretSebebi.Text);\r\nkomut.Parameters.AddWithValue(&quot;@NobetciSinif&quot;, CBSinif.Text);\r\nkomut.Parameters.AddWithValue(&quot;@NobetciAdSoyad&quot;, txtNobetciAdSoyad.Text);\r\nkomut.ExecuteNonQuery();\r\nMessageBox.Show(&quot;Kitap ba\u015far\u0131yla eklendi!&quot;);\r\ntxtAdSoyad.Clear();\r\ntxtTelefon.Clear();\r\ntxtGorusulecekKisi.Clear();\r\ntxtZiyaretSebebi.Clear();\r\ntxtNobetciAdSoyad.Clear();\r\nCBSinif.Text = &quot;&quot;;\r\ntxtAdSoyad.Focus();\r\n}\r\ncatch (Exception ex)\r\n{\r\nMessageBox.Show(&quot;Hata olu\u015ftu: &quot; + ex.Message);\r\n}\r\n\r\nfinally\r\n{\r\nbaglanti.Close();\r\n}\r\n\r\n\r\n<\/pre>\n<p><a href=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-2561\" src=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret1-292x300.png\" alt=\"\" width=\"292\" height=\"300\" srcset=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret1-292x300.png 292w, https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret1.png 486w\" sizes=\"auto, (max-width: 292px) 100vw, 292px\" \/><\/a> <a href=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-2562\" src=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret2-300x220.png\" alt=\"\" width=\"300\" height=\"220\" srcset=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret2-300x220.png 300w, https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2025\/04\/ziyaret2.png 373w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>string connectionString = &quot;Server=LAB3OGRTMEN\\\\SQLEXPRESS01;Database=ziyaretci;Trusted_Connection=True;&quot;; SqlConnection baglanti = new SqlConnection(connectionString); try { baglanti.Open(); SqlCommand komut = new SqlCommand(&quot;INSERT INTO Kisiler (AdiSoyadi,Telefon,GorusulecekKisi,ZiyaretSebebi,NobetciSinif,NobetciAdSoyad) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2561,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[245],"class_list":["post-2560","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programlama","tag-c-ziyaretci-ornegi"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=2560"}],"version-history":[{"count":3,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2560\/revisions"}],"predecessor-version":[{"id":2565,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2560\/revisions\/2565"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2561"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}