閲覧総計：&counter(); （本日：&counter(today); 昨日：&counter(yesterday);)
蔵書管理の実務で、最近購入した新しい書籍をみんなに紹介する画面が効果的で
ある。Accessデータを用いた場合のその画面の作成法の備忘を記す。 09/09/20
【方法】
AccessDataSourceのプロパティのSelectQueryに
SELECT TOP 3 `ID`, `書籍名`, `購入日` FROM `蔵書` ORDER BY `購入日` DESC
と記述する。 データを「購入日」で降順ソートし、最初の３件を切り出す。
開発環境：VWD2005 + Access2003
サーバ：ASP.NET2.0 + Access2003
【稼働画面】
#ref(GridViewTop3.JPG);
Accessデータベース名：Books.mdb
テーブル名：蔵書
|~フィールド名|~データ型|~フィールドサイズ|
|ID (主キー)|オートナンバー型|長整数型|
|書籍名|テキスト型|100|
|購入日|日付/時刻型||
※VWD2005、ASP.NET2.0環境ではAccess2007のDBファイル形式(*.accdb)は利用できな
い模様。DBファイルは「Acces2002-2003形式(*.mdb)」で保存して利用する。
コントロールの設定値
|~コントロール|~プロパティ|~値|~コメント|
|AccessDataSource|SelectQuery|SELECT TOP 3 `ID`, `書籍名`, `購入日` FROM `蔵書` ORDER BY `購入日` DESC||
自動生成全コード
【GridViewTop3.aspx】
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>無題のページ</title>
</head>
<body>
<form id="form1" runat="server">
<div>
「最近購入の３冊」の表示法の稼働確認 09/09/20<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="AccessDataSource1" EmptyDataText="表示するデータ レコードがありません。">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="書籍名" HeaderText="書籍名" SortExpression="書籍名" />
<asp:BoundField DataField="購入日" HeaderText="購入日" SortExpression="購入日" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="App_Data\Books.mdb"
DeleteCommand="DELETE FROM `蔵書` WHERE `ID` = ?" InsertCommand="INSERT INTO `蔵書` (`ID`, `書籍名`, `購入日`) VALUES (?, ?, ?)"
SelectCommand="SELECT TOP 3 `ID`, `書籍名`, `購入日` FROM `蔵書` ORDER BY `購入日` DESC"
UpdateCommand="UPDATE `蔵書` SET `書籍名` = ?, `購入日` = ? WHERE `ID` = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="書籍名" Type="String" />
<asp:Parameter Name="購入日" Type="DateTime" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="書籍名" Type="String" />
<asp:Parameter Name="購入日" Type="DateTime" />
</InsertParameters>
</asp:AccessDataSource>
<br />
</div>
</form>
</body>
</html>
【参考にしたページ】
1.「最近購入の10冊」の表示方法 09/09/19
http://bbs.wankuma.com/index.cgi?mode=all&namber=41419
- http://www.oakleysunglassese.us.com/ http://www.oakley--sunglasses.com.co/ http://www.oakleysunglassesoutlet.us.org/ http://www.oakleysunglasses.us.com/ http://www.oakleysunglasses.com.co/ http://www.rayban-sunglass.us.com/ http://www.raybansunglasses.ar.com/ http://www.rayban--sunglasses.org/ http://www.polo-ralph-lauren.us.com/ http://www.poloralph-lauren-outlet.us.com/ http://www.burberry--outlet.us.com/ http://www.burberryoutlet-store.us.com/ http://www.michaelkors-outlet-online.us.org/ http://www.outletonline-michaelkors.com/ http://www.michaelkorsoutlets-online.us.com/ http://www.michael-korsoutlet.in.net/ http://www.michaelkors-outlet-store.us.com/ http://www.michaelkors-handbags.in.net/ http://www.uggs-outletboots.in.net/ http://www.uggs.us.com/ http://www.uggs-outlet.in.net/ http://www.cheapuggboots.in.net/ http://www.cheap-uggs.in.net/ http://www.louisvuitton-outlet-online.org/ http://www.louisvuitton-outlets.org/ http://www.louisvuitton.ar.com/ http://www.louisvuittonoutlet-store.us.com/ http://www.louis-vuittonhandbags.org/ http://www.redbottoms.in.net/ http://www.christianlouboutin-outlet.in.net/ http://www.christian-louboutin-shoes.in.net/ http://www.christian-louboutin.org.uk/ http://www.rolexreplicawatches.us.com/ http://www.replica--watches.com/ http://www.air-jordanshoes.net/ http://www.nikeoutlet.us/ http://www.toryburch-outletonline.in.net/ http://www.guccioutlet-online.us.com/ http://www.prada-handbags.in.net/ http://www.prada-outlet.in.net/ http://www.longchamp-outlet.in.net/ http://www.longchamphandbags.us.com/ http://www.longchamphandbagsoutlet.us.com/ http://www.tiffanyand-co.us.com/ http://www.tiffanyjewelry.us.com/ http://www.nikeairmaxinc.net/ http://www.nikeair-max.net/ http://www.nike-freerun.com/ http://www.chanelhandbags.ar.com/ http://www.katespadeoutlets.cc/ http://www.katespade-handbags.in.net/ http://www.coachoutlet.jp.net/ http://www.coachfactory-outletonline.in.net/ http://www.coachoutletstoreonline.jp.net/ http://www.coachpurse.in.net/ http://www.truereligionsale.in.net/ http://www.true-religion-jeans.in.net/ http://www.truereligionoutlets.in.net/ http://www.truereligioninc.in.net/ http://www.nike-airmax-pas-cher.fr/ http://www.nikeair-max.fr/ http://www.airjordanpas-cher.fr/ http://www.nikefreerun.fr/ http://www.nike-roshe-run.fr/ http://www.sac-longchamp-pas-cher.fr/ http://www.sac--longchamps.fr/ http://www.poloralphlauren-pascher.fr/ http://www.louboutin-pas-chere.fr/ http://www.sac-michaelkors-pascher.fr/ http://www.sac-burberry-pascher.fr/ http://www.lunette-oakley-pascher.fr/ http://www.lunette-rayban-pas-cher.fr/ http://www.hollister-abercrombiefitch.fr/ http://www.sachermes.fr/ http://www.vanspas-cher.fr/ http://www.timberland-paschere.fr/ http://www.newbalancesoldes.fr/ http://www.converse-pas-cher.fr/ http://www.the-north-face.fr/ http://www.niketnrequin-pascher.fr/ http://www.polo-lacoste-pascher.fr/ http://www.nikeblazerpaschere.fr/ http://www.nikeair-force.fr/ http://www.sac-guesspascher.fr/ http://www.sac-vanessa-bruno.fr/ http://www.scarpehogan--outlet.it/ http://www.rayban-sunglasses.me.uk/ http://www.michaelkorshandbags-uk.org.uk/ http://www.michaelkors-outlet-canada.ca/ http://www.michaelkors-outlet.ca/ http://www.lululemon-outlet-canada.ca/ http://www.hollisteruk.uk/ http://www.thenorth--face.co.uk/ http://www.mulberryhandbags-outlet.co.uk/ http://www.ralphlauren-outlet.co.uk/ http://www.nike--airmax.co.uk/ http://www.nikeairmax.org.uk/ http://www.nike-free-run.org.uk/ http://www.abercrombie-andfitch.org.uk/ http://www.nike-roshe-run.org.uk/ http://www.nike-trainers.org.uk/ http://www.nike-air-huarache.co.uk/ http://www.longchampbags.org.uk/ http://www.hollister-abercrombie.es/ http://www.vans-shoes-outlet.com/ http://www.nikerosherun.net/ http://www.mac-cosmetics.us.com/ http://www.abercrombieand-fitch.us.com/ http://www.hermesbirkinbags.com.co/ http://www.the-northfaceoutlet.us.com/ http://www.northface-outlet.in.net/ http://www.newbalance-shoes.in.net/ http://www.reebok-outlet.in.net/ http://www.lululemonoutlets.in.net/ http://www.cheap-nfljersey.in.net/ http://www.cheap-wedding-dresses.org/ http://www.beatsbydrdreheadphones.in.net/ http://www.montblanc-pens.in.net/ http://www.ferragamo-shoes.net/ http://www.giuseppe-zanotti.in.net/ http://www.instylerionicstyler.us.com/ http://www.babyliss.in.net/ http://www.mcmhandbags.org/ http://www.chiflatiron.cn.com/ http://www.insanityworkout.in.net/ http://www.ghd-hair-straighteners.org.uk/ http://www.bottegaveneta-handbagsoutlet.com/ http://www.valentino-shoes.us.com/ http://www.herveleger.us/ http://www.asicso.com/ http://www.soccer--shoes.net/ http://www.soccerjerseys.com.co/ http://www.celine-handbags.org/ http://www.p90x-workout.us.com/ http://www.jimmychoo-shoes.in.net/ http://www.hollister-clothing-store.us.com/ http://www.nike-airmax.nl/ http://www.baseball-bats.us/ http://www.iphone-cases.in.net/ http://www.ipadcases.us.com/ http://www.iphone6scases.us.com/ http://www.iphone6spluscases.us.com/ http://www.iphone6cases.us.com/ http://www.iphone6pluscases.in.net/ http://www.iphone5scases.us.com/ http://www.samsunggalaxys6cases.us.com/ http://www.timberlandboots.ar.com/ http://www.occhiali-oakley.it/ http://www.christian--louboutin.it/ http://www.ralph--lauren.it/ http://www.abercrombiehollister.it/ http://www.nikeair-max.it/ http://www.vansscarpe.it/ http://www.converse-allstar.it/ http://www.borse--gucci.it/ http://www.rayban--occhiali.it/ http://www.converse--shoes.com/ http://www.saclancelpascher.fr/ http://www.toms--shoes.net/ http://www.montrespas-cher.fr/ http://www.karenmillen.me.uk/ http://www.supra--shoes.com/ http://www.juicycoutureoutlet.jp.net/ http://www.juicycoutureoutlet.com.co/ http://www.marcjacobs.us.org/ http://www.cheapweddingdresses.org.uk/ http://www.replica--watches.me.uk/ http://www.hollister--canada.ca/ http://www.pandora-jewelry.us.com/ http://www.pandorajewelrys.us.com/ http://www.pandora--charms.in.net/ http://www.pandora--charms.org.uk/ http://www.linksoflondon.me.uk/ http://www.thomas-sabo-uk.org.uk/ http://www.swarovski-jewelry.in.net/ http://www.swarovski-uk.uk/ http://www.bottesugg-pas-cher.fr/ http://www.ugg-pas-cher.fr/ http://www.ugg-boots-uggs.co.uk/ http://www.ugg--australia.it/ http://www.uggs--canada.ca/ http://www.louis-vuitton-pas-cher.fr/ http://www.louisvuitton-sac.fr/ http://www.louis-vuitton-handbags.co.uk/ http://www.louisvuitton-canada.ca/ http://www.borse-louis-vuitton.it/ http://www.dolcegabbana.us.com/ http://coachofficialsite.blog.com/ http://www.canadagoose.net.co/ http://www.canada-goose-jackets.us.com/ http://www.canada-goose-outlet.us.com/ http://www.canada-goose-jackets.ca/ http://www.canadagoose-paschere.fr/ http://www.canada-goose.me.uk/ http://www.moncler.org.uk/ http://www.moncleroutlet.com.co/ http://www.monclerjackets.us.org/ http://www.doudoune-monclerpascher.fr/ http://www.barbour-jackets.org.uk/ http://www.moncler--outlet.it/ http://www.canada--goose.se/ http://www.moncleronline-shop.de/ http://www.moncler.org.es/ http://www.moncler.co.nl/ http://www.canadagooses.co.nl/ http://www.barbour.us.org/ http://www.ugg-australia.in.net/ http://www.michael-kors-outlet.us.org/ http://www.michaelkorsoutletonline-sale.us.com/ -- [[king]] &new{2016-02-22 (月) 14:44:52};
#comment_nospam
#vote(参考になった[0],ふつう[0],参考にならなかった[0])
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
