閲覧総計：&counter(); （本日：&counter(today); 昨日：&counter(yesterday);)
Accessデータを「キーワード検索」し、結果をGridViewに表示した。 09/09/20
↓参考にしたページ：「SqlDataSourceに条件検索を追加」
http://www.cocoaliz.com/asp.net/index/22/
→「[[検索(LINQtoXML)(3.5)]]」(09/9/6)と同一機能を実装し、比較可能とした。
開発環境：VWD2005 + Access2003
サーバ：ASP.NET2.0 + Access2003
【機能】検索キーワードを含む情報のみ抽出し、結果をGridViewに表示する。
検索キーワード(TextBox)が空なら全件表示、検索キーワードが入力されていれば
検索。
【稼働画面】
#ref(SearchGridView.JPG);
Accessデータベース名：udon.mdb
テーブル名：udons_sampleData
|~フィールド名|~データ型|~フィールドサイズ|
|ID (主キー)|オートナンバー型|長整数型|
|品名|テキスト型|100|
|セット内容|テキスト型|255|
|価格|数値型|整数型|
※VWD2005、ASP.NET2.0環境ではAccess2007のDBファイル形式(*.accdb)は利用できな
い模様。DBファイルは「Acces2002-2003形式(*.mdb)」で保存して利用する。
「キーワード検索」機能稼働ページの全コード
【SearchGridView.aspx】
<%@ Page Language="VB" Trace="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
'Selectパラメータをクリア
AccessDataSource1.SelectParameters.Clear()
'SelectCommandをセット（TextBoxが空ならば、全件を表示）
AccessDataSource1.SelectCommand = "SELECT [ID], [品名], [セット内容], [価格] FROM [udons_sampleData]"
If (TextBox1.Text <> "") Then
'TextBoxが空でないならば、WHERE条件を追加
'Selectパラメータをセット（KeyWordの頭に@は必要ないです。）
AccessDataSource1.SelectParameters.Add("KeyWord", "%" & TextBox1.Text & "%")
'WHERE条件を追加
AccessDataSource1.SelectCommand &= " WHERE (セット内容 LIKE @KeyWord)"
End If
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>無題のページ</title>
</head>
<body>
<form id="form1" runat="server">
<div>
キーワード検索の稼働確認(Access) 09/09/20<br />
「検索キーワード」が「セット内容」に含まれるメニュを表示<br />
<br />
検索キーワード：<asp:TextBox ID="TextBox1" runat="server" Width="180px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="検索" /><br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="AccessDataSource1" EmptyDataText="表示するデータ レコードがありません。" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="品名" HeaderText="品名" SortExpression="品名" />
<asp:BoundField DataField="セット内容" HeaderText="セット内容" SortExpression="セット内容" />
<asp:BoundField DataField="価格" HeaderText="価格" SortExpression="価格" />
</Columns>
<RowStyle BackColor="#F7F7DE" />
<FooterStyle BackColor="#CCCC99" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="App_Data\udon.mdb"
DeleteCommand="DELETE FROM `udons_sampleData` WHERE `ID` = ?"
InsertCommand="INSERT INTO `udons_sampleData` (`ID`, `品名`, `セット内容`, `価格`) VALUES (?, ?, ?, ?)"
SelectCommand="SELECT `ID`, `品名`, `セット内容`, `価格` FROM `udons_sampleData`"
UpdateCommand="UPDATE `udons_sampleData` SET `品名` = ?, `セット内容` = ?, `価格` = ? WHERE `ID` = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="品名" Type="String" />
<asp:Parameter Name="セット内容" Type="String" />
<asp:Parameter Name="価格" Type="Int16" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="品名" Type="String" />
<asp:Parameter Name="セット内容" Type="String" />
<asp:Parameter Name="価格" Type="Int16" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>
【参考にしたページ】
1.SqlDataSourceに条件検索を追加
http://www.cocoaliz.com/asp.net/index/22/
- http://www.marcjacobs.us.com/ http://www.designerhandbagsoutlet.com.co/ http://www.uggs-outletboots.in.net/ http://www.airjordans.us/ This http://www.bcbg-max-azria.ca/ result http://www.ralphslauren.org.uk/ is http://www.outletonline-michaelkors.com/ incredible, http://www.p90xworkout.in.net/ year-old http://www.tomsoutletonline.net/ children http://www.nike-air-max.ca/ raised http://www.coachoutlet-online.com.co/ stiffened http://www.michael-kors.com.co/ tripod, http://www.salomon-schuhe.com.de/ let http://www.burberryonlineshop.de/ alone http://www.rayban-sunglasses.org.uk/ in http://www.airmax-90.org/ the http://www.ferragamo.com.co/ vicinity http://www.toms--outlet.com.co/ of http://www.hollister.us.org/ these http://www.louboutin.jp.net/ mountains, http://www.tommy-hilfiger-canada.ca/ is http://www.nikestore.us/ in http://www.zxcoachoutlet.com/ the http://www.raybanwayfarer.in.net/ more http://www.airjordanshoes2015.com/ distant http://www.michaelkorshandbags.org.uk/ end http://www.nike-schoenen.co.nl/ of http://www.coachoutletstore.net.co/ the http://www.pandora-charms.org.uk/ earth http://www.rayban-sunglasses.us.org/ is http://www.thenorthface.com.de/ also http://www.michaelkorsoutlet.ar.com/ hard http://www.yoga-pants.net.co/ to http://www.jordanretro.org/ find. http://www.ralphlaurenpolos.in.net/ http://www.cheap-nike-shoes.net/ http://www.handbagsoutlet.com.co/ http://www.tory-burchoutletsale.us.com/ Village http://www.thomas-sabos.co.uk/ people http://www.timberlandshoes.net.co/ are http://www.kate-spade.in.net/ shocked http://www.bottega-veneta.us.com/ that http://www.giuseppezanotti.com.co/ the http://www.gucci-taschen-outlet.de/ patriarch http://www.abercrombieand-fitch.ca/ Dan http://www.ugg-boots-australia.com.au/ Yunfeng http://www.michael--kors.us.com/ also http://www.iphone-cases.net.co/ surprised, http://www.mizuno-running.net/ he http://www.rosherun.org.uk/ thought http://www.hilfigeroutlet.in.net/ Hao http://www.ralph-lauren.com.au/ stone http://www.the-northface.com.co/ age http://www.cheapshoes.com.co/ now http://www.converse.net.co/ still http://www.uptocoachoutlet.com/ can http://www.lululemoncanada.ca/ not http://www.pradashoes.com.co/ lift http://www.newbalance-outlet.org/ the http://www.nikemercurial.in.net/ mouth http://www.barbour-jacketsoutlet.com/ large http://www.abercrombie-kids.us.com/ tripod, http://www.uggscanada.ca/ wanted http://www.nike.org.es/ to http://www.ugg-boots.us.org/ talk http://www.louis-vuitton-australia.com.au/ actually http://www.truereligion-outlet.us.org/ done http://www.burberryoutletonlinesale.in.net/ in http://www.coco-chanel.com.de/ advance. http://www.coach-factoryoutlet.net.co/ http://www.burberry-outlet.mex.com/ http://www.beats-headphone.com.co/ http://www.nikefree-run.net/ "Is http://www.louis-vuittonoutletcanada.ca/ it http://www.lululemonoutlet.gb.net/ true, http://www.ugg-australia.in.net/ stone http://www.newoutletonlinemall.com/ Hao http://www.hermesbirkin-bag.net/ how http://www.tiffanyandco-canada.ca/ this http://www.coco-chanelbags.us.com/ little http://www.truereligionjeans.net.co/ guy http://www.beatsbydre.com.co/ is http://www.polo-outlets.com.co/ there http://www.mcmhandbags.com.co/ such http://www.abercrombiefitchsale.com/ a http://www.oakley-sunglasses-canada.ca/ big http://www.jordan-shoes.com.co/ effort, http://www.northfaceoutlet.com.co/ I http://www.harrods-london.co.uk/ have http://www.swarovskicrystal.com.co/ never http://www.pumaonline-shop.de/ heard http://www.swarovski-online-shop.de/ of http://www.maccosmetics.gr.com/ such http://www.michaelkorsbags.us.org/ a http://www.montblanc--pens.in.net/ child http://www.christianlouboutinshoesoutlet.org/ ah." http://www.michael-kors.com.es/ http://www.hermes-outlet.com.co/ http://www.ralph-laurenoutlet.ca/ http://www.michaelkors-uk.org.uk/ "I http://www.michael-kors-canada-outlet.ca/ was http://www.newbalance-shoes.org/ a http://www.christianlouboutinshoes.jp.net/ little http://www.louisvuittons.com.co/ weird, http://www.retro-jordans.com/ if http://www.nikeskos.dk/ he http://www.adidasshoes.top/ is http://www.nike-air-max.com.au/ not http://www.timberlandbootsoutlet.us.com/ a http://www.longchamp.com.co/ human http://www.louisvuitton-outlet.com.co/ body, http://www.guccishoes.us.org/ I http://www.thenorthfacejackets.net.co/ thought http://www.lauren-ralph.co.uk/ a http://www.nfl-jersey.us.com/ really http://www.reebok.com.de/ j http://www.guccihandbags.net.co/ Pacific http://www.omega-watches.us.com/ Heritage http://www.michael-kors.net.co/ kinds http://www.cheapmichaelkors.us.org/ of http://www.pandora-charms-canada.ca/ bastard http://www.louis--vuitton.org.uk/ came http://www.horloges-rolex.nl/ of http://www.wedding--dresses.ca/ it!" http://www.ralphlaurenoutletonline.us.org/ http://www.rolex-watches.me.uk/ http://www.the-north-face.ca/ http://www.tommy-hilfiger.co.nl/ Village http://www.cheap-baseballbats.net/ people http://www.michaelkorsoutlets-online.us.com/ recovered, http://www.chanelhandbags.net.in/ murmured http://www.thomas-sabo.com.de/ the http://www.nike-roshe-run.com.es/ little http://www.ugg-australia.com.de/ guy's http://www.insanity-workout.us.com/ performance http://www.tiffany-andco.com.au/ is http://www.oakley.org.es/ like http://www.hermesbags.jp.net/ a http://www.adidas.org.es/ thunder http://www.gucci-outletstore.com/ turned, http://www.fashionclothing.us.com/ it http://www.woolrich-clearance.com/ bursts http://www.juicycouture.com.co/ gripped http://www.ralphlaurenonlineshop.de/ was http://www.guccishoes.in.net/ deeply http://www.christian-louboutinshoes.com.co/ shocked. http://www.swarovskijewelry.com.co/ http://www.tiffanyandco.net.co/ http://www.guccishoes.com.co/ http://www.nikeshoesoutlet.org.uk/ "Have http://www.nike-roshe-run.de/ you http://www.truereligion-outlet.com.co/ been http://www.eyeglassesonline.us.com/ to http://www.tiffany-und-co.de/ some http://www.ferragamoshoes.in.net/ of http://www.raybans.us.org/ the http://www.supra-shoes.org/ patriarch http://www.katespadeoutlet.gb.net/ prosperous http://www.prada.com.de/ regions, http://www.adidas--canada.ca/ have http://www.rolexwatchesforsale.us.com/ seen http://www.tommy-hilfiger-online-shop.de/ this http://www.vans-schuhe.com.de/ child?" http://www.nikerosherun.us/ http://www.nikefactory.org/ http://www.babyliss.us.org/ http://www.omegarelojes.es/ "Yes http://www.swarovski-australia.com.au/ ah, http://www.nike-air-max.com.se/ Yunfeng http://www.poloralphlaurenoutlet.net.co/ you http://www.abercrombie-fitchs.us.com/ visited http://www.pulseras-pandora.com.es/ many http://www.michaeljordan.com.de/ powerful http://www.hollisteronlineshop.com.de/ tribes, http://www.hollister-clothing.in.net/ heard http://www.tory-burchshoesoutlet.com/ of http://www.longchampoutlet.com.co/ this http://www.michael-kors-outlet-online.us.org/ evildoer http://www.barbour-factory.com/ it?" http://www.converse.com.de/ Is http://www.ralphlaurenoutlet-online.us.com/ the http://www.tommy-hilfiger.com.de/ number http://www.pandorajewellery.com.au/ of http://www.cheaprayban.com.co/ old http://www.michaelkors.so/ people http://www.oakley--sunglasses.com.au/ sit http://www.replica-watches.com.co/ still, http://www.hollister-abercrombie.com.se/ can http://www.nike-huarache.nl/ not http://www.uggsaustralia.com.co/ help http://www.true-religion.com.co/ but http://www.louis-vuitton-taschen.com.de/ ask, http://www.bebeclothing.in.net/ do http://www.jordanrelease-dates.us.com/ not http://www.replicahandbags.in.net/ point http://www.the-northfaces.co.uk/ to http://www.celine-bags.org/ a http://www.michael-kors-taschen.com.de/ small http://www.burberryoutlet-sale.in.net/ performance http://www.cheap-uggboots.in.net/ shocked. http://www.christian-louboutin-shoes.ca/ http://www.airmax-2015.org/ http://www.christianlouboutinoutlet.net.co/ http://www.swarovskicanada.ca/ 石云峰 http://www.gucci--uk.co.uk/ said: http://www.nike-air-max.us/ "I http://www.coachblackfriday.com/ was http://www.ray-ban-outlet.us.com/ in http://www.rayban.com.de/ a http://www.converse-shoes.net/ big http://www.eyeglassframes.in.net/ tribal http://www.salvatoreferragamo.in.net/ millions http://www.nike-free-run.de/ of http://www.longchamp.us.org/ people http://www.uggs.co.nl/ have http://www.lululemon-australia.com.au/ seen http://www.ralphlaurenoutletonline.in.net/ a http://www.nikefree-run.org.uk/ few http://www.hogan.com.de/ special http://www.cheap-oakleysunglasses.in.net/ children, http://www.nikeair-max.es/ the http://www.ray--ban.ca/ days http://www.softballbats.in.net/ of http://www.toryburch-sandals.in.net/ longitudinal http://www.oakley.com.de/ information, http://www.chanel-bags.com.co/ staggering, http://www.louisvuitton.jp.net/ when http://www.gucci-outletsale.in.net/ young http://www.nike-air-max.com.de/ has http://www.yoga-pants.ca/ been http://www.new-balance.ca/ very http://www.rosheruns.us/ strong, http://www.michaelkors.com.se/ but http://www.michaelkorsoutletonline-sale.us.com/ I http://www.tommy-hilfigeroutlet.com/ think http://www.cheapjerseys.com.co/ more http://www.edhardy.us.org/ than http://www.adidas-superstar.de/ a http://www.longchamp-handbags.us.com/ small http://www.coach-handbags.com.co/ point http://www.ghd-hairstraightener.com/ but http://www.burberry-outletstore.net/ also http://www.air-huarache.co.uk/ slightly http://www.burberry-outletonline.gb.net/ worse http://www.uggs-onsale.net/ . http://www.prada-handbags.com.co/ " http://www.beatsbydrdre.co.com/ http://www.christianlouboutin.org.uk/ http://www.nike-air-force.de/ http://www.mcm-bags.in.net/ Village http://www.michaelkors.co.nl/ people http://www.the-northfacejackets.us.com/ heard http://www.polo-ralph-lauren.de/ togethers, http://www.louis-vuittonblackfriday.com/ then http://www.uggboots-clearance.net/ both http://www.coachfactory-outlet-online.in.net/ laughed, http://www.pandorajewelry.top/ this http://www.hollistercanada.ca/ is http://www.ralphslaurenoutlet.co.uk/ God http://www.christian--louboutin.in.net/ Ishimura http://www.cheapjerseys.us.org/ Houci! http://www.adidas-superstar.nl/ Swire http://www.pandora.com.de/ Xiongshou http://www.weddingdressesuk.org.uk/ a http://www.giuseppe-zanotti.net/ par http://www.nikestore.com.de/ cub http://www.basketballshoes.com.co/ child http://www.toryburchsale.com.co/ grow http://www.tiffany-jewelry.in.net/ up http://www.cheap-oakleys.us.com/ if http://www.adidas.com.se/ that http://www.rolex-watches.us.com/ terrible? http://www.uggboots.com.de/ ! http://www.michael-kors-australia.com.au/ Ishimura http://www.oakleysunglassescheap.in.net/ will http://www.michaelkorsoutlet-online.ar.com/ be http://www.michaelkors-outlet-online.com.co/ prosperous http://www.kate-spade.gb.net/ because http://www.asics-gel.de/ of http://www.ralphlaurenoutlet.us.com/ him. http://www.ray-ban-sunglasses-outlet.in.net/ http://www.coachoutletstore-online.com.co/ http://www.swarovski--uk.me.uk/ http://www.instylers.us.com/ Analysis http://www.louisvuitton.so/ of http://www.pradaoutlet.com.co/ an http://www.oakleysunglass.top/ old http://www.levisjeans.com.co/ man http://www.the-northface.net.co/ said: http://www.uggsoutlet.com.co/ "Those http://www.christian-louboutinshoes.com.co/ big http://www.adidas-schuhe-online.de/ tribal http://www.newbalance.com.es/ Qijiang http://www.nike-schuhe.com.de/ Sheng, http://www.ralphlaurenepolo.com/ Gaoshourulin, http://www.burberryoutlet-canada.ca/ certainly http://www.vans-shoes.co.uk/ hunted http://www.cheapoakleysunglasses.ar.com/ to http://www.moncler-outlet.us.org/ Xiongshou http://www.vans-shoes.net/ boundless http://www.tnfjackets.us.com/ horror, http://www.nike-skor.com.se/ a http://www.new-balance-schuhe.de/ rare http://www.tommyhilfiger.net.co/ species http://www.jimmychoo.net.co/ of http://www.oakleysunglasses.mex.com/ Pacific http://www.thejoreseproject.com/ Heritage http://www.hollisterclothingstore.org/ True http://www.michael-kors-handbags.us.com/ Blood http://www.abercrombie-hollister.nl/ is http://www.rayban.co.nl/ that http://www.bcbg-dresses.com/ several http://www.juicycoutureoutlet.net.co/ children http://www.nike-shoes-canada.ca/ temper http://www.rolex-watches-canada.ca/ extraordinary http://www.cheap-jordans.net/ talent, http://www.louisvuitton-outlets.us/ baptism http://www.pradahandbags.net.co/ flesh, http://www.nikefree5.net/ Otherwise http://www.uggboots.net.co/ the http://www.calvin-klein.us.com/ gap http://www.tomsshoes-outlet.org/ between http://www.burberry-handbagsoutlet.com.co/ small http://www.soccer-shoes.us.com/ point http://www.nike-rosherun.nl/ they http://www.burberry-outlets.co.uk/ may http://www.toms-shoes.net.co/ be http://www.chiflatiron.net.co/ greater http://www.maccosmetics.net.co/ in http://www.abercrombie-and-fitch.us.com/ some. http://www.air-max.com.de/ " http://www.rayban.org.es/ http://www.mmoncler-outlet.com/ http://www.beats-by-dre.com.co/ http://www.longchamp.com.de/ http://www.oakley-outletstore.us.com/ http://www.michael-kors-outlet.us.org/ http://www.uhren-shop.com.de/ -- [[crx]] &new{2015-12-26 (土) 17:04:13};
#comment_nospam
#vote(参考になった[0],ふつう[0],参考にならなかった[0])
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
