Bu yaz\u0131mda C# ile Sql veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131n kod yazarak nas\u0131l yap\u0131laca\u011f\u0131n\u0131 anlataca\u011f\u0131m.
\nVeritaban\u0131 ba\u011flant\u0131s\u0131 i\u00e7in MsSql \u00fczerinde veritaban\u0131m\u0131z\u0131 olu\u015fturuyoruz.Bunun yan\u0131nda veritaban\u0131m\u0131za ait kullan\u0131c\u0131 ad\u0131 ve \u015fifremizi belirliyoruz.Art\u0131k ba\u011flant\u0131 i\u00e7in elimizde yeterli verimiz var.C# ile MsSql veritaban\u0131 ba\u011flant\u0131s\u0131 i\u00e7in \u00f6nce namespace olara sql clienti projemize eklememiz gerekiyor. (using System.Data.SqlClient;) \u00d6rnek kod ve a\u00e7\u0131klamas\u0131 :
\n<\/p>\n
\nusing System.Data.SqlClient;\n \nnamespace SqlVeritaban\u0131Baglantisi\n{\n class Vt\n {\n public static string SQLserverIP = \"localhost\"\n public static string veritabaniADI = \"myDatabase\";\n public static string veritabanikullaniciadi = \"myUsername\";\n public static string veritabanisifre = \"myPassword\";\n \n public static SqlConnection Baglanti = new SqlConnection(\n \"Data Source='\" + SQLserverIP +\n \"';Initial Catalog='\"+ veritabaniADI +\n \"';Persist Security Info=True;+\n User ID='\"veritabanikullaniciadi +\n \"';Password='\" + veritabanisifre + \"';\");\n \n Baglanti.Open();\n BU KISMA SQL \u00dcZER\u0130NDE KULLANACA\u011eIMIZ KODLARI YAZIYORUZ.\n Baglanti.Close();\n }\n<\/pre>\n\u015eimdi kodumuzu a\u00e7\u0131klayal\u0131m.
\nSQLserverIP = \u201clocalhost\u201d sat\u0131r\u0131nda localhost kulland\u0131k bu kendi makinam\u0131zki sql servera ba\u011flant\u0131 i\u00e7in gerekiyor.Ba\u015fka bir makinadaki sqlservera ba\u011flanmak istersek buraya o makinan\u0131n ipsini giriyoruz.
\nveritabaniADI = \u201cmyDatabase\u201d; olu\u015fturdu\u011fumuz veritaban\u0131n\u0131n ad\u0131n\u0131n yaz\u0131laca\u011f\u0131 b\u00f6l\u00fcmd\u00fcr.
\nveritabanikullaniciadi = \u201cmyUsername\u201d; veritaban\u0131na ba\u011flanmak i\u00e7in gerekli kullan\u0131c\u0131 ad\u0131 yaz\u0131lan yerdir.
\nveritabanisifre = \u201cmyPassword\u201d; veritaban\u0131m\u0131za ba\u011flanmak i\u00e7in \u015fifremizi yazaca\u011f\u0131m\u0131z b\u00f6l\u00fcm.
\nArt\u0131k sqlBa\u011flant\u0131s\u0131 i\u00e7in gerekli sat\u0131r\u0131m\u0131z olan ba\u011flanti yaz\u0131yoruz.\u00d6rne\u011fimizde c\u00fcmle i\u00e7erisine gerekli yerlere yukar\u0131da belirtti\u011fimiz de\u011fi\u015fkenleri yazarak ba\u011flant\u0131 c\u00fcmlemizi tamaml\u0131yoruz.Asl\u0131nda sadece Baglanti c\u00fcmlesini kullanarak ve de\u011fi\u015fken kullanmadan buraya kadar olan sat\u0131r\u0131 k\u0131saltabilirdik.Ancak anla\u015f\u0131labilirlik ve kodun ilerde de\u011fi\u015ftirilmesinin kolayla\u015fmas\u0131 a\u00e7\u0131s\u0131ndan bu \u015fekilde yazmay\u0131 tercih ettik.
\nArt\u0131k elimizde bir ba\u011flant\u0131 c\u00fcmlemiz var ancak bu ba\u011flant\u0131 c\u00fcmlesini kullanmam\u0131z gerekiyor.Bunun i\u00e7in de sql ba\u011flant\u0131m\u0131z\u0131 a\u00e7\u0131yoruz bunu da Baglanti.Open(); ile yap\u0131yoruz.
\nBu a\u015famadan sonra ba\u011flant\u0131m\u0131z haz\u0131r.Baglanti.Open(); sat\u0131r\u0131n\u0131n alt\u0131na SQL sorgu c\u00fcmlelerimizi yazarak \u00e7al\u0131\u015ft\u0131r\u0131r\u0131z.En son k\u0131s\u0131mda ise Baglanti.Close() ile sql ile ba\u011flant\u0131m\u0131z\u0131 kapat\u0131r\u0131z.<\/p>\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131mda C# ile Sql veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131n kod yazarak nas\u0131l yap\u0131laca\u011f\u0131n\u0131 anlataca\u011f\u0131m. Veritaban\u0131 ba\u011flant\u0131s\u0131 i\u00e7in MsSql \u00fczerinde veritaban\u0131m\u0131z\u0131 olu\u015fturuyoruz.Bunun yan\u0131nda veritaban\u0131m\u0131za ait kullan\u0131c\u0131 ad\u0131 ve \u015fifremizi belirliyoruz.Art\u0131k ba\u011flant\u0131 i\u00e7in elimizde yeterli verimiz var.C# ile MsSql veritaban\u0131 ba\u011flant\u0131s\u0131 i\u00e7in \u00f6nce namespace olara sql clienti projemize eklememiz gerekiyor. (using System.Data.SqlClient;) \u00d6rnek kod ve a\u00e7\u0131klamas\u0131 :<\/p>\n","protected":false},"author":1,"featured_media":98,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[77,78,79,273,274],"class_list":["post-244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-c-sharp","tag-c-sharp-2","tag-c","tag-c-ile-mssql-veritabanina-kod-yazarak-baglanma","tag-mysql","tag-mysql-baglantisi-yapma"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=244"}],"version-history":[{"count":0,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}