{"id":421,"date":"2010-06-25T13:02:58","date_gmt":"2010-06-25T13:02:58","guid":{"rendered":"http:\/\/www.erbugkaya.com\/?p=421"},"modified":"2014-01-16T23:48:44","modified_gmt":"2014-01-16T23:48:44","slug":"dinamik-web-sitesi-bolum-06-rastlantisal-randomize-icerik-olusturma","status":"publish","type":"post","link":"http:\/\/erbugkaya.com\/?p=421","title":{"rendered":"Dinamik Web Sitesi – B\u00f6l\u00fcm 06 – Rastlant\u0131sal (Randomize) \u0130\u00e7erik Olu\u015fturma"},"content":{"rendered":"

16\/5\/2007<\/em>
\nMerhaba bu makalemde Expression Web ile sayfalar\u0131n i\u00e7eriklerini database’den rastlant\u0131sal olarak \u00e7ekmeyi anlataca\u011f\u0131m. FRP Kitap Merkezi sitesi serisinin 6. makalesinde ana sayfam\u0131z\u0131 olu\u015fturaca\u011f\u0131z.<\/p>\n


\n\u0130lk \u00f6nce master page’den yeni bir sayfa yarat\u0131yoruz ve sayfay\u0131 default.aspx olarak kaydediyoruz. (Master page ve master page’den sayfa yaratma konular\u0131 i\u00e7in bu serinin 1. makalesini kontrol edebilirsiniz.) Ana sayfan\u0131z\u0131 index, default isimleriyle kaydedebilirsiniz. default.aspx olarak kaydedece\u011finiz sayfa ASP.NET projelerinde sorunsuz olarak \u00e7al\u0131\u015facakt\u0131r. Ana sayfam\u0131z\u0131 olu\u015fturdu\u011fumuza g\u00f6re \u015fimdi sayfan\u0131n i\u00e7eri\u011fini olu\u015fturmakla devam edebiliriz.<\/p>\n

Ana sayfaya her a\u00e7\u0131l\u0131\u015fta ve\/veya sayfa tekrar y\u00fcklendi\u011finde kitaplardan birinin detaylar\u0131yla ana sayfada g\u00f6z\u00fckmesini istiyoruz. Bunun i\u00e7in her \u015feyden \u00f6nce bir ba\u015fl\u0131k olu\u015fturaca\u011f\u0131z.\u00a0 Ba\u015flayal\u0131m. Content al\u0131nana Toolbox’dan bir DIV s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz. Bu ba\u015fl\u0131k DIV’i olacak. DIV se\u00e7iliyken Manage Style kutusundaki New Style’a bas\u0131p ba\u015fl\u0131k DIV’i i\u00e7in CSS kural\u0131m\u0131z\u0131 haz\u0131rl\u0131yoruz.<\/p>\n

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

Ba\u015fl\u0131\u011f\u0131m\u0131z haz\u0131r.<\/p>\n

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

<div id=”content”>
\n<div id=”homePageHeader”><\/div>
\n<\/div><\/div>\n
#homePageHeader {
\nbackground-color: #d2d2d2;
\nbackground-image: url(‘..\/images\/homePageHeader.jpg’);
\nbackground-repeat: no-repeat;
\nbackground-position: center;
\nborder: 1px solid #000000;
\nheight: 37px;
\n}<\/div>\n

Manage Style kutusunda #homePageHeader’\u0131 layout.css i\u00e7ine s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz. B\u00f6ylece default.aspx i\u00e7ine yaz\u0131lm\u0131\u015f CSS’i external CSS dosyas\u0131na ta\u015f\u0131m\u0131\u015f oluyoruz.<\/p>\n

\"\"<\/p>\n

Buraya kadar yapt\u0131klar\u0131m\u0131z\u0131n daha detayl\u0131 anlat\u0131mlar\u0131n\u0131 bu serinin ilk makalesinde bulabilirsiniz.<\/p>\n

\u015eimdi rastlant\u0131sal i\u00e7eri\u011fimizi haz\u0131rlayal\u0131m. Toolbox>ASP.NET Controls>Data alt\u0131ndan FormView’u content alan\u0131na s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz.<\/p>\n

\"\"<\/p>\n

FormView’a ait k\u00fc\u00e7\u00fck ok\u00e7ukla Common FormView Tasks kutusunu a\u00e7\u0131yoruz. Choose Data Source’da New Data Source’u se\u00e7iyoruz.<\/p>\n

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

Database i\u015flemlerinin a\u015fa\u011f\u0131daki ekrana gelene kadarki k\u0131sm\u0131n\u0131 bu serinin ikinci makalesinden kontrol edebilirsiniz. Configure Select Statement ekran\u0131nda “Specify a custom SQL or stored procedure”u i\u015faretleyip next’e bas\u0131yoruz.<\/p>\n

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

Gelen ekranda Select tab\u0131 se\u00e7iliyken SQL Statement’e alttaki sat\u0131r\u0131 yaz\u0131yoruz.<\/p>\n

SELECT TOP 1 * FROM [kitap] inner join [kitapDetay] on kitap.kitapID=kitapDetay.kitapDetayID ORDER BY NEWID ()<\/p>\n

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

Test Query ile verimizi kontrol ediyoruz. Test Query’e her bast\u0131\u011f\u0131n\u0131zda ba\u015fka bir kitab\u0131n gelmesi laz\u0131m.<\/p>\n

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

Common FormView Tasks’daki Edit Templates ile verilerimizi d\u00fczenlemeye ba\u015fl\u0131yoruz.<\/p>\n

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

Sildiklerimiz: kitapID tamamen, kitapIsmi ba\u015fl\u0131k, kitapImage tamamen, kitapID1 tamamen, kitapDetayID tamamen, aciklama ba\u015fl\u0131k.<\/p>\n

Ard\u0131ndan ba\u015fl\u0131klar\u0131 d\u00fczeltip, gerekli olanlara .boldText CSS’ni uyguluyoruz.<\/p>\n

\"\"<\/p>\n

\u015eimdi\u00a0 imaj\u0131 database’den \u00e7ekece\u011fiz. Bunun i\u00e7in Toolbox>ASP.NET Controls>Standard alt\u0131ndaki image’i s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz.<\/p>\n

\"\"<\/p>\n

Image ikonun ok\u00e7u\u011funa basarak Databindings’de ImageUrl’yi ayarl\u0131yoruz.<\/p>\n

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

Ard\u0131ndan imaja .imageLeft CSS’ni uyguluyoruz.<\/p>\n

\"\"<\/p>\n

Bu i\u015flemlerin daha detayl\u0131 anlat\u0131m\u0131n\u0131 makale serisinin 2. ve 3. makalelerinde bulabilirsiniz.<\/p>\n

Sonu\u00e7. Sayfay\u0131 her yeniledi\u011finizde ba\u015fka bir kitap g\u00f6z\u00fckecektir.<\/p>\n

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

Sitemizi tamamlamadan \u00f6nce son bir \u015fey kald\u0131 o da sayfalar\u0131n Title’lar\u0131. Bunun i\u00e7i sayfa a\u00e7\u0131k ve se\u00e7iliyken File>Properties’e bas\u0131yoruz.<\/p>\n

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

Gelen ekran\u0131n General tab\u0131nda Title alan\u0131na istedi\u011fimiz ibareyi yaz\u0131yoruz.<\/p>\n

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

Sonu\u00e7.<\/p>\n

\"\"<\/p>\n

Bu makalemde Expresiion Web’i kullanarak sayfalarda rastlant\u0131sal i\u00e7erik olu\u015fturmay\u0131 anlatt\u0131m.<\/p>\n

\u0130yi \u00e7al\u0131\u015fmalar<\/p>\n

Te\u015fekk\u00fcrler<\/p>\n","protected":false},"excerpt":{"rendered":"

16\/5\/2007 Merhaba bu makalemde Expression Web ile sayfalar\u0131n i\u00e7eriklerini database’den rastlant\u0131sal olarak \u00e7ekmeyi anlataca\u011f\u0131m. FRP Kitap Merkezi sitesi serisinin 6. makalesinde ana sayfam\u0131z\u0131 olu\u015fturaca\u011f\u0131z.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[29],"class_list":["post-421","post","type-post","status-publish","format-standard","hentry","category-teknik-yazi","tag-expression-web"],"_links":{"self":[{"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/posts\/421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=421"}],"version-history":[{"count":2,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":2536,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions\/2536"}],"wp:attachment":[{"href":"http:\/\/erbugkaya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/erbugkaya.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}