Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2005, 04:27 AM
sbo sbo is offline
Registered User
 
Join Date: Sep 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Datalist question

Hi all,

I have data from a table I wish to display. Having read through the forum I believe I need to use a datalist with "repeatcolumns" used to help format the table. One piece of information will be an image (4)and I would like the cell to span some rows as below.
  ________ ________ _______
 |___1____|____2___|___3___|
 | 4 |____5___|___6___|
 |________|____7___|___8___|

If anyone can point me in the right direction I would really appreciate it
Thanks
sbo

 
Old May 26th, 2005, 02:08 AM
Authorized User
 
Join Date: Sep 2003
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The Easy way is

Start your table and get your headings in

<table><tr>

<th>First Name</th>
<th>last Name</th>
 *************************** then
<tr>
 <%Do While MyrecordsShown AND NOT MyRS.EOF%>

 <td><%= MyRS.Fields (1) %>&nbsp;</td>
 <td><%= MyRS.Fields (2) %>&nbsp;</td>
</tr>
objPagingRS.MoveNext
Loop
' All done - close table
%>
  </table>

You can put anything you want in a table including Pictures but you are gonna complicate things if you only want to span the odd line, you would need to do a test to see if the database had a piccy
I would put trhe piccy in the end column and leave it blank or use a default piccy or Text if there was not not one

Topshed



 
Old May 31st, 2005, 09:39 PM
sbo sbo is offline
Registered User
 
Join Date: Sep 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Topshed,

I appreciate your help. I think I have it almost the way I want it. Just need some time to work on it now.

Regards
SBO






Similar Threads
Thread Thread Starter Forum Replies Last Post
Datalist inside datalist amit.jagtap ASP.NET 2.0 Professional 1 September 4th, 2007 05:03 AM
DataList <a Href> Question in Roles.aspx bekim BOOK: ASP.NET Website Programming Problem-Design-Solution 5 October 5th, 2004 02:54 PM
Datalist , Datagrid, or Repeater question olambe BOOK: ASP.NET Website Programming Problem-Design-Solution 7 June 1st, 2004 01:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.