SQL Server Kullan\u0131c\u0131 kimlik do\u011frulamas\u0131 y\u00f6ntemleri
\n‘1 SQL kullan\u0131c\u0131s\u0131 kullanarak
\nData Source=SUNUCU;Initial Catalog=VERITABANIADI;User ID=VERITABANIKULLANICIADI;Password=SIFRE
\n\u20182 Entegre windows kimlik do\u011frulamas\u0131 i\u00e7in
\nData Source=SUNUCU;Initial Catalog=VERITABANIADI;Integrated Security=True<\/p>\n
‘ASP.Net \u00fczerinden Access veritaban\u0131<\/strong><\/span>na ba\u011flan\u0131p sorgu \u00e7al\u0131\u015ft\u0131ral\u0131m.A\u015fa\u011f\u0131daki \u00f6rnekte veritaban\u0131na ba\u011flan\u0131p kullan\u0131c\u0131 sorgulamas\u0131 yap\u0131l\u0131yor. sonuca g\u00f6re label \u00fczerine yaz\u0131 aktar\u0131l\u0131yor ASP.NET kullanarak Access de\u011filde SQL server<\/strong><\/span> \u00fczerine ba\u011flant\u0131 yapmak isterseniz SQL Server Kullan\u0131c\u0131 kimlik do\u011frulamas\u0131 y\u00f6ntemleri ‘1 SQL kullan\u0131c\u0131s\u0131 kullanarak Data Source=SUNUCU;Initial Catalog=VERITABANIADI;User ID=VERITABANIKULLANICIADI;Password=SIFRE \u20182 Entegre windows kimlik do\u011frulamas\u0131 i\u00e7in Data Source=SUNUCU;Initial Catalog=VERITABANIADI;Integrated Security=True ‘ASP.Net \u00fczerinden Access veritaban\u0131na ba\u011flan\u0131p sorgu \u00e7al\u0131\u015ft\u0131ral\u0131m.A\u015fa\u011f\u0131daki \u00f6rnekte veritaban\u0131na ba\u011flan\u0131p kullan\u0131c\u0131 sorgulamas\u0131 yap\u0131l\u0131yor. sonuca g\u00f6re label \u00fczerine yaz\u0131 aktar\u0131l\u0131yor ‘K\u00fct\u00fcphanelerimizi y\u00fckleyelim Imports System.Data.OleDb Imports System.Data Partial Class Uyegirisi Inherits System.Web.UI.Page ‘vt … Okumaya devam et “Vb.net\/ASP.Net veritaban\u0131 ba\u011flant\u0131s\u0131”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,13],"tags":[72,105,17,73],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-programlama","category-vb-net","tag-aspnet-ile-access-baglanti","tag-programlama","tag-vbnet","tag-visual-basic-komut-satirindan-veritabanina-baglanti"],"_links":{"self":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":11,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":270,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions\/270"}],"wp:attachment":[{"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.notsayfam.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n‘K\u00fct\u00fcphanelerimizi y\u00fckleyelim
\nImports System.Data.OleDb
\nImports System.Data
\nPartial Class Uyegirisi
\nInherits System.Web.UI.Page<\/code>
\n‘vt isimli bir ba\u011flant\u0131 tan\u0131ml\u0131yoruz ve ba\u011flant\u0131 satirini yaz\u0131yoruz
\nDim vt As New OleDbConnection(\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=users.mdb\")<\/code>
\n‘Veritaban\u0131 \u00fczerinde sql komutlar\u0131 \u00e7al\u0131\u015ft\u0131rabilmek i\u00e7in command tan\u0131mlayal\u0131m
\nDim komut As New OleDbCommand<\/code>
\n‘\u00c7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131z sorgu sonucunda elde edece\u011fimiz verileri datareader \u00fczerine y\u00fckl\u00fcyoruz.
\nDim veriler As System.Data.OleDb.OleDbDataReader
\nDim i As Integer
\nProtected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
\nTry<\/code>
\n‘veritaban\u0131n\u0131 a\u00e7al\u0131m
\nvt.Open()<\/code>
\n‘\u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z komutun hangi ba\u011flant\u0131 \u00fczerinde \u00e7al\u0131\u015faca\u011f\u0131n\u0131 atayal\u0131m
\nkomut.Connection = vt<\/code>
\n‘Sorgumuzu yazal\u0131m
\nkomut.CommandText = \"Select * from kullanicilar where kadi='\" & kadi.Text & \"'\"
\nkomut.ExecuteNonQuery()<\/code>
\n‘sorguyu \u00e7al\u0131\u015ft\u0131r\u0131p datalar\u0131 veriler isimli reader\u0131m\u0131za y\u00fckledik
\nveriler = komut.ExecuteReader
\ni = 0<\/code>
\n‘okumaya ba\u015flayal\u0131m. zatan o kullan\u0131c\u0131 ad\u0131n\u0131 i\u00e7eren tek kay\u0131t olacakt\u0131r
\nDo While veriler.Read
\ni = 1<\/code>
\n‘veri taban\u0131m\u0131zdaki alanlar (id,kullaniciadi,sifresi) \u015feklinde oldu\u011fundan elde etti\u011fimiz kay\u0131ttaki veriler(2) de\u011feri bize \u015fifreyi veriyor.
\nIf sifre.Text = veriler(2).ToString Then
\nFormsAuthentication.RedirectFromLoginPage(kadi.Text, hatirla.Checked)
\nElse
\nLabel1.Visible = True
\nLabel1.Text = \"Yanl\u0131\u015f \u015fifre girdiniz\"
\nEnd If
\nLoop
\nvt.Close()
\nCatch ex As Exception
\nMsgBox(ex.Message)
\nEnd Try<\/code>
\n‘E\u011fer sorgu sonucunda o kullan\u0131c\u0131 ad\u0131nda kimse yok ise veriler.read olamayaca\u011f\u0131ndan i halen 0 de\u011ferine e\u015fit olacak dolay\u0131s\u0131yla
\nIf i = 0 Then
\nLabel1.Text = \"Kullan\u0131c\u0131 ad\u0131n\u0131 kontrol ediniz.\"
\nLabel1.Visible = True
\nEnd If
\nEnd Sub <\/code><\/p>\n
\nyukar\u0131daki ba\u011flant\u0131 parametrelerini a\u015fa\u011f\u0131dakiler ile de\u011fi\u015ftirmeniz yeterli olacakt\u0131r.
\nImports System.Data
\nImports System.Data.Sql
\nImports System.Data.SqlClient
\nPartial Class Uyegirisi
\nInherits System.Web.UI.Page
\nDim vt As New SqlConnection
\nDim veriler As SqlDataReader
\nDim komut As SqlCommand
\nProtected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click<\/code>
\n‘Kimlik do\u011frulama y\u00f6ntemi olarak windows auth kullan\u0131rsak
\nvt.ConnectionString = \"Data Source=SUNUCUADI;Initial Catalog=VTADI;Integrated Security=True\"<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"