Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK Beginning Expression Web ISBN: 978-0-470-07315-5
This is the forum to discuss the Wrox book Beginning Expression Web by Zak Ruvalcaba; ISBN: 9780470073155
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK Beginning Expression Web ISBN: 978-0-470-07315-5 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 August 20th, 2007, 04:15 PM
Registered User
 
Join Date: Aug 2007
Location: Shelton, WA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Viewing a single data record from a db

First off this is a great book, Thank you for publishing it..

I have been working through chapters 11 and 12 on databases's and accessing data. I have a Access 2007 database that I have saved as 2003 and the sql statement tests fine.However I can not get the data into the form View. I don't want anyone changing the record I just want them to be able to view it in that kind of a format. Am I using the right tool?

I was thinking about using a table and then figuring out how to parse the data so that I could do a simple table with the date in the Right hand col and the description for the data in the left hand col.

 
Old August 21st, 2007, 03:30 PM
Wrox Author
 
Join Date: Feb 2007
Location: San Diego, CA, USA.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The FormView control, like the DataList control requires customization via templates. You'll have to go into templated editing mode and modify them that way. If you're looking for something quick, then maybe the GridView or DetailsView controls are the way to go?

Now, if you don't mind a control that you have to go in and modify using templates, I would recommend the Repeater. The Repeater control is the most flexible because basically you're responsible for building the structure by hand. So you could switch to code view, build an HTML-based table, then add the Repeater control to one of the <tr> tags in the HTML table. Let me know if any of this makes sense or if you need more direction.

Thanks for the awesome comments and thanks for picking up the book.

Zak

 
Old August 31st, 2007, 11:14 AM
Registered User
 
Join Date: Aug 2007
Location: Shelton, WA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Zak,

I seem to be a little over my head on the repeater control and getting that to work for me. Willing to try almost anything..





Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Form Data against varchar DB record. iloveoatmeal Classic ASP Databases 16 July 2nd, 2007 01:40 PM
Help in appending a single record. prashanthmcr SQL Language 0 December 14th, 2005 08:47 PM
How do I append a single record ??? prashanthmcr SQL Language 3 December 14th, 2005 05:40 PM
"Single-Record" Recordset Wyatt70 Classic ASP Databases 2 November 18th, 2003 01:20 PM
Display a single record.. PLEASE HELP TnTandyO Classic ASP Databases 26 September 9th, 2003 10:34 AM





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