{"id":2722,"date":"2026-05-20T21:06:50","date_gmt":"2026-05-20T18:06:50","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2722"},"modified":"2026-05-20T21:18:02","modified_gmt":"2026-05-20T18:18:02","slug":"sinav-oncesi-seviye-tespit-uygulamasi","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2026\/05\/20\/sinav-oncesi-seviye-tespit-uygulamasi\/","title":{"rendered":"S\u0131nav \u00d6ncesi Seviye Tespit Uygulamas\u0131"},"content":{"rendered":"<h3 data-path-to-node=\"7\">SINAV SENARYOSU<\/h3>\n<p data-path-to-node=\"8\">Bir k\u00fct\u00fcphane i\u00e7in kitap bilgilerinin kaydedildi\u011fi, listelendi\u011fi ve silinebildi\u011fi basit bir masa\u00fcst\u00fc uygulamas\u0131 geli\u015ftirmeniz istenmektedir. Projeniz 3 ana a\u015famadan (Veritaban\u0131, Aray\u00fcz Tasar\u0131m\u0131, Kodlama) olu\u015fmaktad\u0131r.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>M\u0130N\u0130 K\u00dcT\u00dcPHANE K\u0130TAP TAK\u0130P S\u0130STEM\u0130<\/strong><\/p>\n<p><strong>Y\u00d6NERGE:<\/strong> A\u015fa\u011f\u0131da ad\u0131mlar\u0131 belirtilen masa\u00fcst\u00fc uygulamas\u0131n\u0131 geli\u015ftiriniz. S\u0131nav bitiminde projenizi masa\u00fcst\u00fcnde a\u00e7aca\u011f\u0131n\u0131z <strong>&#8220;Grup_Ad_Soyad_No&#8221;<\/strong> klas\u00f6r\u00fcn\u00fcn i\u00e7ine kaydederek \u00f6\u011fretmen masas\u0131na teslim ediniz.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>1. SQL VER\u0130TABANI G\u00d6REVLER\u0130 (25 PUAN)<\/strong><\/span><\/p>\n<ul>\n<li><strong>G\u00d6REV 1:<\/strong> SQL Server Management Studio&#8217;yu a\u00e7arak <strong>KutuphaneDB<\/strong> ad\u0131nda bir veritaban\u0131 olu\u015fturun. <strong>(5P)<\/strong><\/li>\n<li><strong>G\u00d6REV 2:<\/strong> Bu veritaban\u0131 alt\u0131nda, kitap bilgilerini tutacak <strong>Kitaplar<\/strong> tablosunu olu\u015fturun. S\u00fctun yap\u0131lar\u0131 \u015fu \u015fekilde olmal\u0131d\u0131r: <strong>(20P)<\/strong>\n<ul>\n<li>KitapID (\u0130nt, Primary Key, Identity)<\/li>\n<li>KitapAdi (Nvarchar(100), Bo\u015f ge\u00e7ilemez)<\/li>\n<li>Yazar (Nvarchar(50), Bo\u015f ge\u00e7ilemez)<\/li>\n<li>SayfaSayisi (\u0130nt)<\/li>\n<li>YayinEvi (Nvarchar(50))<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"color: #ff0000;\"><strong>2. FORM TASARIM G\u00d6REVLER\u0130 (25 PUAN)<\/strong><\/span><\/p>\n<ul>\n<li><strong>G\u00d6REV 3:<\/strong> Visual Studio&#8217;da bir Windows Forms projesi ba\u015flat\u0131n. Formun ba\u015fl\u0131\u011f\u0131n\u0131 <strong>&#8220;K\u00fct\u00fcphane Kitap Takip Sistemi&#8221;<\/strong> yap\u0131n ve formun ekran\u0131n tam ortas\u0131nda a\u00e7\u0131lmas\u0131n\u0131 sa\u011flay\u0131n. <strong>(5P)<\/strong><\/li>\n<li><strong>G\u00d6REV 4:<\/strong> Kitap Ad\u0131, Yazar, Sayfa Say\u0131s\u0131 ve Yay\u0131nevi bilgilerini almak i\u00e7in 4 adet TextBox ve Label ekleyip hizalay\u0131n. <strong>(5P)<\/strong><\/li>\n<li><strong>G\u00d6REV 5:<\/strong> Form \u00fczerine <strong>&#8220;Kaydet&#8221;<\/strong> ve <strong>&#8220;Sil&#8221;<\/strong> butonlar\u0131 ile verileri g\u00f6sterece\u011finiz bir DataGridView ekleyin. <strong>(5P)<\/strong><\/li>\n<li><strong>G\u00d6REV 6:<\/strong> Kod yazarken karma\u015fa ya\u015famamak i\u00e7in t\u00fcm bile\u015fenlerin Name \u00f6zelliklerini programlama standartlar\u0131na uygun \u015fekilde de\u011fi\u015ftirin (\u00d6rn: txtKitapAdi, btnKaydet, dgvKitaplar). <strong>(10P)<\/strong><\/li>\n<\/ul>\n<p><span style=\"color: #ff0000;\"><strong>3. C# KODLAMA VE BA\u011eLANTI G\u00d6REVLER\u0130 (50 PUAN)<\/strong><\/span><\/p>\n<ul>\n<li><strong>G\u00d6REV 7:<\/strong> Projenize SQL k\u00fct\u00fcphanesini dahil ederek veritaban\u0131 ile form aras\u0131nda ba\u011flant\u0131 kodunu (Connection String) yaz\u0131n. <strong>(10P)<\/strong><\/li>\n<li><strong>G\u00d6REV 8:<\/strong> Uygulama ilk a\u00e7\u0131ld\u0131\u011f\u0131nda (Form_Load), veritaban\u0131ndaki t\u00fcm kitaplar\u0131 DataGridView i\u00e7ine \u00e7eken listeleme fonksiyonunu yaz\u0131n. <strong>(10P)<\/strong><\/li>\n<li><strong>G\u00d6REV 9:<\/strong> &#8220;Kaydet&#8221; butonuna t\u0131kland\u0131\u011f\u0131nda, aray\u00fczdeki verileri SQL tablosuna g\u00fcvenli bir \u015fekilde (Parametre kullanarak) kaydeden ve ard\u0131ndan listeyi g\u00fcncelleyen kodlar\u0131 yaz\u0131n. <strong>(15P)<\/strong><\/li>\n<li><strong>G\u00d6REV 10:<\/strong> &#8220;Sil&#8221; butonuna t\u0131kland\u0131\u011f\u0131nda, DataGridView&#8217;den se\u00e7ilen sat\u0131rdaki kitab\u0131n ID&#8217;sine g\u00f6re SQL&#8217;den silme i\u015flemini ger\u00e7ekle\u015ftiren ve listeyi yenileyen kodlar\u0131 yaz\u0131n. <strong>(15P)<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul data-path-to-node=\"20\">\n<li>\n<p data-path-to-node=\"20,3,0\">Not: SQL Connection String i\u00e7erisindeki <code data-path-to-node=\"30\" data-index-in-node=\"56\">Data Source=.<\/code> (local) k\u0131sm\u0131n\u0131, bilgisayardaki SQL Server instance yap\u0131s\u0131na g\u00f6re (\u00f6rne\u011fin <code data-path-to-node=\"30\" data-index-in-node=\"146\">Lab3Ogretmen\\SQLEXPRESS<\/code>) \u015feklinde de\u011fi\u015ftiriniz.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SINAV SENARYOSU Bir k\u00fct\u00fcphane i\u00e7in kitap bilgilerinin kaydedildi\u011fi, listelendi\u011fi ve silinebildi\u011fi basit bir masa\u00fcst\u00fc uygulamas\u0131 geli\u015ftirmeniz istenmektedir. Projeniz 3 ana [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2374,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,180],"tags":[254,49,255],"class_list":["post-2722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programlama","category-sql","tag-kitap-takip-sistemi","tag-sql","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2722","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=2722"}],"version-history":[{"count":3,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2722\/revisions"}],"predecessor-version":[{"id":2727,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2722\/revisions\/2727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2374"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}