Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Database Display
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database Display

 Post Reply Post Reply
Author
ziwez0 View Drop Down
Groupie
Groupie


Joined: 15 July 2002
Location: United Kingdom
Status: Offline
Points: 144
Post Options Post Options   Thanks (0) Thanks(0)   Quote ziwez0 Quote  Post ReplyReply Direct Link To This Post Topic: Database Display
    Posted: 25 June 2003 at 5:17pm

I know in ASP you could use the Loop method to go through records, but in asp.net how do you do it?

the following code ive done displays a image 1 after the other but how do i get it to display 5 images in a row(and 5 after that etc)..

<%@ Import Namespace="System.Data.OleDb" %><script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("/database/photolib.mdb"))

dbconn.Open()
sql="SELECT smallimage FROM photo"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
photo.DataSource=dbread
photo.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script>

<form runat="server">
<asp:Repeater id="photo" runat="server"><HeaderTemplate>
<table border="1" width="100%">
<tr>
<th>Small Image</th>
</tr>
</HeaderTemplate><ItemTemplate>
<tr>
<td><img src="<%#Container.DataItem("smallimage")%>"></td>

</tr>
</ItemTemplate><FooterTemplate>
</table>
</FooterTemplate></asp:Repeater>
</form>



Edited by ziwez0
If anything takes long to do its worth doing.
Back to Top
FatOtis View Drop Down
Newbie
Newbie


Joined: 20 April 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote FatOtis Quote  Post ReplyReply Direct Link To This Post Posted: 28 June 2003 at 1:49pm

Hey dude I'm having the same sorta problem, I wanna use it to display only a set number of database records though (for a blog)

Tried looking over at w3schools.com/aspnet? *shrugs*

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.