Asp ile veritaban\u0131ndan veri \u00e7ekmek ve ekrana yazd\u0131rmak i\u00e7in a\u015fa\u011f\u0131dakileri s\u0131ras\u0131yla uygulayal\u0131m.
\n\u0130lk \u00f6nce veritaban\u0131m\u0131zda a\u015fa\u011f\u0131daki gibi tablo oldu\u011funuz varsayal\u0131m
\nserver : localhost
\nveritabani ad\u0131 : eyurtsever
\nkullan\u0131c\u0131 : enver
\n\u015fifre : 123456
\n——————————————
\ntablomuzda \u015f\u00f6yle olsun:
\ntablo ad\u0131 : tblHaber
\nalanlar : id, baslik , detay ,resim
\n
\n\u00d6ncelikle veritaban\u0131 connection string imizi yazal\u0131m:(SQL veritaban\u0131 i\u00e7in)<\/p>\n
<% Set baglanti = Server.CreateObject(\"Adodb.Connection\") baglanti.Open \"driver={SQL Server};server=localhost ;uid= enver ;pwd=123456;database=eyurtsever\" %>\n<\/pre>\nbaglantimizi olu\u015fturduk ve \u015fimdi tablodan veri \u00e7ekelim
\n
\ne\u011fer en son eklenen veriyi \u00e7a\u011f\u0131rmak istiyorsak<\/p>\n
<% Set rs = baglanti.execute(\"select * from tblHaber order by id desc\") %>\n<\/pre>\n
\nilk eklenen veriyi \u00e7a\u011f\u0131rmak istiyorsak<\/p>\n
<% Set rs = baglanti.execute(\"select * from tblHaber order by id asc\") %>\n<\/pre>\n
\nE\u011fer ba\u015f harfine g\u00f6re \u00e7a\u011f\u0131rmak istiyorsak<\/p>\n
<% Set rs = baglanti.execute(\"select * from tblHaber order by baslik asc\") %>\n<\/pre>\n
\nKay\u0131t setimizi de olu\u015fturduk. \u015eimdi ekrana yazd\u0131ral\u0131m
\nE\u011fer sadece bir tane kay\u0131t getirmek istiyorsak<\/p>\n
Haber Ba\u015fl\u0131\u011f\u0131 : <%=rs(\"baslik\")%> <br \/>\nHaber Detay\u0131 : <%=rs(\"detay\")%>\n<\/pre>\n
\nB\u00fct\u00fcn kay\u0131tlar\u0131 getirmek istiyorsak d\u00f6ng\u00fcye sokmam\u0131z gerekiyor:<\/p>\n
<% do while not rs.eof %>\nHaber Ba\u015fl\u0131\u011f\u0131 : <%=rs(\"baslik\")%> <br \/>\nHaber Detay\u0131 : <%=rs(\"detay\")%>\n<% rs.movenext:loop %>\n<\/pre>\n
\nBelirli say\u0131da kay\u0131t getirmek istiyorsak
\n1. yol :
\nsorgumuza ” top ” kelimesini ekleriz:<\/p>\n
\"select top(5) * from tblHaber order by id desc\"\n<\/pre>\n2. yol<\/p>\n
<% i=0\ndo while not rs.eof and i<5 i=i+1 %>\nHaber Ba\u015fl\u0131\u011f\u0131 : <%=rs(\"baslik\")%> <br \/>\nHaber Detay\u0131 : <%=rs(\"detay\")%>\n<% rs.movenext:loop %>\n<\/pre>\n
\nve son olarak ba\u011flant\u0131m\u0131z\u0131 ve kay\u0131t setimizi kapatmay\u0131 unutmuyoruz. A\u00e7\u0131k b\u0131rak\u0131rsak veritaban\u0131m\u0131z loglarla zamanla \u015fi\u015fecektir.<\/p>\n
<% baglanti.close set baglanti = nothing rs.close set rs = nothing %>\n<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Asp ile veritaban\u0131ndan veri \u00e7ekmek ve ekrana yazd\u0131rmak i\u00e7in a\u015fa\u011f\u0131dakileri s\u0131ras\u0131yla uygulayal\u0131m. \u0130lk \u00f6nce veritaban\u0131m\u0131zda a\u015fa\u011f\u0131daki gibi tablo oldu\u011funuz varsayal\u0131m server : localhost veritabani ad\u0131 : eyurtsever kullan\u0131c\u0131 : enver \u015fifre : 123456 —————————————— tablomuzda \u015f\u00f6yle olsun: tablo ad\u0131 : tblHaber alanlar : id, baslik , detay ,resim<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[50,132,195,294],"_links":{"self":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/70"}],"collection":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/comments?post=70"}],"version-history":[{"count":1,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":595,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/70\/revisions\/595"}],"wp:attachment":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}