{"id":2220,"date":"2023-05-21T14:24:18","date_gmt":"2023-05-21T11:24:18","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2220"},"modified":"2025-04-22T10:19:25","modified_gmt":"2025-04-22T07:19:25","slug":"c-ile-windows-form-veritabani-baglantisi-yapmak-kaydet-islemi","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2023\/05\/21\/c-ile-windows-form-veritabani-baglantisi-yapmak-kaydet-islemi\/","title":{"rendered":"C# ile Windows Form Veritaban\u0131 Ba\u011flant\u0131s\u0131 Yapmak-Kaydet \u0130\u015flemi"},"content":{"rendered":"

\u00d6ncelikle Microsoft SQL Server Management Studio \u00dczerinde Kitaplar<\/strong><\/span> ad\u0131nda bir veritaban\u0131 olu\u015fturulur. ( Veritaban\u0131 olu\u015fturma konusu SQL<\/a> ba\u015fl\u0131\u011f\u0131 alt\u0131nda inceleyebilirsiniz.)<\/p>\n

\"\"<\/a><\/p>\n

Kitaplar ad\u0131nda Tablomuz \u00fcst k\u0131s\u0131mda g\u00f6sterildi\u011fi olu\u015fturulur.<\/p>\n

Daha sonra veritaban\u0131na ba\u011flanmak i\u00e7in SQL Connection nesnesinden faydalan\u0131l\u0131r. Bu nesneyi kullanabilmemiz i\u00e7in bir namespace tan\u0131mlamas\u0131 yapmam\u0131z gerekiyor. Formun \u00fczerine \u00e7ift t\u0131klayarak \u00fcst taraftaki kod bloklar\u0131na using System.Data.SqlClient; <\/span><\/strong>
\nkodunu ekleriz.<\/p>\n

\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.ComponentModel;\r\nusing System.Data;\r\nusing System.Drawing;\r\nusing System.Linq;\r\nusing System.Text;\r\nusing System.Threading.Tasks;\r\nusing System.Windows.Forms;\r\nusing System.Data.SqlClient;\r\n<\/pre>\n
Form Load olay\u0131na veritaban\u0131na ba\u011flant\u0131 i\u00e7in gerekli kodlar yaz\u0131l\u0131r.<\/p>\n
\r\n\r\n SqlConnection baglanti = new SqlConnection("Data Source=localhost; Initial Catalog=Kitaplar; Integrated Security=True;");\r\n            \/\/Kendi bilgisayar\u0131m\u0131z oldu\u011fundan localhost yada bilgisayar ad\u0131, Veritaban\u0131 ad\u0131 ve \u015fifresiz ba\u011flat\u0131 yap\u0131ld\u0131\u011f\u0131 belirtildi.\r\n baglanti.Open();\r\n            \/\/Uygulamay\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda hata vermezse ba\u011flant\u0131 ger\u00e7ekle\u015fmi\u015f demektir.\r\n\r\n<\/pre>\n
\"\"<\/a><\/p>\n
Yukar\u0131daki Form Elemanlar\u0131 Form’a eklenir.<\/p>\n
\r\npublic partial class Form1 : Form\r\n    {\r\n\r\n        SqlConnection baglanti = new SqlConnection("Data Source=ali\\\\SQLEXPRESS; Initial Catalog=Kitaplar; Integrated Security=True;");\r\n        \/\/Kendi bilgisayar\u0131m\u0131z oldu\u011fundan localhost, Veritaban\u0131 ad\u0131 ve \u015fifresiz ba\u011flat\u0131 yap\u0131ld\u0131\u011f\u0131 belirtildi.\r\n\r\n\r\n\r\n        public Form1()\r\n        {\r\n            InitializeComponent();\r\n        }\r\n\r\n\r\n\r\n        private void button1_Click(object sender, EventArgs e)\r\n        {\r\n\r\n            baglanti.Open();\r\n            \/\/Ba\u011flant\u0131 a\u00e7\u0131l\u0131yor.\r\n\r\n\r\n            SqlCommand cmd = new SqlCommand("insert into Kitaplar(KitapAdi,Yazar,SayfaSayisi) Values('"+TxtKitapAdi.Text+"','"+TxtYazar.Text+"',"+TxtSayfaSayisi.Text+")",baglanti);\r\n            \/\/SqlCommand nesnesi i\u00e7erisinde bir kaydet sorgusu olu\u015fturulur ve alan isimleri do\u011fru bir \u015fekilde girilir\r\n\r\n            cmd.ExecuteNonQuery();\r\n            \/\/SQL sorgusu \u00e7al\u0131\u015ft\u0131r\u0131l\u0131yor.\r\n\r\n            cmd.Dispose();\r\n            \/\/Command yani cmd nesnesi bellekte yer kaplamas\u0131n diye bo\u015falt\u0131l\u0131r.\r\n\r\n            baglanti.Close();\r\n            \/\/Ba\u011flant\u0131 kapat\u0131l\u0131yor.\r\n\r\n            baglanti.Dispose();\r\n            \/\/baglanti bo\u015falt\u0131l\u0131yor.\r\n\r\n\r\n\r\n        }\r\n    }\r\n}\r\n<\/pre>\n
Kaydet \u0130\u015flemi Kaydet Butonunun i\u00e7erisine yaz\u0131lan kodlarla tamamlan\u0131r.<\/p>\n
Not:<\/strong> Data Source=ali\\\\SQLEXPRESS bu k\u0131s\u0131ma siz kendi bilgisayar ad\u0131n\u0131z\u0131 girin.<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\r\nusing System;\r\nusing System.Data.SqlClient;\r\nusing System.Windows.Forms;\r\n\r\nnamespace WindowsFormsApp106\r\n{\r\n    public partial class Form1 : Form\r\n    {\r\n        string baglantiCumlesi = "Data Source=LAB3OGRTMEN\\\\SQLEXPRESS01; Initial Catalog=Kitaplar; Integrated Security=True;";\r\n\r\n        public Form1()\r\n        {\r\n            InitializeComponent();\r\n        }\r\n\r\n        private void button1_Click(object sender, EventArgs e)\r\n        {\r\n            \/\/ Sayfa say\u0131s\u0131n\u0131n ge\u00e7erli bir say\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol et\r\n            if (!int.TryParse(TxtSayfaSayisi.Text, out int sayfaSayisi))\r\n            {\r\n                MessageBox.Show("Sayfa say\u0131s\u0131 sadece rakamlardan olu\u015fmal\u0131d\u0131r!", "Uyar\u0131", MessageBoxButtons.OK, MessageBoxIcon.Warning);\r\n                return;\r\n            }\r\n\r\n            \/\/ Veritaban\u0131 ba\u011flant\u0131s\u0131 a\u00e7\u0131l\u0131r ve parametreli sorgu ile kay\u0131t yap\u0131l\u0131r\r\n            try\r\n            {\r\n                using (SqlConnection baglanti = new SqlConnection(baglantiCumlesi))\r\n                {\r\n                    baglanti.Open();\r\n\r\n                    string sorgu = "INSERT INTO Kitaplar (KitapAdi, KitapYazari, SayfaSayisi) VALUES (@adi, @yazar, @sayfa)";\r\n                    using (SqlCommand cmd = new SqlCommand(sorgu, baglanti))\r\n                    {\r\n                        cmd.Parameters.AddWithValue("@adi", TxtKitapAdi.Text);\r\n                        cmd.Parameters.AddWithValue("@yazar", TxtYazar.Text);\r\n                        cmd.Parameters.AddWithValue("@sayfa", sayfaSayisi);\r\n\r\n                        cmd.ExecuteNonQuery();\r\n                    }\r\n                }\r\n\r\n                MessageBox.Show("Kay\u0131t i\u015flemi ba\u015far\u0131yla tamamland\u0131.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);\r\n                \r\n                \/\/ Temizleme i\u015flemleri\r\n                TxtKitapAdi.Clear();\r\n                TxtYazar.Clear();\r\n                TxtSayfaSayisi.Clear();\r\n                TxtKitapAdi.Focus();\r\n            }\r\n            catch (Exception ex)\r\n            {\r\n                MessageBox.Show("Bir hata olu\u015ftu: " + ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);\r\n            }\r\n        }\r\n    }\r\n}\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Visual Studio ve Manegement Studio Kullanarak Veritaban\u0131 projesi <\/p>\n","protected":false},"author":1,"featured_media":2233,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11,180],"tags":[190,189],"class_list":["post-2220","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","category-programlama","category-sql","tag-c-ile-windows-form-veritabani-baglantisi","tag-c-ile-windows-form-veritabani-baglantisi-yapmak-kaydet-islemi"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2220","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=2220"}],"version-history":[{"count":12,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2220\/revisions"}],"predecessor-version":[{"id":2553,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2220\/revisions\/2553"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2233"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}