— 1. Veritaban\u0131 Olu\u015fturma
\nCREATE DATABASE KutuphaneDB;
\nGO<\/p>\n
USE KutuphaneDB;
\nGO<\/p>\n
— 2. Tablo Olu\u015fturma
\nCREATE TABLE Kitaplar (
\nKitapID INT IDENTITY(1,1) PRIMARY KEY,
\nKitapAdi NVARCHAR(100) NOT NULL,
\nYazar NVARCHAR(50) NOT NULL,
\nSayfaSayisi INT,
\nYayinEvi NVARCHAR(50)
\n);<\/p>\n
using System;
\nusing System.Data;
\nusing System.Windows.Forms;
\nusing System.Data.SqlClient; \/\/ SQL Ba\u011flant\u0131s\u0131 i\u00e7in gerekli k\u00fct\u00fcphane<\/p>\n
namespace KutuphaneProjesi
\n{
\npublic partial class Form1 : Form
\n{
\npublic Form1()
\n{
\nInitializeComponent();
\n}<\/p>\n
\/\/ Ba\u011flant\u0131 c\u00fcmlesi (Server ismi laboratuvardaki bilgisayarlara g\u00f6re g\u00fcncellenmelidir)
\nSqlConnection baglanti = new SqlConnection(“Data Source=.;Initial Catalog=KutuphaneDB;Integrated Security=True”);<\/p>\n
\/\/ 1. Listeleme Fonksiyonu
\nvoid KitapListele()
\n{
\ntry
\n{
\nbaglanti.Open();
\nSqlDataAdapter da = new SqlDataAdapter(“SELECT * FROM Kitaplar”, baglanti);
\nDataTable dt = new DataTable();
\nda.Fill(dt);
\ndgvKitaplar.DataSource = dt;
\n}
\ncatch (Exception hata)
\n{
\nMessageBox.Show(“Hata olu\u015ftu: ” + hata.Message);
\n}
\nfinally
\n{
\nbaglanti.Close();
\n}
\n}<\/p>\n
\/\/ Form a\u00e7\u0131ld\u0131\u011f\u0131nda listeleme tetiklenir
\nprivate void Form1_Load(object sender, EventArgs e)
\n{
\nKitapListele();
\n}<\/p>\n
\/\/ 2. Kaydetme Butonu
\nprivate void btnKaydet_Click(object sender, EventArgs e)
\n{
\ntry
\n{
\nbaglanti.Open();
\nstring sorgu = “INSERT INTO Kitaplar (KitapAdi, Yazar, SayfaSayisi, YayinEvi) VALUES (@p1, @p2, @p3, @p4)”;
\nSqlCommand komut = new SqlCommand(sorgu, baglanti);<\/p>\n
komut.Parameters.AddWithValue(“@p1”, txtKitapAdi.Text);
\nkomut.Parameters.AddWithValue(“@p2”, txtYazar.Text);
\nkomut.Parameters.AddWithValue(“@p3”, Convert.ToInt32(txtSayfaSayisi.Text));
\nkomut.Parameters.AddWithValue(“@p4”, txtYayinEvi.Text);<\/p>\n
komut.ExecuteNonQuery();
\nMessageBox.Show(“Kitap ba\u015far\u0131yla kaydedildi.”);
\n}
\ncatch (Exception hata)
\n{
\nMessageBox.Show(“Kay\u0131t hatas\u0131: ” + hata.Message);
\n}
\nfinally
\n{
\nbaglanti.Close();
\nKitapListele(); \/\/ Listeyi g\u00fcncelle
\n}
\n}<\/p>\n
\/\/ 3. Silme Butonu
\nprivate void btnSil_Click(object sender, EventArgs e)
\n{
\nif (dgvKitaplar.SelectedRows.Count > 0)
\n{
\ntry
\n{
\nbaglanti.Open();
\nstring sorgu = “DELETE FROM Kitaplar WHERE KitapID = @id”;
\nSqlCommand komut = new SqlCommand(sorgu, baglanti);<\/p>\n
\/\/ DataGridView’de se\u00e7ili sat\u0131r\u0131n ilk h\u00fccresindeki (KitapID) de\u011ferini al\u0131r
\nint secilenId = Convert.ToInt32(dgvKitaplar.SelectedRows[0].Cells[“KitapID”].Value);
\nkomut.Parameters.AddWithValue(“@id”, secilenId);<\/p>\n
komut.ExecuteNonQuery();
\nMessageBox.Show(“Kitap ba\u015far\u0131yla silindi.”);
\n}
\ncatch (Exception hata)
\n{
\nMessageBox.Show(“Silme hatas\u0131: ” + hata.Message);
\n}
\nfinally
\n{
\nbaglanti.Close();
\nKitapListele(); \/\/ Listeyi g\u00fcncelle
\n}
\n}
\nelse
\n{
\nMessageBox.Show(“L\u00fctfen silmek istedi\u011finiz sat\u0131r\u0131 DataGridView \u00fczerinden se\u00e7in!”);
\n}
\n}
\n}
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"
— 1. Veritaban\u0131 Olu\u015fturma CREATE DATABASE KutuphaneDB; GO USE KutuphaneDB; GO — 2. Tablo Olu\u015fturma CREATE TABLE Kitaplar ( KitapID […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2724","post","type-post","status-publish","format-standard","hentry","category-genel"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2724","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=2724"}],"version-history":[{"count":1,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2724\/revisions"}],"predecessor-version":[{"id":2725,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2724\/revisions\/2725"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}